BI & Reporting Manager — Insights & Automation

RiseMe; Toronto; Hybrid; CAD 96,000 - 134,000; Full time

Job summary

Apotex Inc. in Canada is seeking a Manager, Business Intelligence & Reporting to design and deliver the Commercial reporting architecture, data strategy, governance, visualization and reporting.

This role collaborates with IT to align data architecture, standardize data from multiple sources, and modernize data management using Databricks, Qlik, and Power BI. The Manager will lead BI initiatives for the Canadian Commercial organization, support IBP, budgeting and performance, and mentor team

Qualifications

• University degree: Business, Engineering, Science, Mathematics, Computer Sciences preferred
• Proficiency in SQL, Python, VBA, and other development tools as well as Qlik or Tableau. Knowledge of machine learning an asset.
• Proficiency with ETL processes and automation in a SQL environment
• Proficiency with SQL Integration Services (SSIS)
• High level of proficiency in all MS Office applications, including Excel and Access
• Previous experience in SAP or an ERP system
• Knowledge of statistical procedures and applied data validation
• Excellent written and verbal communication skills
• Ability to work with all levels within the organization

Responsibilities

• Execute or oversee ad hoc reporting and analysis for cross-functional teams
• Lead development of Qlik applications for Apotex Canada Commercial teams
• Develop and maintain Data Sourcing standards across tools and reports
• Lead cross-functional project teams to gather requirements and maximize efficiency
• Liaise with GIS on cross-functional projects and align teams to goals
• Troubleshoot issues with active Qlik apps owned by Commercial Excellence
• Develop and maintain Data Source matrix with best practices
• Ensure tools and reports adhere to Data Sourcing standards
• Ensure quality of reporting from GBS Commercial team
• Build and maintain SLAs for deliverables of GBS Commercial team
• Provide guidance on BI initiatives within Commercial Excellence
• Provide actionable insights and time-saving reporting efficiencies each year
• Oversee and execute Commercial IBP reporting and processes
• Work with Analyst on troubleshooting and development for IBP reporting processes
• Ensure IBP deliverables are supplied accurately and on time
• Oversee and execute Commercial budgeting and compensation reporting
• Build and manage a central database for Apotex Canada budgeting
• Build and manage a Sales Rep Compensation database with monthly reports
• Troubleshoot compensation reporting with Consultant, Reporting & CRM
• Ensure compensation deliverables on time
• Develop automation to drive efficiency for all teams
• Roll out tools and processes via Organizational Change Management
• Deliver training plans for tools and processes
• Ensure deliverables are simple and repeatable with minimal intervention
• Support existing tools and processes within Commercial Excellence
• Foster open two-way communication and trust-based relationships
• Promote a culture valuing trust and employee development
• All other duties as assigned

Skills

SQL

Python

VBA

Qlik

Tableau

Machine learning

Education

University degree in Business, Engineering, Science, Mathematics, Computer Sciences

Tools

SSIS

Excel

Job description

Apotex Inc. in Canada is seeking a Manager, Business Intelligence & Reporting to design and deliver the Commercial reporting architecture, data strategy, governance, visualization and reporting.

This role collaborates with IT to align data architecture, standardize data from multiple sources, and modernize data management using Databricks, Qlik, and Power BI. The Manager will lead BI initiatives for the Canadian Commercial organization, support IBP, budgeting and performance, and mentor team