Sr Clinical Data Engineer (ITS Architect III)

CalOptima Health is hiring a Senior Clinical Data Engineer to 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-enabled analytics. This role supports a mission-driven environment that emphasizes high-quality performance, customer service, consistency, dignity, and accountability.

This position is approved for partial telework, with the requirement to work within California and come to the Main Office in Orange, CA at least two days per week.

What You’ll Do

• Help maintain a customer-focused, accountable team culture while supporting department short- and long-term goals and priorities.
• Provide source-system expertise, including source-to-target mappings and validation logic for silver-layer conformed clinical models.
• Design, build, and maintain gold-layer clinical reporting marts sourced from enterprise conformed silver models.
• Collaborate with Enterprise Data Warehouse and platform teams to co-develop clinical analytics solutions on Snowflake and modern data platforms such as Databricks and Microsoft Fabric, embedding data quality, lineage, audit, and compliance requirements into engineering workflows aligned to enterprise Data Governance.
• Analyze clinical source-system data from MySQL databases, flattened tables, vendor extracts, APIs, and other clinical platforms, translating source structures into scalable models and reporting-ready data products.
• Define and implement data quality, reconciliation, validation, lineage, exception management, and production-support processes 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, including contributing definitions to the enterprise business glossary maintained by Data Governance.
• Participate in development of business and functional requirements for reports.
• Design, develop, test, and implement reports and dashboards, including ETL, to fulfill business requirements.
• Support users with reporting and analysis activities and tools, and assist with testing, documentation, training, and rollout of reporting and end-user reporting tools.
• Maintain documentation for technical and business audiences, including data dictionaries, source-to-target mappings, entity and metric definitions, transformation logic, and lineage.
• Partner with clinical stakeholders, business operations, analysts, data warehouse, BI developers, and IT teams to validate outputs, resolve reporting discrepancies, and align deliverables to operational and regulatory needs.
• Maintain knowledge of business processes and application design, understand cross-functional relationships, and complete other duties as assigned.

Minimum Qualifications

• 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 (or an equivalent combination of education and experience).
• 5 years 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 related to 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.
• Current hiring range: Pay Grade 316 - $120,881 - $193,410 ($58.12 - $92.9856).
• Final salary depends on education, job-related knowledge and experience, relevant skills, and internal equity.
• Partial telework is approved (California only if telework).
• Comprehensive benefits package, including CalPERS pension and additional retirement packages.
• Generous PTO program, quality work-life balance, wellness programs, tuition reimbursement, professional and career development opportunities, and flexible scheduling.
• Work directly impacts and improves healthcare access for thousands of individuals and families.

Additional Value

• Experience with Snowflake, modern ELT/ETL architecture, 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, healthcare interoperability standards (FHIR, HL7, X12), CMS interoperability requirements, data governance, metadata, lineage, and audit-ready reporting.

Application Process

• 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 after the first review date does not guarantee consideration.
• This recruitment may close at any time without notice after the first review date.

Selection and Screening

• Application and resume review by a dedicated recruiter.
• Selection process may include a skills assessment, phone screen, and interview.
• Reference and background check will be required, including a conviction record; drug screening and/or a post-offer pre-employment medical examination may be required for specific positions.
• Internal CalOptima Health applicants should apply through the internal portal on InfoNet.
• Candidates will be updated through the candidate portal, and should check email regularly (including spam).