Data Warehouse Architect II - CareOregon

Key Responsibilities

• Design and develop robust data models for moderate to advanced subject areas, ensuring alignment with business requirements and data governance standards.
• Specify, document, and optimize ETL processes, leveraging SQL and ETL tools to extract, transform, and load data efficiently.
• Collaborate with cross‑functional teams to analyze data needs, translate them into technical specifications, and validate solutions through rigorous testing.
• Lead system design discussions, establishing architecture patterns, performance benchmarks, and scalability strategies for the data warehouse platform.
• Maintain and enforce data warehouse standards, policies, and best practices, ensuring consistency across the organization.
• Coordinate with external vendors and internal stakeholders to integrate third‑party data sources and manage data quality initiatives.

Requirements

• 3+ years of experience in data warehouse architecture, data modeling, and ETL development.
• Hands‑on experience with ETL tools (e.g., Informatica, SSIS, Talend) and data integration best practices.
• Excellent analytical, problem‑solving, and communication skills, capable of translating complex business needs into technical solutions.
• Experience working in a collaborative, vendor‑centric environment and managing data governance initiatives.