Hybrid: Required to be onsite in Stoughton, MA on Tuesday, Wednesday and Thursday.
POSITION OVERVIEWThe 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
