IS Data Warehouse Architect II

CareOregon

Data Warehouse Architect designing and developing data models and ETL specifications. Conducting data analysis while managing vendor relations and contributing to architecture planning.

Posted 6/5/2026full-timeRemote • Idaho, Oregon, Texas, Utah, Wisconsin • 🇺🇸 United StatesMid-LevelSenior💰 $113,940 - $139,260 per yearWebsite

Tech Stack

Tools & technologies

ETLSQL

About the role

Key responsibilities & impact

Perform Data Warehouse Architecture at an intermediate level
Design and develop data models and ETL specifications
Conduct data analysis and recommend solutions
Participate in data warehouse and dashboard architecture planning
Propose requirements, standards, and best practices for data modeling and ETL
Conduct product and vendor research and present recommendations

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

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
Strong retirement plan with employer contributions
PTO and Paid State Sick Time accumulated based on hours worked/scheduled hours

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 & Tools

Data Warehouse ArchitectureData ModelingETLSQLDimensional ModelingData Quality AssessmentData AnalysisSource Target MappingAgileScrum