Data Warehouse Architect II

IS Data Warehouse Architect IIThis position performs Data Warehouse Architecture at an intermediate level. Essential responsibilities are focused on design and development of data models and ETL specifications, data analysis, system design and architecture, standards and policy administration, and vendor coordination and relations.

Estimated Hiring Range:

$113,940.00 - $139,260.00

Bonus Target:

Bonus - SIP Target, 5% Annual

Priority will be given to candidates residing in Oregon and Southwest Washington.

Current CareOregon Employees: Please use the internal Workday site to submit an application for this job.

Essential Responsibilities

Data Modeling and ETL Specifications

• Create data models for moderate to advanced subjects. • Create moderate to advanced ETL specifications to meet business data needs. • Develop and maintain appropriate documentation, including current design and operation.

Data Analysis

• Analyze data sources; research and recommend solutions which include potential risks and mitigation.

System Design and Architecture

• Participate in long-term data warehouse and dashboard architecture planning. • Participate in creating and managing moderate to advanced data warehouse and analytics architectures for use as reference and as input to solution development process

Standards and Policy Administration

• Propose requirements, standards and best practices for data modeling, ETL specifications, and data warehouse development. • Participate in the…