Remote Data Warehouse Architect II — Cloud & Analytics

CareOregon, Inc.; Northern (KY); Hybrid; USD 114,000 - 139,000; Full time

Job summary

CareOregon, Inc. is seeking a Data Warehouse Architect II to design and develop data models, ETL specs, and analytics architectures. You will collaborate across teams to support data governance, data quality, and reporting initiatives, leveraging SQL Server and cloud warehousing tools.

Strong communication and vendor coordination are essential for success. Candidates with 2+ years in data warehousing, dimensional modeling, and Agile/Scrum experience will excel in this role, including healthcare

Qualifications

• Minimum 2 years' data design/data architecture experience.
• Experience with dimensional modeling, data quality assessment, SQL, Agile/Scrum, source-target mapping.
• Healthcare/managed care experience preferred.
• Metadata management, performance tuning, cloud warehousing.

Responsibilities

• Create data models for moderate to advanced subjects.
• Develop and maintain ETL specifications.
• Analyze data sources and assess risks and mitigation strategies.
• Participate in long-term data warehouse and analytics architecture planning.
• Coordinate with vendors and internal stakeholders.

Skills

Data modeling

ETL design

SQL

Agile/Scrum

Data analysis

Vendor coordination

Tools

SQL Server

Azure Data Factory

Snowflake/Redshift

SSIS

Job description

CareOregon, Inc. is seeking a Data Warehouse Architect II to design and develop data models, ETL specs, and analytics architectures. You will collaborate across teams to support data governance, data quality, and reporting initiatives, leveraging SQL Server and cloud warehousing tools.

Strong communication and vendor coordination are essential for success. Candidates with 2+ years in data warehousing, dimensional modeling, and Agile/Scrum experience will excel in this role, including healthcare