Guidehouse · 22 hours ago
Reporting and Analytics Lead
District of Columbia, United States
Full-time
Hybrid
Senior Level
$130K/yr - $216K/yr
5+ years expGuidehouse is a company focused on improving technology outcomes in the health IT sector. The Reporting and Analytics Lead will be responsible for designing, developing, and delivering analytics solutions, ensuring data integrity, and adhering to compliance standards while collaborating with various stakeholders.
AdviceConsultingManagement Consulting
Responsibilities
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
Qualification
Required
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)
Preferred
Bachelor's degree in Health Informatics, Computer Science, Data Science, or a related field
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
Company
Guidehouse
Guidehouse offers consulting services for public and commercial markets with expertise in management, technology, and risk consulting.
10001+ employees
H1B Sponsorship
Guidehouse has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (25)
2024 (20)
2023 (29)
2022 (49)
2021 (50)
2020 (59)
Funding
Current Stage
Late StageTotal Funding
$0.75MKey Investors
Mission Daybreak
2023-11-06Acquired
2023-02-16Grant· $0.75M
Leadership Team
Scott McIntyre
Chairman and CEO
Alicia Harkness
Partner
Recent News
Washington Technology
2025-11-20
Washington Technology
2025-11-19
Company data provided by crunchbase