Senior Data Warehouse Architect | Cloud DW & ETL Lead

CareOregon, Inc.; Idaho; Remote; USD 127,000 - 155,000; Full time

Benefits offered by this job

Health insurance

Wellness program

Total Rewards Program

Job summary

CareOregon, Inc. is seeking a senior data warehouse architect to lead the design and development of data models and ETL specifications for enterprise analytics.

The role focuses on data analysis, system design, standards, and policy administration while coordinating with vendors and leaders across the organization. The candidate should have at least five years of data warehouse experience, strong SQL skills, and cloud warehousing exposure (Snowflake/Redshift).

Qualifications

• Minimum 5 years of data warehouse architecture experience.
• Experience with data modeling, ETL/ELT design, and data quality assessment.
• Familiarity with cloud warehousing and SQL proficiency.

Responsibilities

• Create data models for complex subjects and guide junior architects.
• Develop advanced ETL specifications to meet business needs.
• Maintain documentation of current design and operations.

Skills

Data warehouse architecture

ETL design

SQL proficiency

Cloud data warehousing

Vendor coordination

Communication skills

Agile/Scrum

Tools

SSIS

Azure Data Factory

Snowflake

Redshift

Job description

CareOregon, Inc. is seeking a senior data warehouse architect to lead the design and development of data models and ETL specifications for enterprise analytics.

The role focuses on data analysis, system design, standards, and policy administration while coordinating with vendors and leaders across the organization. The candidate should have at least five years of data warehouse experience, strong SQL skills, and cloud warehousing exposure (Snowflake/Redshift).