Senior Data Warehouse Architect — Remote

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

Benefits offered by this job

Health insurance

Bonus opportunity

Retirement plan

Job summary

CareOregon, Inc. is seeking a senior data warehouse architect to design and develop complex data models, ETL specifications, and analytics architecture for enterprise data. This role guides junior architects and collaborates with stakeholders to deliver scalable data solutions.

You will lead data warehousing initiatives, ensure standards, and mentor teams while working remotely. A strong benefits package and competitive compensation accompany this position.

Qualifications

• Minimum 5 years of data warehouse architecture experience.
• Dimensional modeling experience.
• Metadata management experience.
• Data quality assessment experience.
• Performance tuning and optimization experience.
• ETL/ELT design experience.
• Cloud warehousing solutions experience.
• Proficiency with SQL.
• Health insurance experience is listed in duties.

Responsibilities

• Create data models for advanced to complex subjects and provide guidance to junior architects.
• Create advanced ETL specifications to meet business data needs.
• Develop and maintain documentation, including current design and operation.

Skills

SQL Server

ETL tools

Unit testing

Integration testing

Data modeling

Cloud warehousing

Performance tuning

Data analysis

Communication

Tools

Snowflake

Redshift

Azure Data Factory

SSIS

Job description

CareOregon, Inc. is seeking a senior data warehouse architect to design and develop complex data models, ETL specifications, and analytics architecture for enterprise data. This role guides junior architects and collaborates with stakeholders to deliver scalable data solutions.

You will lead data warehousing initiatives, ensure standards, and mentor teams while working remotely. A strong benefits package and competitive compensation accompany this position.