Senior Data Warehouse Architect - Remote/Work-From-Home

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

Benefits offered by this job

Health insurance

Retirement plan

Paid holidays

Job summary

CareOregon is seeking a senior data architecture professional to design and oversee data warehouse architectures, data models, and ETL specifications. You will analyze data, coordinate with vendors, and ensure adherence to standards and policies across IS and business teams.

The role emphasizes strategic system design, performance tuning, and cross-functional collaboration, with a focus on health care data domains and secure data handling.

Qualifications

• Minimum 5 years of data warehouse architecture experience.
• Expertise in dimensional modeling, metadata management, and data quality assessment.
• Proficient in SQL and ETL/ELT design; cloud warehousing (Snowflake/Redshift) experience.

Responsibilities

• Create data models for complex subjects and guide junior architects.
• Develop advanced ETL specifications to meet business data needs.
• Lead documentation and ensure design/operation alignment with standards.

Skills

Dimensional modeling

Metadata management

Data quality

SQL

Communication

Agile/Scrum

Cloud warehousing

ETL/ELT design

Tools

SSIS

Azure Data Factory

Snowflake

Redshift

Job description

CareOregon is seeking a senior data architecture professional to design and oversee data warehouse architectures, data models, and ETL specifications. You will analyze data, coordinate with vendors, and ensure adherence to standards and policies across IS and business teams.

The role emphasizes strategic system design, performance tuning, and cross-functional collaboration, with a focus on health care data domains and secure data handling.