Senior Manager, Commercial Reporting Strategy

Collegium Pharmaceutical; Boston (MA); Hybrid; USD 170,000 - 200,000; Full time

Job summary

Collegium Pharmaceutical is building a leading biopharmaceutical company focused on pain management and neuropsychiatry. This Senior Manager will lead commercial reporting strategy, with emphasis on Power BI, AI, and analytics across Sales, Marketing, Market Access, Trade, Finance, and senior leadership.

The role partners with business, data, IT, and vendor teams to deliver accurate dashboards, ensure data quality, and govern AI-enabled solutions while driving adoption and governance across the

Qualifications

• 6-8 years of related experience.
• 3+ years building Power BI dashboards and querying large data sets (Oracle, SQL Server, Redshift).
• Knowledge of syndicated national and payer data (Symphony, IQVIA) required.
• Strong analytical skills to interpret data and translate into insights.
• Experience partnering with Sales, Marketing, Market Access, Trade, Finance, IT, or senior leadership.

Responsibilities

• Lead the strategy, development, and continuous improvement of Power BI dashboards and commercial reporting solutions.
• Partner with stakeholders to define reporting needs, prioritize requests, and translate business questions into insights.
• Identify and implement AI and advanced analytics use cases, including trend analysis and anomaly detection.
• Embed AI-generated insights into Power BI dashboards and executive reviews to support proactive decisions.
• Collaborate with data, IT, analytics, and vendor partners to ensure reliable data integration and timely delivery.
• Manage external Power BI and analytics vendors, including priorities and performance.
• Maintain reporting and AI governance standards for KPI definitions, data quality, access, and privacy.
• Monitor dashboard usage and AI performance to guide enhancements.
• Provide training and support to increase adoption of Power BI and AI-enabled analytics.

Skills

Analytical thinking

Stakeholder collaboration

Communication

Leadership

Education

Bachelor's degree in Computer Science / Information Systems

Master's degree desirable

Tools

Power BI

SQL

Oracle

SQL Server

Amazon Redshift

Job description

Collegium Pharmaceutical is building a leading, diversified biopharmaceutical company committed to improving the lives of people living with serious medical conditions. We have a leading portfolio of responsible pain management and neuropsychiatry medications.

Hybrid - Boston, MA: Collegium will relocate its headquarters to One Lincoln in downtown Boston in Q1 2027. Until the move, this role will be based at our current headquarters in Stoughton, MA. Employees are required to work onsite Tuesday, Wednesday, and Thursday each week, both before and after the relocation.

POSITION OVERVIEW

The Senior Manager, Commercial Reporting Strategy will lead commercial reporting and business intelligence capabilities, with a focus on Power BI, AI, and advanced analytics. This role will partner with business, data, IT, and vendor teams to deliver accurate, scalable dashboards and insights that support timely decisions across Sales, Marketing, Market Access, Trade, Finance, and senior leadership. The position will also oversee reporting priorities, data quality, user adoption, and responsible governance of AI-enabled solutions.

RESPONSIBILITIES

• Lead the strategy, development, and continuous improvement of Power BI dashboards and commercial reporting solutions
• Partner with stakeholders to define reporting needs, prioritize requests, and translate business questions into clear, actionable insights
• Identify and implement practical AI and advanced analytics use cases, including trend analysis, anomaly detection, natural-language insights, and reporting automation
• Embed AI-generated insights and leading indicators into Power BI dashboards and recurring business reviews to support faster, more proactive decisions
• Collaborate with data, IT, analytics, and vendor partners to ensure reliable data integration, solution quality, and timely delivery
• Manage external Power BI and analytics vendors, including priorities, timelines, deliverables, issue resolution, and performance
• Maintain reporting and AI governance standards for KPI definitions, data quality, access, documentation, validation, privacy, and responsible use
• Monitor dashboard usage, AI solution performance, user feedback, and business value to guide enhancements and measure impact
• Provide training and support to increase adoption of Power BI, self-service reporting, and AI-enabled analytics

REQUIRED LEADERSHIP BEHAVIORS

At Collegium, how we achieve results is just as important as what we achieve. Our Leadership Behaviors define how we work, collaborate, and succeed as we continue to evolve as an organization.

We group these behaviors into three pillars:

• HEAD
  • Think Entrepreneurially
  • Take Decisive Action
  • Drive Results
• HEART
  • Communicate Effectively
  • Enable High Performance
  • Collaborate with Purpose
• GUTS
  • Take Smart Risks
  • Be Tenacious About Change
  • Compete to Win

Successful candidates will demonstrate these behaviors through their ability to challenge the status quo, build strong relationships, drive results, embrace change, and contribute to a high-performance culture.

QUALIFICATIONS

• Bachelor's degree Computer Science, Information Systems or related field required, Master's degree in related field highly desirable.
• 6-8 years of related experience required; Minimum of 3 years of experience using SQL building PowerBI dashboards, and querying large and/or complex data sets (Oracle, SQL Server and/or Amazon Redshift).
• Knowledge of both syndicated national and payer/ HCP level Commercial Pharmaceutical data (Symphony, IQVIA, claims and wholesaler data) required.
• Demonstrated expertise developing, managing, or supporting Power BI dashboards and reporting solutions in a business environment.
• Strong analytical skills with the ability to interpret complex data, identify trends, and translate findings into actionable business insights.
• Experience partnering with Sales, Marketing, Market Access, Trade, Finance, IT, Data Management, or senior leadership stakeholders.
• Strong project management skills with the ability to manage multiple priorities, balance stakeholder needs, and deliver high-quality work within deadlines.

Pay Range

$170,000-$200,000 USD

Collegium is an equal opportunity employer. It is the policy of Collegium, in all of its relations with its employees and applicants for employment, to base all employment-related decisions upon valid job-related factors, without regard to age, national origin, citizenship status, ancestry, race, color, religion, creed, sex or gender (including pregnancy, childbirth and related medical conditions), gender identity or expression (including transgender status), sexual orientation, military or veteran status, physical or mental disability, genetic information, or any other status protected by applicable federal, state, or local law. This policy applies to hiring, training, promotion, compensation, disciplinary measures, access to facilities and programs, and all other personnel actions and conditions of employment. By this policy, Collegium seeks to ensure that all employees have the opportunity to make their maximum contribution to Collegium and to their own career goals. This policy provides for an equal employment opportunity program that will simultaneously serve the requirements of society, the law, sound business practices and individual dignity.

If you have questions or concerns about equal employment opportunities in the workplace, you are encouraged to bring these issues to the attention of the Head of Human Resources. We will not allow any form of retaliation against employees who raise issues of equal employment opportunity. To ensure our workplace is free of artificial barriers, violation of this policy may result in disciplinary action, up to and including termination.