Clinical Data & Reporting Analyst (Data Warehouse Reporting Analyst Sr)

CalOptima

Orange (CA)

Hybrid

USD 110,000 - 160,000

Full time

2 days ago

Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

CalOptima in Orange, CA is seeking a Clinical Data & Reporting Analyst (Sr) to design, develop and maintain clinical reporting data assets. The role covers data acquisition, mapping, pipelines, and reporting using SQL, Power BI and Snowflake with partial telework within California.

You will partner with IT, clinical stakeholders and providers to deliver dashboards, regulatory reports and AI-enabled analytics, while ensuring data quality and conformed models across gold/silver layers.

Qualifications

Bachelor's degree in a related field with 5+ years of data/analytics engineering or clinical reporting experience.
3+ years of experience with healthcare payer data and SQL-based transformations.
3+ years designing data models, pipelines and reporting-ready datasets; experience with Snowflake or cloud platforms.

Responsibilities

Design, develop and maintain clinical reporting data assets to support business needs.
Develop dashboards, self-service and AI-enabled analytics using SQL and BI tools.
Collaborate with stakeholders to ensure data quality, governance and compliant delivery.

Skills

SQL

Snowflake

Power BI

ETL

Data Modeling

Data Warehousing

Databricks

Python

Microsoft Fabric

Education

Bachelor's degree in computer science / data engineering / healthcare informatics

Tools

Snowflake

Databricks

Power BI

SSRS

Microsoft Fabric

SQL Server

Job description

Clinical Data & Reporting Analyst (Data Warehouse Reporting Analyst Sr)

CalOptima

Join Us in this Amazing Opportunity

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.

The Team You'll Join

More About the Opportunity

We are hoping you will join us as a Clinical Data & Reporting Analyst (Data Warehouse Reporting Analyst Sr) and help shape the future of healthcare where you'll be an integral part of our IT - Clinical Technology 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.

The Data Warehouse Reporting Analyst Sr (Clinical Data & Reporting Analyst) will be responsible for designing, developing and maintaining the clinical reporting data assets to support departmental business needs. You will support the continual improvement of data acquisition and reporting methods, which includes periodically reviewing the clinical data assets to enhance the processes and functionalities. You will assist with the development of clinical operational, regulatory reports, dashboards, self-service and AI-enabled analytics, as well as create and maintain data assets, pipelines, and source-to-target data mapping specifications aligned to conformed data models. Additionally, the incumbent will participate in the design and development of the reporting infrastructure using Structured Query Language (SQL) server technologies and BI reporting tools.

Together, we are building a stronger, more equitable health system.

Your Contributions To the Team:

90% - Reporting & Analytics Development and Data Engineering Support
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.
Supports the creation of source-to-target mappings and validation logic to silver-layer conformed clinical models.
Helps build and maintain gold-layer clinical reporting marts sourced from the enterprise conformed silver models.
Participates in the development of business and functional requirements for reports.
Assists with the design, development, testing and implementation of reports/dashboards and extraction, transformation and loading (ETL) to fulfill business requirements.
Assists users with reporting and analysis activities and tools.
Serves as back-up to the supervisor in their absence.
Participates in progressively more complex projects and performs progressively more complex analyses.
Partners with the Enterprise Data Warehouse and platform teams to follow guidance and assist in building clinical data and reporting solutions on Snowflake and other modern data platforms (e.g., Databricks, Microsoft Fabric) helping ensure basic data quality and compliance steps are included in the process.
Works with data from systems like MySQL databases, vendor files, APIs, and other clinical platforms to help organize information into conformed reporting formats.
Supports data quality checks, validation steps, and issue tracking to ensure clinical reporting data is accurate and reliable.
Helps create and document clear definitions for clinical metrics and reporting rules used in tools such as Power BI and Snowflake, contributing updates to the enterprise business glossary.
Provides guidance/development and training to other team members in the Clinical department to improve the process in evaluating data and meeting customer specifications and business needs.
Acts as the point of contact for data requests, assigns requests to other Data Analysts and monitors timelines and outcomes.
Maintains clinical data assets to support business requirements and periodically reviews the databases to enhance the process and functionalities.
Supports user training, testing, documentation (technical design and business supporting) and the roll‑out of reports and end‑user reporting tools.
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.
10% - Other
Completes other projects and 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 5 years of professional experience in data and analytics engineering, data architecture, business intelligence engineering, or clinical reporting required; 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.
3 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.
3 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.
3 years of hands‑on experience with Snowflake or comparable cloud data platforms, including data modeling, pipeline development, transformation logic, performance optimization, and governed data delivery.
3 years of hands‑on experience designing or preparing analytics data products for AI‑enabled consumption, including natural‑language analytics, Snowflake Cortex, Microsoft Copilot/Fabric, semantic views, governed metric catalogs, and business‑friendly metadata.
3 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.
Utilise 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.

Your Physical Requirements (With or Without Accommodations):