Clinical Data & Reporting Analyst; Data Warehouse Reporting Analyst Sr

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

Cal Optima

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 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 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.

• 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…