Reporting and Analytics Lead

Job Family:

Travel Required:

Clearance Required:

Guidehouses Health IT Solutions team works with clients to measurably improve their technology outcomes through a mix of IT strategies improvement in IT operations and adoption of technology initiatives. By leveraging a deep understanding of health system IT operational best practices supported by data Guidehouse propels IT operational improvement and technology adoption across departments and service lines at client organizations.

What You Will Do:

The Reporting and Analytics Lead will be a strategic leader responsible for the design development and delivery of all operational clinical and financial analytics solutions leveraging new Oracle Health (Cerner) EHR system on Oracle Cloud Infrastructure (OCI). This role will be pivotal in translating complex business clinical and regulatory requirements into sustainable high-performance reporting assets primarily utilizing Oracle Health Data Intelligence (OHDI) and OCIs analytical suite.

The Lead will bridge the gap between clinical/revenue stakeholders and the technical data team ensuring data integrity promoting self-service analytics and maintaining strict adherence to HIPAA and HITECH compliance.

Key Responsibilities:

Strategy & Leadership

• Lead the development of the organizations enterprise-wide reporting strategy for the newly implemented Oracle Health (Cerner) solution (Clinical Pharmacy Surgery Ambulatory Laboratory Revenue Cycle).
• Serve as the Subject Matter Expert (SME) for Oracle Healths data structure and reporting tools specifically Oracle Health Data Intelligence (OHDI/HealtheIntent) and Discern Reporting Portal (DRP).
• Collaborate with clinical financial and executive leadership to prioritize reporting initiatives and define key performance indicators (KPIs) for quality cost and operational efficiency.
• Mentor and provide technical guidance to a team of junior data analysts and report writers.

Development & Delivery

• Design develop and implement complex reporting solutions dashboards and visualizations using tools such as Oracle Analytics Cloud (OAC) and native Oracle Health tools.
• Utilize Cerner Command Language (CCL) to develop and optimize complex reporting extracts and custom data points from the Cerner Millennium database.
• Oversee the Extract Transform Load (ETL) processes from the Oracle Health application database into the OCI Data Lakehouse or OHDI platform ensuring data quality and integrity.
• Develop reports that support regulatory requirements including quality measures (e.g. eCQMs) public health reporting and financial compliance (X12/billing data).

Technical & Compliance

• Ensure all data models and reporting solutions comply with HIPAA HITECH and organizational data governance policies specifically for Protected Health Information (PHI).
• Work closely with OCI architects and security teams to implement and monitor access controls (Role-Based Access Control) for analytics data within the OCI environment.
• Maintain documentation for reporting processes data dictionaries technical specifications and user guides.
• Stay current with Oracle Health product updates new data standards (FHIR HL7 v2) and OCI data platform features to drive continuous improvement.

What You Will Need:

• Bachelors degree
• 5 years of experience in healthcare data analytics reporting or data warehousing.
• 3 years of specific experience developing reports and extracting data from a Cerner Millennium EHR environment.
• Proven experience in a lead or supervisory role managing analytics or reporting team.
• Deep knowledge of CMS reporting programs (IQR/OQR Promoting Interoperability MIPS) public health reporting and state/federal registry requirements.
• Strong understanding of clinical operations and documentation workflows and how they translate into reporting logic and data quality.
• Expert proficiency in SQL and strong experience with Cerner Command Language (CCL).
• Demonstrated experience with the Oracle Health reporting ecosystem (e.g. Discern Reporting Portal Oracle Health Data Intelligence/HealtheIntent).
• Solid experience with cloud-based analytics platforms; OCI experience is highly preferred including exposure to OCI Data Lake OAC or similar cloud services (Azure/AWS).
• Experience with a modern visualization tool (e.g. Tableau Power BI Oracle Analytics Cloud).
• Deep understanding of clinical laboratory pharmacy and revenue cycle workflows in a hospital setting.
• Expert knowledge of healthcare data standards (HL7 v2 FHIR) and regulatory compliance (HIPAA HITECH).

What Would Be Nice To Have:

• Bachelors degree in Health Informatics Computer Science Data Science or a related field.

What We Offer:

Guidehouse offers a comprehensive total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.

Benefits include:

• Medical Rx Dental & Vision Insurance

• Personal and Family Sick Time & Company Paid Holidays

• Position may be eligible for a discretionary variable incentive bonus

• Parental Leave and Adoption Assistance

• 401(k) Retirement Plan

• Basic Life & Supplemental Life

• Health Savings Account Dental/Vision & Dependent Care Flexible Spending Accounts

• Short-Term & Long-Term Disability

• Student Loan PayDown

• Tuition Reimbursement Personal Development & Learning Opportunities

• Skills Development & Certifications

• Employee Referral Program

• Corporate Sponsored Events & Community Outreach

• Emergency Back-Up Childcare Program

• Mobility Stipend

About Guidehouse

Guidehouse is an Equal Opportunity EmployerProtected Veterans Individuals with Disabilities or any other basis protected by law ordinance or regulation.

Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco.

If you have visited our website for information about employment opportunities or to apply for a position and you require an accommodation please contact Guidehouse Recruiting at 1- or via email at . All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation.

All communication regarding recruitment for a Guidehouse position will be sent from Guidehouse email domains including @ or . Correspondence received by an applicant from any other domain should be considered unauthorized and will not be honored by Guidehouse. Note that Guidehouse will never charge a fee or require a money transfer at any stage of the recruitment process and does not collect fees from educational institutions for participation in a recruitment event. Never provide your banking information to a third party purporting to need that information to proceed in the hiring process.

If any person or organization demands money related to a job opportunity with Guidehouse please report the matter to Guidehouses Ethics Hotline. If you want to check the validity of correspondence you have received please contact . Guidehouse is not responsible for losses incurred (monetary or otherwise) from an applicants dealings with unauthorized third parties.

Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee.