Data Warehouse Architect II — Remote (DW/ETL & Analytics)

CareOregon; Oregon (WI); On-site; USD 113,940 - 139,260; Full time

Benefits offered by this job

Bonus opportunity

Medical, dental, vision insurance

Employer retirement plan with employer

Paid PTO and sick time

Job summary

CareOregon is seeking an intermediate Data Warehouse Architect to design and develop data models and ETL specifications, analyze data, and contribute to system design and governance. The role emphasizes collaboration with stakeholders and vendors to ensure scalable data solutions.

The estimated hiring range is $113,940 to $139,260 with a 5% annual bonus target. Responsibilities include data modeling, ETL development, data analysis, architecture planning for data warehouses and dashboards, and

Qualifications

• Minimum 3 years’ of data warehouse architecture experience.
• Dimensional modeling experience.
• Data quality assessment experience.
• Proficiency with SQL.
• Experience with Agile/Scrum methodologies.
• Source to target mapping.
• Data analysis.

Responsibilities

• Data Modeling and ETL Specifications: Create data models for moderate to advanced subjects and develop ETL specs.
• Data Analysis: Analyze data sources and identify risks with mitigation.
• System Design and Architecture: Contribute to long-term data warehouse and dashboard architecture planning.
• Standards and Policy Administration: Propose standards for data modeling and warehouse development.
• Vendor Coordination and Relations: Work with vendors and provide recommendations.

Skills

Dimensional modeling

Data quality assessment

Proficiency with SQL

Agile/Scrum

Source to target mapping

Data analysis

Tools

Microsoft SQL Server

Snowflake

Redshift

SSIS

Azure Data Factory

Job description

CareOregon is seeking an intermediate Data Warehouse Architect to design and develop data models and ETL specifications, analyze data, and contribute to system design and governance. The role emphasizes collaboration with stakeholders and vendors to ensure scalable data solutions.

The estimated hiring range is $113,940 to $139,260 with a 5% annual bonus target. Responsibilities include data modeling, ETL development, data analysis, architecture planning for data warehouses and dashboards, and