IS Data Warehouse Architect II

CareOregon, Inc.; Portland (OR); Remote; USD 90,000 - 120,000; Full time

Job summary

A leading company is seeking an IS Data Warehouse Architect II to design and develop data models and ETL specifications. This fully remote role requires strong skills in data warehouse architecture and SQL, with a focus on collaboration and problem-solving. Candidates should have experience in healthcare and cloud solutions.

Qualifications

• Minimum 3 years’ experience in data warehouse architecture.
• Experience in healthcare and cloud warehousing solutions preferred.

Responsibilities

• Create data models for moderate to advanced subjects.
• Develop and maintain documentation for current design and operation.

Skills

Data Modeling

SQL Proficiency

Agile/Scrum

Data Analysis

Effective Communication

Problem Solving

Tools

Microsoft SQL Server

Snowflake

Azure Data Factory

Job description

Join to apply for the IS Data Warehouse Architect II role at CareOregon.

4 days ago Be among the first 25 applicants.

This position performs Data Warehouse Architecture at an intermediate level. Essential responsibilities include designing and developing data models and ETL specifications, data analysis, system design and architecture, standards and policy administration, and vendor coordination.

Responsibilities

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

Qualifications

• Minimum 3 years’ experience in data warehouse architecture, including data modeling, data quality assessment, SQL proficiency, Agile/Scrum, source-target mapping, and data analysis.

Preferred qualifications include experience in healthcare, metadata management, performance tuning, ETL/ELT design, Snowflake, Azure, cloud warehousing solutions, and systems analysis.

Knowledge, Skills, and Abilities

• Knowledge of Microsoft SQL Server, cloud data warehousing tools like Snowflake or Redshift, ETL tools such as SSIS or Azure Data Factory.
• Effective communication, collaboration, problem-solving, and stress management skills.

Additional Information

This is a fully remote position, but candidates must reside in Oregon, Washington, Utah, Idaho, Arizona, Nevada, Texas, Montana, or Wisconsin.

CareOregon is committed to diversity and inclusion, strongly encourages candidates of color and veterans to apply.