Remote Data Warehouse Architect II (ETL/SQL)

CareOregon, Inc.; Oregon (WI); Hybrid; USD 113,940 - 139,260; Full time

Job summary

CareOregon, Inc. seeks an IS Data Warehouse Architect II to design and develop data models, ETL specifications, and analytics architecture.

The role integrates data modeling, data analysis, system design, and policy administration with vendor coordination. This remote-friendly position offers a competitive salary range, bonus target, and a comprehensive benefits program; the candidate will work with MS SQL Server, cloud warehousing tools like Snowflake or Redshift, and ETL tools such as SSIS or

Qualifications

• Minimum 3 years’ of data warehouse architecture experience.
• Dimensional modeling experience.
• Data quality assessment and proficiency with SQL.
• Agile/Scrum methodology.

Responsibilities

• Create data models for moderate to advanced subjects.
• Create moderate to advanced ETL specifications to meet business data needs.
• Analyze data sources; research and recommend solutions including risks and mitigation.
• Participate in long-term data warehouse and dashboard architecture planning.

Skills

SQL

Dimensional modeling

ETL/ELT design

Data analysis

Cloud data warehousing

Agile/Scrum

Tools

SSIS

Azure Data Factory

Snowflake

Redshift

SQL Server

Job description

CareOregon, Inc. seeks an IS Data Warehouse Architect II to design and develop data models, ETL specifications, and analytics architecture.

The role integrates data modeling, data analysis, system design, and policy administration with vendor coordination. This remote-friendly position offers a competitive salary range, bonus target, and a comprehensive benefits program; the candidate will work with MS SQL Server, cloud warehousing tools like Snowflake or Redshift, and ETL tools such as SSIS or