Reporting and Analytics Lead

Job Family:

Technology Consulting

Travel Required:

Up to 75%+

Clearance Required:

None

Guidehouse’s 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 OCI's 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 organization's 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 Health's 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:

• Bachelor’s 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:

• Bachelor’s degree in Health Informatics, Computer Science, Data Science, or a related field.

The annual salary range for this position is $130,000.00-$216,000.00. Compensation decisions depend on a wide range of factors, including but not limited to skill sets, experience and training, security clearances, licensure and certifications, and other business and organizational needs.

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 Employer–Protected 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-571-633-1711 or via email at RecruitingAccommodation@guidehouse.com. 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 @guidehouse.com or guidehouse@myworkday.com.  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 Guidehouse’s Ethics Hotline. If you want to check the validity of correspondence you have received, please contact recruiting@guidehouse.com. Guidehouse is not responsible for losses incurred (monetary or otherwise) from an applicant’s 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.