Commercial Analytics Leader - AI-Powered Dashboards

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

Job summary

Collegium Pharmaceutical is seeking a Senior Manager, Commercial Reporting Strategy in Stoughton, MA to lead BI-driven decision support across Sales, Marketing, Market Access, Trade, and Finance. The role emphasizes Power BI, AI, and advanced analytics to deliver scalable dashboards and insights.

The position partners with IT, data teams, and external vendors to ensure data quality, governance, and impactful analytics. Hybrid onsite schedule and leadership responsibilities are highlighted.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems or related field.
• 6–8 years of related experience; minimum 3 years using SQL, building Power BI dashboards, and querying large data sets (Oracle, SQL Server and/or Amazon Redshift).
• Knowledge of syndicated national and payer/HCP level Commercial Pharmaceutical data (Symphony, IQVIA, claims and wholesaler data).
• Experience developing, managing, or supporting Power BI dashboards and reporting solutions in a business environment.

Responsibilities

• Lead strategy, development, and continuous improvement of Power BI dashboards and commercial reporting solutions.
• Partner with stakeholders to define reporting needs and translate business questions into insights.
• Identify and implement AI and advanced analytics use cases, including trend analysis and reporting automation.
• Embed AI-generated insights into Power BI dashboards and business reviews.
• Collaborate with data, IT, analytics, and vendor partners for data integration and solution quality.
• Manage external Power BI and analytics vendors and monitor performance.
• Maintain governance standards for KPI definitions, data quality, access, documentation, privacy, and responsible AI use.
• Monitor dashboard usage, AI solution performance, and business value to guide enhancements.
• Provide training to increase adoption of Power BI, self-service reporting, and AI-enabled analytics.

Skills

Power BI

SQL

Data analysis

AI/advanced analytics

Stakeholder management

Education

Bachelor’s degree in Computer Science, Information Systems or related field

Master’s degree in related field

Tools

Oracle

SQL Server

Amazon Redshift

Job description

Collegium Pharmaceutical is seeking a Senior Manager, Commercial Reporting Strategy in Stoughton, MA to lead BI-driven decision support across Sales, Marketing, Market Access, Trade, and Finance. The role emphasizes Power BI, AI, and advanced analytics to deliver scalable dashboards and insights.

The position partners with IT, data teams, and external vendors to ensure data quality, governance, and impactful analytics. Hybrid onsite schedule and leadership responsibilities are highlighted.