Guidehouse

Reporting and Analytics Lead

Guidehouse

full-time

Posted on:

Location Type: Remote

Location: Remote • 🇺🇸 United States

Visit company website
✨ AI Apply
Apply

Salary

💰 $130,000 - $216,000 per year

Job Level

Senior

Tech Stack

AWSAzureCloudETLOracleSQLTableau

About the role

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

Requirements

  • 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).
Benefits
  • 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

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
SQLCerner Command Language (CCL)Oracle Health Data Intelligence (OHDI)Discern Reporting Portal (DRP)Extract, Transform, Load (ETL)Oracle Analytics Cloud (OAC)data modelingreport developmentdata extractiondata visualization
Soft skills
leadershipmentoringcollaborationcommunicationtechnical guidanceprioritizationproblem-solvingorganizational skillsteam managementadaptability
Certifications
Bachelor’s degree