remote
Data Warehouse Architect II - CareOregon
Software Engineer
Intermediate-level architect responsible for designing data models, defining ETL specifications, and shaping enterprise data warehouse solutions using SQL and advanced data modeling techniques.
About the role
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.
Skills
sqldata analysissystem design