CalOptima Health is building high-impact clinical analytics that improve healthcare access for thousands of individuals and families. As a Sr Clinical Data Engineer (ITS Architect III), you will help design, build, and support the clinical reporting data foundation that powers operational reporting, regulatory reporting, Power BI dashboards, self-service analytics, and future AI-ready analytics. This role offers competitive compensation, a comprehensive benefits package, and Partial Telework with the requirement to work within California and come to the Main Office in Orange, CA at least two days per week.
Responsibilities
- Contribute to a mission-driven culture focused on customer service, consistency, dignity, and accountability.
- Support short- and long-term departmental goals by collaborating with team members and partners across the organization.
- Use clinical source-system expertise to create source-to-target mappings and validation logic for silver-layer conformed clinical models, and design, build, and maintain gold-layer clinical reporting marts.
- Partner with Enterprise Data Warehouse and platform teams to co-develop clinical analytics solutions on Snowflake and modern data platforms (including Databricks and Microsoft Fabric), embedding data quality, lineage, audit, and compliance requirements into engineering workflows in line with enterprise Data Governance policies and standards.
- Analyze clinical source data from MySQL databases, flattened tables, vendor extracts, APIs, and other clinical platforms, translating structures into scalable models and reporting-ready data products.
- Define and implement processes for data quality, reconciliation, validation, lineage, exception management, and production support for clinical reporting assets.
- Develop and document clinical metric definitions, semantic-layer requirements, and reporting logic for Power BI, Snowflake, and AI-ready analytics use cases, contributing definitions to the enterprise business glossary maintained by Data Governance.
- Develop and support reports and dashboards, including ETL (extraction, transformation, and loading) to meet business requirements.
- Assist end users with reporting and analysis activities and tools, and help support training, testing, documentation, and rollout.
- Create and maintain technical and business-facing documentation such as data dictionaries, source-to-target mappings, entity and metric definitions, transformation logic, and lineage.
- Collaborate with clinical stakeholders, business operations, analysts, data warehouse, BI developers, and IT teams to validate outputs, resolve reporting discrepancies, and align reporting with operational and regulatory needs.
- Maintain knowledge of business processes and application design, and complete other duties as assigned.
Requirements
- Bachelor’s degree in computer science, information systems, data engineering, healthcare informatics, or a related field, plus 8 years of professional experience in data engineering, analytics engineering, data architecture, business intelligence engineering, or clinical reporting. An equivalent combination of education and experience may qualify.
- 5 years of experience working with healthcare payer data.
- 5 years developing SQL-based transformations, reporting datasets, stored procedures (or equivalent data models), and reports using enterprise BI tools such as Power BI, Tableau, SSRS, or comparable platforms.
- 7 years hands-on experience designing and building data models, pipelines, SQL transformations, data quality controls, and reporting-ready datasets, including support for enterprise reporting, operational dashboards, regulatory reporting, or clinical analytics.
- 7 years experience with utilization management and regulated healthcare payer data and reporting, including prior authorization, inpatient/outpatient authorization, care management, appeals, and delegated network reporting.
Technologies
Snowflake, Databricks, Microsoft Fabric, MySQL, Power BI, Tableau, SSRS, dbt, Python, GitHub, Control-M, SSIS, DAX, FHIR, HL7, X12, Medicare, Medicaid/Medi-Cal
Benefits
- Competitive compensation with a hiring range of Pay Grade: 316 - $120,881 - $193,410 ($58.12 - $92.9856).
- Final salary based on education, job-related knowledge and experience, skills relevant to the role, and internal equity.
- Partial Telework (California only) with required in-office presence in Orange, CA at least two days per week.
- A comprehensive benefits package.
- CalPERS pension program and additional retirement packages.
- Generous PTO program and a quality work life balance.
- Various wellness programs, tuition reimbursement, and professional development with career development opportunities.
- Flexible scheduling.
- Work that directly supports healthcare access for individuals and families.
Additional Preferred Background
- Experience with Snowflake, modern ELT/ETL architecture, and pipeline and orchestration tools such as dbt, Python, GitHub, Control-M, or SSIS.
- Experience with Power BI, semantic models, DAX, canonical data models, dimensional models, data marts, data dictionaries, and source-to-target mappings.
- Experience with Medicare, Medicaid/Medi-Cal, commercial lines of business, interoperability standards (FHIR, HL7, X12), CMS interoperability requirements, data governance, metadata, lineage, and audit-ready reporting.
Application Notes
- Applications are accepted on a continuous basis until a sufficient number of qualified applications have been received.
- First review deadline: October 21, 2026 at 9:00 PM (PST).
- Applying early is encouraged, as applications after the first review date are not guaranteed consideration.
- The recruitment may close at any time without notice after the first review date.
- Selection may include skills assessment, phone screen, and interview, followed by reference and background check (including conviction record) and, where applicable, drug screening and/or a post-offer pre-employment medical examination.
- Keep an eye on your candidate portal and email (including SPAM).
