Remote Data Warehouse Architect — Cloud & Analytics

CareOregon, Inc.; Oregon; Hybrid; USD 114,000 - 139,000; Full time

Benefits offered by this job

Bonus opportunity

Total Rewards program

Job summary

CareOregon, Inc. is seeking an IS Data Warehouse Architect II to design and govern enterprise data warehouse solutions for health analytics. The role focuses on data modeling, ETL specifications, and contributing to analytics architecture.

The candidate will collaborate with vendors and internal teams, uphold standards, and drive performance and data quality across systems. Experience with SQL, cloud data warehousing, and data governance is essential.

Qualifications

• Minimum 2 years' of data design /data architecture experience and/ or minimum 2 years’ of data warehouse architecture experience.
• Experience should include some or all of the following: Dimensional modeling, Data quality assessment, Proficiency with SQL, Agile/Scrum methodology, Source Target mapping, Data Analysis.
• Preferred Experience in health care or managed care: Metadata management, Performance tuning and optimization, Cloud warehousing solutions, Health insurance, Systems analysis and design, Collaboration with technical and non-technical business groups, Liaison between business and developers, Translating requirements into a specification document.

Responsibilities

• Data Modeling and ETL Specifications: Create data models and moderate to advanced ETL specs; maintain documentation.
• Data Analysis: Analyze data sources and propose solutions with risks and mitigations.
• System Design and Architecture: Contribute to long-term data warehouse and analytics architecture planning; support reference architecture.
• Standards and Policy Administration: Propose standards for data modeling, ETL, and warehouse development; ensure compliance across systems.
• Vendor Coordination and Relations: Research vendors, present recommendations, maintain relationships with suppliers and service providers.

Job description

CareOregon, Inc. is seeking an IS Data Warehouse Architect II to design and govern enterprise data warehouse solutions for health analytics. The role focuses on data modeling, ETL specifications, and contributing to analytics architecture.

The candidate will collaborate with vendors and internal teams, uphold standards, and drive performance and data quality across systems. Experience with SQL, cloud data warehousing, and data governance is essential.