Sr Clinical Data Engineer; Architect III

Sr Clinical Data Engineer (ITS Architect III)

Cal Optima

The Team You'll Join

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 Sr Clinical Data Engineer (ITS Architect III) and help shape the future of healthcare where you'll be an integral part of our Applications Management 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 Partial 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.

• 85% - Data Engineering, Reporting & Analytics Development
• 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.
• Contributes source-system expertise, source-to-target mappings, and validation logic to silver-layer conformed clinical models; designs, builds and maintains gold-layer clinical reporting marts sourced from the enterprise conformed silver models.
• Partners with the Enterprise Data Warehouse and platform teams to co-develop clinical analytics solutions on Snowflake/modern data platforms (e.g., Databricks, Microsoft Fabric), embedding data quality, lineage, audit, and compliance requirements into engineering workflows, in accordance with enterprise Data Governance policies and standards.
• Analyzes source-system data from MySQL databases, flattened tables, vendor extracts, APIs, and other clinical platforms; translates source structures into scalable models and reporting-ready data products.
• Defines and implements data quality, reconciliation, validation, lineage, exception management, and production-support processes for clinical reporting assets.
• Develops and documents 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.
• Participates in the development of business and functional requirements for reports.
• Designs, develops, tests and implements reports/dashboards and extraction, transformation and loading (ETL) to fulfill business requirements.
• Assists users with reporting and analysis activities and tools.
• Creates and maintains technical and business-facing documentation, including data dictionaries, source-to-target mappings, entity and metric definitions, transformation logic, and lineage.

• Maintains effective working relationships and collaborates with clinical stakeholders, business operations, analysts, data warehouse, BI developers and other Information Technology (IT) teams to validate outputs, resolve reporting discrepancies, and ensure reports & dashboards align with operational and regulatory needs.
• Supports user training, testing, documentation and the roll-out of reports and end-user reporting tools.
• Maintains effective working relationships with the Data Warehouse and IT teams and other business departments within Cal Optima Health.
• Maintains knowledge of business processes and application design and understands cross-functional business relationships and their use of information.

• Completes other duties as assigned.

• 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 sufficient to successfully perform the essential duties of the position such as those listed above may also be…