Senior Manager, Commercial Reporting Strategy

Collegium-Pharmaceutical,-Inc; Stoughton (MA); On-site; USD 170,000 - 200,000; Full time

Job summary

Collegium Pharmaceutical in the Boston area is seeking a Senior Manager, Commercial Reporting Strategy to lead Power BI dashboards, AI analytics, and advanced analytics across Sales, Marketing, Market Access, Trade, Finance, and leadership. You will partner with business, data, IT, and vendor teams to deliver accurate, scalable dashboards and insights that support timely decisions across the organization.

The role requires 6–8 years of related experience, with at least 3 years building Power BI

Qualifications

• Bachelor’s degree in Computer Science, Information Systems or related field required
• 6–8 years of related experience; 3+ years building Power BI dashboards and querying large data sets
• Knowledge of syndicated national and payer/HCP data (Symphony, IQVIA, claims, wholesalers) is required
• Demonstrated expertise in Power BI dashboards and reporting solutions in a business environment
• Strong analytical skills to interpret data, identify trends, and translate findings into insights
• Experience partnering with Sales, Marketing, Market Access, Finance, IT, and leadership stakeholders
• Strong project management skills to balance priorities and meet deadlines

Responsibilities

• Lead strategy, development, and ongoing improvement of Power BI dashboards and commercial reporting solutions
• Partner with stakeholders to define reporting needs and translate questions into insights
• Identify and implement AI and advanced analytics use cases, including trend analysis and anomaly detection
• Embed AI insights into dashboards and reviews to enable proactive decisions
• Collaborate with data, IT, analytics, and vendors to ensure data integration and solution quality
• Manage external Power BI and analytics vendors and timelines
• Maintain governance standards for KPI definitions, data quality, privacy, and documentation
• Monitor dashboard usage and measure business value; drive enhancements and adoption

Skills

Power BI

SQL

Analytical skills

Vendor management

Leadership

Education

Bachelor’s degree Computer Science/Information Systems or related field

Master’s degree in related field desirable

Tools

Power BI

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