Manager, Patient Access Planning & Reporting

Job Description SummaryAs the Manager of Patient Access Planning & Reporting, you will oversee Patient Access Data Analytics and Reporting Operations. Reporting to the Associate Director of Patient Access Strategy & Planning, you will collaborate with leadership to ideate, scope, structure, and deliver analytics that solve business problems using tools like Snowflake, SQL, Python, R and BI tools such as Tableau, Tableau Bridge and Prep, PowerBI, Excel and Powerpoint. You must have experience in reporting and dashboard design, automation and ETL including, identifying business opportunities and use-cases and sourcing, ingesting, cleaning, processing and quality-checking data and deliverables. You will apply advanced analytical skills, data-science, machine learning, project management and business acumen to assess project benefits and identify opportunities and deliver high-quality analytics to various stakeholders including internal Patience Access teams, Sales, Marketing, IT and others. You will work cross-functionally with internal teams as well as external partners to complete your projects. You will use all available tools and resources to evaluate business and operational performance as well as customer behavior and market insights and provide comprehensive recommendations to move the business forward.Job DescriptionAs the Manager of Patient Access Planning & Reporting, you will oversee Patient Access Data Analytics and Reporting Operations. Reporting to the Associate Director of Patient Access Strategy & Planning, you will collaborate with leadership to ideate, scope, structure, and deliver analytics that solve business problems using tools like Snowflake, SQL, Python, R and BI tools such as Tableau, Tableau Bridge and Prep, PowerBI, Excel and Powerpoint. You must have experience in reporting and dashboard design, automation and ETL including, identifying business opportunities and use-cases and sourcing, ingesting, cleaning, processing and quality-checking data and deliverables. You will apply advanced analytical skills, data-science, machine learning, project management and business acumen to assess project benefits and identify opportunities and deliver high-quality analytics to various stakeholders including internal Patience Access teams, Sales, Marketing, IT and others. You will work cross-functionally with internal teams as well as external partners to complete your projects. You will use all available tools and resources to evaluate business and operational performance as well as customer behavior and market insights and provide comprehensive recommendations to move the business forward.Managing Analytics & Reporting DevelopmentUnder instruction by AD, deliver, manage, improve and automate daily, weekly, monthly, quarterly and annual reports and dashboards to various business leaders and teams and as well as gather requirements for new reports and dashboard and complete ad-hoc analytics requestsProvide support and vendor management of a ConnectiveRx Tableau reporting platform used for Endo's Sales Reps and Field Reimbursement Managers (FRMs) Support and act as reporting and analytics lead between the Patience Access team and its stakeholders across the Sales, Sales Ops, IT, FRMs and other vendors and partners such as ConnectiveRx, CVS, Besse, Everest, Cognizant, Begohou and othersProvide new employees with access to and training to use the Tableau, CVS portals and CRx portalsCreate new and maintain existing recurring reports and develop new queries and data visualizations to help identify business issues and solutionsLead User Acceptance Testing (UAT) for updated or new reporting structuresDevelop end-user training materials and communications relative to Patient Access reportingSupport and facilitate training and roll-out of new reporting structuresReporting Ecosystem Management and SupportManage and provide process focused analytics support to Patient Access including debugging, monitoring and troubleshooting BI solutionsSupport the management of the FRM Escalation Portal and Patient Access Mailbox and assist in responding to inquiries from the field force and management Perform data investigations, model and dig into data from various sources such as the commercial data warehouse, specialty pharmacies, specialty distributors, and benefits investigation partnersProvide ongoing analytical and technical support of existing data sources, data integration, operational reports and dashboards submitted through various channelsDesign and conduct Ad-hoc analyses when required and under tight deadlinesAssist leadership with presentations and reports to various stakeholdersPerform other duties and/or special projects as assignedQualifications Education & ExperienceMaster's degree in a quantitative discipline, such as statistics, mathematics, science, IT, or engineeringIn lieu of a Master's degree, 5+ years of analytics experience preferable within the Pharmaceutical industryAbility to work independently, problem-solve and act resourcefully to complete projects and tasks with minimal support when necessaryMinimum of 5 years' experience in gathering complex reporting requirements, designing and implementing insightful visualization solutions using business intelligence tools such as Tableau and PowerBIMust have a minimum of 5 years or more experience and proficiency with common, popular database technologies and programs including Snowflake, SQL Server, Python and RMust be an expert level user in Tableau, Microsoft Excel and Powerpoint Prior experience in patient services in a complex reimbursement environment is a plusPrevious experience managing and working with vendor teams is desirableKnowledgeExtensive knowledge of data architecture and ETL principles and best practices Knowledge of the reporting and analytics full life-cycle from requirements gathering, design, build, test and deploy Knowledge and understanding of the pharmaceutical development process and health care environment is desirableSkills & AbilitiesExperience with data science, machine learning, artificial intelligence and statistics is requiredMust enjoy working with data and providing guidance and insights to business usersMust have the ability to manage internal and external team membersWork well with cross functional teamsTeam player with critical thinking abilitiesCurious about data, self-motivated, attention to detailStrong communication, analytical, systems/process orientationStrong project management, communications, multi-tasking, ability to work independently and relationship management skills are keys to succeed in this roleAbility to present findings to all levels of managementMust be able to think strategically and have the ability to identify business opportunities and lead/guide othersMust be able to manage multiple complex initiatives and collaborate with othersAbility to synthesize/analyze diverse information, develop and recommend strategiesSelf-assessment skill-level requirements out of 10 for each tool: Snowflake-7/10SQL-8/10Tableau-8/10Data ETL-8/10Python-6/10R-6/10

Created: 2025-03-03