Senior Data Warehouse Architect - Remote (Snowflake)

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

Benefits offered by this job

Health insurance

Retirement plan

Paid time off

Wellness program

Job summary

CareOregon, Inc. is seeking a senior data architect to lead data warehouse design, modeling, and ETL specification development. You will partner with leaders across the organization to deliver scalable analytics architectures and strong data governance.

The role emphasizes cloud warehousing, SQL proficiency, and collaboration with vendors to ensure robust data solutions for healthcare operations.

Qualifications

• Minimum 5 years of data warehouse architecture experience.
• Experience with dimensional modeling, metadata management and data quality.
• Proficiency in SQL, ETL/ELT design, and cloud warehousing solutions.

Responsibilities

• Create data models for complex subjects and guide junior architects.
• Create advanced ETL specifications to meet business data needs.
• Develop and maintain documentation including current design and operation.
• Lead data warehouse and analytics architecture development and strategy.

Skills

Data modeling

ETL design

SQL proficiency

Cloud warehousing

Documentation

Systems analysis

Agile/Scrum

Vendor coordination

Tools

Snowflake

Redshift

SSIS

Azure Data Factory

Job description

CareOregon, Inc. is seeking a senior data architect to lead data warehouse design, modeling, and ETL specification development. You will partner with leaders across the organization to deliver scalable analytics architectures and strong data governance.

The role emphasizes cloud warehousing, SQL proficiency, and collaboration with vendors to ensure robust data solutions for healthcare operations.