Senior Data Warehouse Architect — Cloud & ETL Lead

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

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Life insurance

Disability insurance

HSA / FSA

Job summary

CareOregon, Inc. seeks a senior Data Warehouse Architect to design and optimize data models and ETL specifications across enterprise data systems. The role focuses on data analysis, system design, and governance, collaborating with vendors and internal teams.

The successful candidate will guide architecture decisions, ensure documentation quality, and drive performance improvements in cloud warehousing environments, while aligning with policy standards.

Qualifications

• Minimum 5 years of data warehouse architecture experience.
• Dimensional modeling experience
• Metadata management experience
• Data quality assessment
• Performance tuning and optimization
• ETL/ELT design
• Cloud warehousing solutions
• Proficiency with SQL
• Health insurance
• Systems analysis and design
• Agile/Scrum methodology

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.
• Analyze data sources and partner with leaders to balance business need and risk mitigation.
• Lead and provide direction in creating and managing data warehouse and analytics architecture.

Skills

SQL Server

ETL Tools

Cloud DW

Communication

Tools

SSIS

Azure Data Factory

Job description

CareOregon, Inc. seeks a senior Data Warehouse Architect to design and optimize data models and ETL specifications across enterprise data systems. The role focuses on data analysis, system design, and governance, collaborating with vendors and internal teams.

The successful candidate will guide architecture decisions, ensure documentation quality, and drive performance improvements in cloud warehousing environments, while aligning with policy standards.