CalOptima Health seeks a Sr Clinical Data Engineer (ITS Architect III) to design, build, and support a clinical reporting data foundation used for operational reporting, regulatory reporting, Power BI dashboards, self-service analytics, and future AI-enabled analytics.
Role Location and Telework
Orange, CA (hybrid). Approved for Partial Telework, with requirements to work within California and to come to the Main Office in Orange, CA at least two days per week.
Key Responsibilities
- Support a mission-driven culture focused on customer service, consistency, dignity, and accountability.
- Assist the team with department responsibilities and collaborate to support short- and long-term priorities.
- Apply source-system expertise by contributing source-to-target mappings and validation logic to silver-layer conformed clinical models.
- Design, build, and maintain gold-layer clinical reporting marts sourced from enterprise conformed silver models.
- Partner with the 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 with enterprise data governance.
- Analyze clinical data from sources including MySQL databases, flattened tables, vendor extracts, APIs, and other clinical platforms to translate 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, and contribute 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, along with ETL, to fulfill business requirements.
- Support users with reporting and analysis activities and tools.
- Create and maintain technical and business-facing documentation, including 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 discrepancies, and ensure reports and dashboards align with operational and regulatory needs.
- Support user training, testing, documentation, and the rollout of reports and end-user reporting tools.
- Maintain knowledge of business processes and application design and understand cross-functional relationships and their use of information.
- Perform other duties as assigned.
Required 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. An equivalent combination of education and experience may be qualifying.
- 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, including prior authorization and inpatient/outpatient authorization, care management, appeals, delegated network reporting, or regulated healthcare payer data and 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
Preferred Experience
- 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.
Compensation and Benefits
- Competitive compensation for the role.
- Current hiring range: Pay Grade 316: $120,881 - $193,410 (58.12 - 92.9856).
- Final salary depends on education, job-related knowledge and experience, role-relevant skills, and internal equity.
- Comprehensive benefits package, including CalPERS pension program and additional retirement packages.
- Generous PTO and support for quality work life balance.
- Wellness programs, tuition reimbursement, professional and career development opportunities.
- Flexible scheduling.
- Work that directly impacts and improves healthcare access for thousands of individuals and families.
Additional Knowledge and Ability Areas
- Develop rapport and maintain effective working relationships with leadership, staff, and external contacts across diverse backgrounds.
- Work independently and exercise sound judgment.
- Communicate clearly and concisely orally and in writing.
- Work a flexible schedule, including availability for evening and weekend events.
- Organize, analyze, problem-solve, and apply project management skills in a fast-paced environment.
- Manage multiple projects and identify collaboration opportunities internally and externally.
- Support motivation and leadership for multi-program teams and external committees or coalitions.
- Use computer and relevant applications to produce correspondence, charts, spreadsheets, and other information for assigned tasks (including Microsoft Office tools such as Word, Outlook, Excel, and PowerPoint).
Work Environment
- If located at the 500, 505 Building or a remote work location: typically indoors and sedentary; subject to schedule changes and/or variable work hours, with travel as needed.
- If located at the 500, 505 Building or a remote work location: no harmful environmental conditions are present.
- If located at the 500, 505 Building or a remote work location: noise level is usually moderate.
- If located at PACE: typically indoors in a clinical setting serving the frail and elderly; harmful or hazardous environmental conditions may be present; noise level usually ranges from moderate to loud.
- If located in the Community: typically indoors and sedentary with schedule changes and/or variable work hours; travel as needed; employees may occasionally work outdoors in varied temperatures; harmful or hazardous conditions may be present; noise level usually ranges from moderate to loud.
Application Process and Timing
- Applications accepted on a continuous basis until a sufficient number of qualified applications are received.
- First review deadline: October 21, 2026 at 9:00 PM (PST).
- Applications after the first review date are not guaranteed consideration.
- The recruitment may close without notice after the first review date.
Selection Process
- Application and resume reviewed by a dedicated recruiter.
- If experience matches needs, recruiter will reach out to discuss next steps.
- Selection process may include a skills assessment, phone screen, and interview.
- Selected candidates will undergo reference and background checks (including a conviction record); drug screening and/or 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 each step via the candidate portal and should monitor email, including spam folders.
