IS Data Warehouse Architect II

CareOregon

IS Data Warehouse Architect II designing and developing data models and ETL specifications for CareOregon. Involved in data analysis, system design, and vendor coordination with a focus on data integrity and standards.

Posted 7/21/2026full-timeRemote • Oregon • 🇺🇸 United StatesMid-LevelSenior💰 $113,940 - $139,260 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in Data Warehouse Architecture, focusing on design, development, and compliance with established standards. Proficient in SQL, ETL/ELT design, and dimensional modeling, with a strong emphasis on data analysis and cloud warehousing solutions.

Highest-signal resume keywords

Data Warehouse ArchitectureDimensional ModelingSQL ProficiencyETL/ELT DesignAgile/Scrum Methodology

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data AnalysisData Quality AssessmentSource Target MappingMetadata ManagementPerformance TuningCloud Warehousing Solutions

Industry Keywords

Health CareManaged CareHealth Insurance Systems Analysis

Tech Stack

Tools & technologies

CloudETLSQL

About the role

Key responsibilities & impact

Perform Data Warehouse Architecture at an intermediate level
Focus on design and development of data models and ETL specifications
Conduct data analysis, system design and architecture, standards and policy administration
Coordinate vendor relations and conduct product/vendor research
Create moderate to advanced data models and ETL specifications
Maintain documentation on design and operation
Analyze data sources and recommend solutions
Participate in long-term data warehouse and dashboard architecture planning
Manage existing systems compliance with established standards

Requirements

What you’ll need

Minimum 3 years of data warehouse architecture experience
Dimensional modeling experience
Data quality assessment
Proficiency with SQL
Agile/Scrum methodology
Source Target mapping
Data Analysis
Preferred experience in health care or managed care
Metadata management
Performance tuning and optimization
ETL/ELT design
Cloud warehousing solutions
Health insurance systems analysis and design

Benefits

Comp & perks

Health insurance
Dental insurance
Vision insurance
Life insurance
AD&D insurance
Disability insurance
Health savings account
Flexible spending account(s)
Lifestyle spending account
Employee assistance program
Wellness program
Discounts
Multiple supplemental benefits (e.g., voluntary life, critical illness, accident, hospital indemnity, identity theft protection, pre-tax parking, pet insurance, 529 College Savings, etc.)
Strong retirement plan with employer contributions
PTO and Paid State Sick Time based on hours worked/scheduled hours and the primary work state
Paid holidays
Volunteer time
Jury duty
Bereavement leave