Reporting and Analytics Manager

The Reporting and Analytics Manager leads the analytics function supporting the HPN UM & CM delegation oversight operation and is accountable for the health plan reporting process, including group-level validation, timely collection of submissions, and preparation of universes for DMHC and NCQA audits. The position directs the development of Tableau dashboards, SQL queries and automated reporting that extract and analyze health care information across utilization, turn-around time compliance, medical group performance measurement and compliance monitoring. Effective presentation of data in user-friendly visuals and written summaries is an important part of this position.

Working collaboratively with Medical Group data analytic teams, develops and maintains accurate data mapping to the HPN data warehouse to assure consistent, valid and comparable data across multiple medical groups with disparate source systems. Leads data management and ETL activity and is accountable for governance of the analytics estate — assuring that code, packages and workbooks are held in a single authoritative location, follow naming and documentation standards, and are reproducible by another analyst without the author present. The position also owns departmental applications serving UM leadership, gathering requirements from UM stakeholders, translating them into functional specifications, and assuring each application continues to meet the business need through release, user support and documentation.

Essential Duties and Responsibilities include the following:

• Oversee the health plan reporting process, ensuring group-level validation and timely collection of submissions.
• Create and leverage analytics to support HPN groups’ performance and operations
• Maintain and enhance a centralized report repository in HPN’s knowledge base, training analysts to execute reporting scripts as needed.
• Identify and implement process improvements for health plan reporting and provide strategic support to groups where applicable.
• Direct the preparation and delivery of ad-hoc and routine reports to fulfill internal and external reporting requirements.
• Supervise universe preparation for DMHC and NCQA audits, ensuring comprehensive data validation and collection.
• Ensure accurate and timely data reporting aligns with department and organizational objectives.
• Lead data management initiatives, including Extract, Transform, and Load (ETL) processes, to meet reporting and compliance needs.
• Leverage existing data sources for reporting purposes and escalate to the director when specific data gaps hinder reporting capabilities.
• Collaborate with cross-functional teams to optimize reporting workflows, validation processes, and data integration efforts.
• Foster a culture of continuous learning and data-driven decision-making within the team, ensuring alignment with evolving business needs.
• Own departmental applications serving UM leadership, directing requirements gathering with UM stakeholders and translating business needs into functional specifications.
• Manage the application lifecycle, including prioritization of enhancements, release coordination, user acceptance testing, end-user training and maintenance of supporting documentation.
• Serve as the liaison between UM business owners and technical resources, whether internal analysts or external vendors, assuring delivered functionality meets the stated business need.