Job Closed
This listing is no longer active.
Making health care work for everyone.
IS Data Warehouse Architect II
Location
Arizona + 4 moreAll locations: Arizona | Montana | Oregon | Texas | Utah
Posted
110 days ago
Salary
$111.7K - $136.5K / year
Seniority
Senior
Job Description
IS Data Warehouse Architect II
CareOregon
• Perform Data Warehouse Architecture at an intermediate level • Focus on design and development of data models and ETL specifications • Conduct data analysis, system design and architecture • Propose requirements, standards, and best practices for data modeling • Conduct product and vendor research, and present recommendations
Job Requirements
- Minimum 3 years’ of data warehouse architecture experience
- Dimensional modeling experience
- Data quality assessment
- Proficiency with SQL
- Agile/Scrum methodology
- Source Target mapping
- Data Analysis
- Experience in health care or managed care (preferred)
- Metadata management (preferred)
- Performance tuning and optimization (preferred)
- ETL/ELT design (preferred)
- Cloud warehousing solutions (preferred)
- Health insurance Systems analysis and design (preferred)
Benefits
- Health insurance
- Dental insurance
- Vision insurance
- Life insurance
- AD&D insurance
- Disability insurance
- Health savings account
- Flexible spending account(s)
- Lifestyle spending account
- Employee assistance program
- Wellness program
- Discounts
- Multiple supplemental benefits (e.g., voluntary life, critical illness, accident, hospital indemnity, identity theft protection, pre-tax parking, pet insurance, 529 College Savings, etc.)
- Retirement plan with employer contributions
- PTO and Paid State Sick Time
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
Data Engineer III
PearsonPearson Virtual Schools, formerly Connections Education and a division within Pearson, is a leading provider of accountable, high-quality virtual education solutions for K-12 stude
• Develop repeatable ETL pipelines to feed team dashboards, reports, and analytics • Investigate underlying data to assist in production support efforts • Assist platform engineering team with in-app reporting and dashboard development • Work with adjacent teams to develop reliable data extracts that support their work • Implement validation checks and monitoring to maintain data integrity and consistency • Build tools to fabricate data sets for standing up product demos and to assist QA efforts • Perform other duties as assigned
Senior Data Engineer
ComfrtComfrt is one of the fastest-growing direct-to-consumer brands, dedicated to blending mental wellness, inclusivity, and elevated comfort into every piece we create. Our mission goes beyond clothing — we strive to build a community where everyone feels supported and seen.
Role Description We are seeking a highly skilled and experienced Senior Data Engineer to join our growing data team. The ideal candidate will be responsible for designing, developing, and optimizing our data pipeline architecture to support our analytics, machine learning, and business intelligence initiatives. This role requires a strong background in big data technologies, cloud infrastructure, and a passion for building robust, scalable, and efficient data solutions. Responsibilities - Data Architecture and Development: - Design, construct, install, test, and maintain highly scalable data management systems and processing pipelines using cloud-native services (e.g., AWS, GCP, Azure). - Develop and optimize ETL/ELT processes to ingest, transform, and load data from various internal and external sources into our data warehouse/data lake. - Implement data governance, security, and quality controls across all data pipelines. - Ensure data architecture supports the needs of data scientists, analysts, and other business stakeholders. - Optimization and Performance: - Monitor, tune, and optimize data warehouse performance (e.g., Snowflake, BigQuery, Redshift). - Troubleshoot and resolve complex data-related issues and performance bottlenecks in the data platform. - Drive continuous improvement in data platform reliability, efficiency, and cost management. - Collaboration and Mentorship: - Collaborate closely with data scientists, software engineers, and product managers to understand data requirements and deliver solutions. - Define and enforce best practices for data engineering, including coding standards, documentation, and operational procedures. - Mentor and guide junior data engineers, fostering a culture of technical excellence and continuous learning. Qualifications - Bachelor's or Master's degree in Computer Science, Engineering, or a related quantitative field. - 5+ years of professional experience in data engineering, software engineering, or a related role focused on data infrastructure. - Proven experience designing and building production-grade, highly reliable, and scalable data pipelines. - Expert proficiency in SQL and at least one high-level programming language (e.g., Python, Scala, Java). - Deep expertise with major cloud platforms (AWS, GCP, or Azure), specifically their data and storage services (e.g., S3, Google Cloud Storage, Azure Data Lake Storage). - Solid experience with modern data warehousing solutions (e.g., Snowflake, Google BigQuery, Amazon Redshift). - Experience with workflow orchestration tools (e.g., Apache Airflow, Dagster). - Familiarity with distributed data processing frameworks (e.g., Apache Spark, Dask). - Experience with version control systems (e.g., Git). - Experience with AI tools (Claude, Vertex AI, Gemini). Preferred Qualifications - Experience with stream processing technologies (e.g., Apache Kafka, Kinesis, Pub/Sub). - Exposure to GenAI Integration with development process. - Knowledge of data modeling techniques (e.g., 3NF, Dimensional Modeling). - Familiarity with machine learning pipelines (MLOps). - Experience with infrastructure-as-code tools (e.g., Terraform, CloudFormation). - Experience/Familiarity with D2C/E-Commerce Domain. Key Competencies - Problem-Solving: Exceptional analytical and problem-solving skills with a high degree of attention to detail. - Communication: Excellent verbal and written communication skills, with the ability to explain complex technical concepts to non-technical audiences. - Ownership: A proactive mindset and a strong sense of ownership over the data platform and its integrity. Benefits - Generous paid time off. - Company-covered health insurance. - 5% 401k match. - Discounts on all Comfrt products.
• Diseñar, implementar y mejorar soluciones de ingenieria de Datos • Contribuir en la arquitectura de datos • Liderar al equipo en buenas prácticas • Colaborar con otros equipos, y aprender continuamente.
Data Engineer
AllstateNational General Insurance, a division of Allstate, describes itself as one of the largest insurers in the United States. The company provides personal and commercial auto, recreat
• Build test scripts and execute testing • Collaborate with data scientists and business partners • Develop and deliver data infrastructure • Participate in the development of proof of concept designs



