Sr Clinical Data Engineer (ITS Architect III)

Sr Clinical Data Engineer (ITS Architect III) CalOptima Join Us in this Amazing Opportunity 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. More About the Opportunity 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. Your Contributions To the Team: 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. 10% - Reporting Stakeholder Collaboration & Program Support 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 CalOptima Health. Maintains knowledge of business processes and application design and understands cross-functional business relationships and their use of information. 5% - Other Completes other duties as assigned. Do You Have What the Role Requires? 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 qualifying. 5 years of experience working with healthcare payer data. 5 years of experience 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 of hands-on experience with designing and building data models, pipelines, SQL transformations, data quality controls, and reporting-ready datasets; experience supporting enterprise reporting, operational dashboards, regulatory reporting, or clinical analytics required. 7 years of experience with utilization management, prior authorization, inpatient/outpatient authorization, care management, appeals, delegated network reporting, or regulated healthcare payer data and reporting required. You’ll Stand Out More If You Possess the Following: Experience with Snowflake, modern ELT/ETL architecture, and data 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, healthcare interoperability standards (FHIR, HL7, X12), CMS interoperability requirements, data governance, metadata, lineage, and audit-ready reporting. What the Regulatory Agencies Need You to Possess? n/a Your Knowledge & Abilities to Bring to this Role: Develop rapport and establish and maintain effective working relationships with CalOptima Health's leadership and staff and external contacts at all levels and with diverse backgrounds. Work independently and exercise sound judgment. Communicate clearly and concisely, both orally and in writing. Work a flexible schedule; available to participate in evening and weekend events. Organize, be analytical, problem-solve and possess project management skills. Work in a fast‑paced environment and in an efficient manner. Manage multiple projects and identify opportunities for internal and external collaboration. Motivate and lead multi-program teams and external committees/coalitions. Utilize computer and appropriate software (e.g., Microsoft Office: Word, Outlook, Excel, PowerPoint) and job specific applications/systems to produce correspondence, charts, spreadsheets, and/or other information applicable to the position assignment. Ways We Are Here For You You’ll enjoy competitive compensation for this role. Our current hiring range is: Pay Grade: 316 - $120,881 - $193,410 ($58.12 - $92.9856). The final salary offered will be based on education, job-related knowledge and experience, skills relevant to the role and internal equity among other factors. This position is approved for Partial Telework (**If the position is Telework, it is eligible in California only**) A CalPERS pension program and additional retirement packages. Additional benefits and perks including: A generous PTO program A quality work life balance Various wellness programs Tuition Reimbursement Professional development opportunities Career development opportunities Flexible scheduling And the satisfaction of knowing your work directly impacts and improves healthcare access for thousands of individuals and families. Our Work Environment: If located at the 500, 505 Building or a remote work location: Work is typically indoors and sedentary and is subject to schedule changes and/or variable work hours, with travel as needed. There are no harmful environmental conditions present for this job. The noise level in this work environment is usually moderate. If located at PACE: Work is typically indoors in a clinical setting serving the frail and elderly. There may be harmful or hazardous environmental conditions present for this job. The noise level in this work environment is usually moderate to loud. If located in the Community: Work is typically indoors and sedentary and is subject to schedule changes and/or variable work hours, with travel as needed. Employee will occasionally work outdoors in varied temperatures. There may be harmful or hazardous environmental conditions present for this job. The noise level in this work environment is usually moderate to loud. Why Join Us? We believe that diverse perspectives drive innovation. Each employee brings a unique perspective to the overall team and we value everyone's input and we are committed to creating an inclusive environment where you and every team member can thrive while making a meaningful impacts on our community members. Our team reflects and represents the communities we serve, and we welcome candidates from all backgrounds who share our commitment to accessible, quality healthcare. Our Commitment to You Your application and resume will be reviewed by a dedicated recruiter to this position. If your experience matches what we need, we will reach out to you to discuss the next steps. The selection process may include, but is not limited to, a skills assessment, phone screen and interview. If you make it through the steps above and are selected for this exciting role, you will be required to undergo a reference and a background check (to include a conviction record) and if applicable also pass a drug screening and/or a post-offer pre-employment medical examination (for specific positions). We will make sure to keep you updated through each step of the process on your candidate portal. Please make sure to watch for updates on your candidate portal and you emails which will be sent to the email address you listed on your application. Please check your email, including your SPAM folder, regularly throughout the recruitment process. CalOptima Health is an equal opportunity employer and makes all employment decisions on the basis of merit. CalOptima Health wants to have qualified employees in every job position. CalOptima Health prohibits unlawful discrimination against any employee, or applicant for employment, based on race, religion/religious creed, color, national origin, ancestry, mental or physical disability, medical condition, genetic information, marital status, sex, sex stereotype, gender, gender identity, gender expression, transitioning status, age, sexual orientation, immigration status, military status as a disabled veteran, or veteran of the Vietnam era, or any other consideration made unlawful by federal, state, or local laws. CalOptima Health also prohibits unlawful discrimination based on the perception that anyone has any of those characteristics or is associated with a person who has, or is perceived as having, any of those characteristics. If you are a qualified individual with a disability or a disabled veteran, you may request a reasonable accommodation at View phone number on click.appcast.io if you are unable or limited in your ability to access job openings or apply for a job on this site as a result of your disability. je-c59d8e2c334248728712af514c9a2fdf #J-18808-Ljbffr CalOptima