Senior Data Warehouse Architect — Cloud & ETL, Remote

CareOregon, Inc.; Portland (OR); Remote; USD 127,000 - 155,000; Full time

Benefits offered by this job

Health insurance

Job summary

CareOregon, Inc. is seeking a senior data warehouse architect to lead enterprise data architecture initiatives and design scalable data models and ETL specifications for a health-care oriented organization.

You will analyze data sources, coordinate with leaders across IS and business units, and guide governance, standards, and best practices for data warehouse development. This role emphasizes cloud warehousing, SQL proficiency, and Agile methods. Remote-friendly with Oregon focus.

Qualifications

• Minimum 5 years of data warehouse architecture experience.
• Experience with dimensional modeling and metadata management.
• Proficiency in SQL and cloud data warehousing.
• Strong communication and collaboration skills.
• Experience with Agile/Scrum methodologies.

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 operations.
• Analyze data sources with leaders across the organization to balance business needs and risk.
• Lead long-term data architecture goals and analytics architectures for IS and business.

Skills

Dimensional modeling

Metadata management

Data quality assessment

Performance tuning

ETL/ELT design

Cloud warehousing

SQL proficiency

Systems analysis and design

Agile/Scrum methodology

Communication skills

Tools

Microsoft SQL Server

SSIS

Azure Data Factory

Job description

CareOregon, Inc. is seeking a senior data warehouse architect to lead enterprise data architecture initiatives and design scalable data models and ETL specifications for a health-care oriented organization.

You will analyze data sources, coordinate with leaders across IS and business units, and guide governance, standards, and best practices for data warehouse development. This role emphasizes cloud warehousing, SQL proficiency, and Agile methods. Remote-friendly with Oregon focus.