Data Operations Engineer & Analyst; Data Warehouse Programmer​/Analyst

Data Operations Engineer & Analyst (Data Warehouse Programmer/Analyst)

Cal Optima

We are a mission driven community-based organization that serves member health with excellence and dignity, respecting the value and needs of each person. If you are ready to advance your career while making a difference, we encourage you to review and apply today and help us build healthier communities for all.

We are hoping you will join us as a Data Operations Engineer & Analyst (Data Warehouse Programmer/Analyst) and help shape the future of healthcare where you'll be an integral part of our Enterprise Data and Systems Integrations team, helping to strive for excellence while we serve our member health with dignity, respecting the value and needs of each of our members through collaboration with our providers, community partners and local stakeholders.

This position has been approved to be Full Telework
.

If telework is approved, you are required to work within the State of California only and if Partial Telework, also come in to the Main Office in Orange, CA, at least two (2) days per week minimum.

• 90% - Technical Responsibilities
• Participates in a mission driven culture of high-quality performance, with a member focus on customer service, consistency, dignity and accountability.
• Assists the team in carrying out department responsibilities and collaborates with others to support short and long-term goals/priorities for the department.
• Designs, supports and maintains scalable, modular ETL/ELT pipelines (e.g., SSIS, PySpark) for ingestion, transformation and delivery, embedding governance controls for data quality, lineage and compliance.
• Partners with the Data Warehouse team to co-develop solutions on the modern data platform (e.g., Snowflake, Databricks, Microsoft Fabric), embedding data quality, lineage and compliance requirements into engineering workflows.
• Modernizes legacy SQL-based transformations into parameterized, config-driven pipelines for reusability and scalability.
• Designs and maintains data pipelines for historical tracking, snapshots, handling slowly changing datasets and leveraging modern data platforms and frameworks.
• Contributes to continuous integration/continuous delivery (CI/CD) automation for data workflows, including version control (e.g., Git Hub), orchestration frameworks, and automated testing.
• Develops and maintains automation scripts to streamline data governance processes and operational tasks.
• Monitors and troubleshoots data workflows, resolving issues related to data movement, transformation, and system performance.
• Stays informed on emerging data technologies, tools and best practices, and proactively recommends enhancements to data engineering processes and platform capabilities.
• Supports end-to-end pipeline operations, including orchestration, monitoring, alerting and service level agreement (SLA) management using appropriate tools (e.g., Airflow).
• Implements data quality checks and anomaly detection as part of engineering workflows to ensure trust in analytical datasets.
• Partners with data engineers to optimize jobs, SQL queries and data platform workloads for performance and cost efficiency.
• Drives governance of the enterprise data platform to ensure consistent ingestion, naming conventions, schema management, and enrichment of data assets for reliable analytics.
• Partners with cybersecurity to implement robust data protection standards and maintain regulatory compliance (e.g., Health Insurance Portability and Accountability Act (HIPAA)) to reduce risk exposure.
• Tracks and reports governance maturity through key performance indicators (KPIs) and dashboards; contributes to policy development and council initiatives.
• Maintains clear documentation of data flows, definitions and validation processes to ensure transparency and traceability.
• Creates process maps and diagrams to support stewardship and communicate effectively with both technical and business stakeholders.
• Queries and analyzes large-scale health care datasets and business logic (e.g., claims, pharmacy, patient data) using SQL and other tools.
• Pro…