Manager, Bi & Reporting
$95.59k - $133.83k per yearApotex Inc.
About Apotex Inc.
Apotex is a Canadian-based global health company. We improve everyday access to affordable, innovative medicines and health products for millions of people worldwide, with a broad portfolio of generic, biosimilar, innovative branded pharmaceuticals and consumer health products. Headquartered in Toronto, with regional offices globally, including in the United States, Mexico and India, we are the largest Canadian-based pharmaceutical company and a health partner of choice for the Americas for pharmaceutical licensing and product acquisitions.
For more information visit:
Job Summary
The Manager, Business Intelligence & Reporting is responsible for designing and delivering Commercial reporting architecture, data strategy & governance, visualization and reporting. This person will work with IT to align database architecture with evolving business needs, applying sound database management principles and developing robust processes for extracting, transforming, and standardizing data from multiple sources. They must also develop and maintain processes for retrieving, standardizing, and loading data in an accurate and timely manner into relevant database tables. The role is responsible for modernizing data management and reporting processes, by leveraging best practices and emerging technologies, including Databricks. They will architect scalable data structures that enable integrated reporting across multiple lines of business through a single, consistent reporting framework. The Manager, Business Intelligence & Reporting will be organizing,overseeing, and executing Business Intelligence reporting needs of the Canadian Commercial organization, providing insights and time savings to a variety of Commercial stakeholders through high‑quality data visualization, reporting, and analytics. This role partners closely with cross‑functional stakeholders to understand business requirements and translate them into scalable BI solutions, primarily using Power BI and modern analytics tools. They are further responsible for ensuring that all reports, applications, and tools provided to the business are using correct and consistent data sources. In addition to enabling data‑driven decision‑making, this role supports commercial IBP, budgeting and performance calculation processes by maintaining data and providing reporting related to budget, targets, and performance. They will take ownership of supplying supporting data for these key processes, working with deliverable owners to ensure deliverables can be provided accurately and on time for each cycle. They will utilize best practices of Organizational Change Management to guide all rollout plans of new technology and processes. As a Manager, they should take on a leadership role within the team, training on processes, and sharing knowledge and best methods as widely as possible.
Job Responsibilities
Improve and modernize data preparation and load processes
Identify and implement opportunities for modernized data flows utilizing best in class approach to Databricks functionality
Understand Apotex Canada Commercial data requirements and complex datasets
Integrate data from various lines of business and sources into a unified reporting view
Liaise with IT teams to ensure database architecture aligns with ability to efficiently fulfil business needs
Manage Commercial databases, ensuring timely flow of clean and accurate data
Provide database architecture solutions and suggestions based on a deep understanding of data sources and business needs
Develop processes for extracting, receiving, and standardizing data to be used in reporting
Design database in a way that supports growing development of data-driven AI projects
Develop and maintain data visualization apps in support of Apotex Canada Commercial teams
Understand user requirements and implement BI projects
Responsible for executing or overseeing ad hoc reporting and analysis as required by cross-functional teams within Apotex Canada Commercial, or areas impacting Apotex Canada Commercial, and as prioritized within Commercial Excellence deliverables
Lead development of Power BI applications for Apotex Canada Commercial teams
Responsible for developing and maintaining Data Sourcing standards to be used across all tools, applications, and reports delivered by Commercial Excellence team
Lead cross-functional project teams to gather, understand, and execute requirements to maximize efficiency within the Commercial organization
Liaise with GIS on cross functional projects, develop priorities given limited resources and ensure alignment of all teams to achieve goals
Provide expertise on data preparation, sourcing, and management for AI initiatives
Liaise with users and GIS to troubleshoot issues with active BI dashboards owned by Commercial Excellence
Develop and maintain Data Source matrix, defining best practices for sourcing data used in Commercial Excellence reporting, applications, and tools
Ensures that all tools, applications, and reports provided by Commercial Excellence team adhere to defined Data Sourcing standards
Ensure data architecture is designed to support evolving requirements to support IBP
Work with Analyst, Commercial Excellence on any troubleshooting and development required for IBP reporting processes
Act as backup for running end-to-end IBP monthly process
Deliver reporting in a timely manner to support sales compensation processes
Build and manage a central database for Apotex Canada budgeting
Build and manage a Sales Rep Compensation database that will generate monthly reports and variance analysis
Stay up-to-date on modern technology and best practices related to reporting and database management
Support, as needed, any existing tools and processes owned by Commercial Excellence
Works in a safe manner collaborating as a team member to achieve all outcomes
Demonstrate Behaviours that exhibit our organizational Values: Integrity, Courage, Teamwork, and Innovation
Ensure personal adherence with all compliance programs including the Global Business Ethics and Compliance Program, Global Quality policies and procedures, Safety and Environment policies, and HR policies
All other relevant duties as assigned
Job RequirementsEducation
University degree: Business, Engineering, Science, Mathematics, Computer Sciences preferred
Knowledge, Skills And Abilities
Proficiency in SQL, Python, VBAand other ddvelopment tools
Profiency with data visualization software (Power BI preferred;
Qlik;
Tableau)
Previous experience with Databricks or similar cloud-based data platform
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 an asset
Knowledge of statistical procedures and applied data validation
Excellent written and verbal communication skills
Ability to work with all levels within the organization
Experience
Experience in the Canadian Pharmaceutical industry working with pharmaceutical data systems and conducting extensive focused analytics
Experience working with pharmaceutical leadership to understand the Canadian market environment and advance corporate goals
Experience in performance analytics
At Apotex, we are committed to fostering a welcoming andaccessible work environment, where all everyone feels valued, respected, and supported to succeed.
We offer accommodation for applicants with disabilities as part of its recruitment process. If you are contacted to arrange for an interview or testing, please advise us if you require an accommodation.
The hiring range for this position is $ 95,594.40- $ 133,832.16 CAD per year. The final agreed-upon salary may vary based on factors such as job-related knowledge, skills and experience.
We are looking for top talent. If your qualifications differ from those listed above, the scope of work and final agreed-upon salary may be adjusted to reflect your individual qualifications.
The Apotex Total Rewards package goes beyond base salary. Apotex offers bonus programs based on your position in the organization, you can excel based on our pay-for-performance philosophy. With comprehensive benefits, a pension plan to help you save for retirement and learning and development opportunities, we provide a comprehensive package for your personal and professional development.
Apotex will use artificial intelligence to screen, select and/or assess your application for this job.
This job posting is for a role that is currently available and vacant at Apotex
#J-18808-Ljbffr
Apotex is a Canadian-based global health company. We improve everyday access to affordable, innovative medicines and health products for millions of people worldwide, with a broad portfolio of generic, biosimilar, innovative branded pharmaceuticals and consumer health products. Headquartered in Toronto, with regional offices globally, including in the United States, Mexico and India, we are the largest Canadian-based pharmaceutical company and a health partner of choice for the Americas for pharmaceutical licensing and product acquisitions.
For more information visit:
Job Summary
The Manager, Business Intelligence & Reporting is responsible for designing and delivering Commercial reporting architecture, data strategy & governance, visualization and reporting. This person will work with IT to align database architecture with evolving business needs, applying sound database management principles and developing robust processes for extracting, transforming, and standardizing data from multiple sources. They must also develop and maintain processes for retrieving, standardizing, and loading data in an accurate and timely manner into relevant database tables. The role is responsible for modernizing data management and reporting processes, by leveraging best practices and emerging technologies, including Databricks. They will architect scalable data structures that enable integrated reporting across multiple lines of business through a single, consistent reporting framework. The Manager, Business Intelligence & Reporting will be organizing,overseeing, and executing Business Intelligence reporting needs of the Canadian Commercial organization, providing insights and time savings to a variety of Commercial stakeholders through high‑quality data visualization, reporting, and analytics. This role partners closely with cross‑functional stakeholders to understand business requirements and translate them into scalable BI solutions, primarily using Power BI and modern analytics tools. They are further responsible for ensuring that all reports, applications, and tools provided to the business are using correct and consistent data sources. In addition to enabling data‑driven decision‑making, this role supports commercial IBP, budgeting and performance calculation processes by maintaining data and providing reporting related to budget, targets, and performance. They will take ownership of supplying supporting data for these key processes, working with deliverable owners to ensure deliverables can be provided accurately and on time for each cycle. They will utilize best practices of Organizational Change Management to guide all rollout plans of new technology and processes. As a Manager, they should take on a leadership role within the team, training on processes, and sharing knowledge and best methods as widely as possible.
Job Responsibilities
Improve and modernize data preparation and load processes
Identify and implement opportunities for modernized data flows utilizing best in class approach to Databricks functionality
Understand Apotex Canada Commercial data requirements and complex datasets
Integrate data from various lines of business and sources into a unified reporting view
Liaise with IT teams to ensure database architecture aligns with ability to efficiently fulfil business needs
Manage Commercial databases, ensuring timely flow of clean and accurate data
Provide database architecture solutions and suggestions based on a deep understanding of data sources and business needs
Develop processes for extracting, receiving, and standardizing data to be used in reporting
Design database in a way that supports growing development of data-driven AI projects
Develop and maintain data visualization apps in support of Apotex Canada Commercial teams
Understand user requirements and implement BI projects
Responsible for executing or overseeing ad hoc reporting and analysis as required by cross-functional teams within Apotex Canada Commercial, or areas impacting Apotex Canada Commercial, and as prioritized within Commercial Excellence deliverables
Lead development of Power BI applications for Apotex Canada Commercial teams
Responsible for developing and maintaining Data Sourcing standards to be used across all tools, applications, and reports delivered by Commercial Excellence team
Lead cross-functional project teams to gather, understand, and execute requirements to maximize efficiency within the Commercial organization
Liaise with GIS on cross functional projects, develop priorities given limited resources and ensure alignment of all teams to achieve goals
Provide expertise on data preparation, sourcing, and management for AI initiatives
Liaise with users and GIS to troubleshoot issues with active BI dashboards owned by Commercial Excellence
Develop and maintain Data Source matrix, defining best practices for sourcing data used in Commercial Excellence reporting, applications, and tools
Ensures that all tools, applications, and reports provided by Commercial Excellence team adhere to defined Data Sourcing standards
Ensure data architecture is designed to support evolving requirements to support IBP
Work with Analyst, Commercial Excellence on any troubleshooting and development required for IBP reporting processes
Act as backup for running end-to-end IBP monthly process
Deliver reporting in a timely manner to support sales compensation processes
Build and manage a central database for Apotex Canada budgeting
Build and manage a Sales Rep Compensation database that will generate monthly reports and variance analysis
Stay up-to-date on modern technology and best practices related to reporting and database management
Support, as needed, any existing tools and processes owned by Commercial Excellence
Works in a safe manner collaborating as a team member to achieve all outcomes
Demonstrate Behaviours that exhibit our organizational Values: Integrity, Courage, Teamwork, and Innovation
Ensure personal adherence with all compliance programs including the Global Business Ethics and Compliance Program, Global Quality policies and procedures, Safety and Environment policies, and HR policies
All other relevant duties as assigned
Job RequirementsEducation
University degree: Business, Engineering, Science, Mathematics, Computer Sciences preferred
Knowledge, Skills And Abilities
Proficiency in SQL, Python, VBAand other ddvelopment tools
Profiency with data visualization software (Power BI preferred;
Qlik;
Tableau)
Previous experience with Databricks or similar cloud-based data platform
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 an asset
Knowledge of statistical procedures and applied data validation
Excellent written and verbal communication skills
Ability to work with all levels within the organization
Experience
Experience in the Canadian Pharmaceutical industry working with pharmaceutical data systems and conducting extensive focused analytics
Experience working with pharmaceutical leadership to understand the Canadian market environment and advance corporate goals
Experience in performance analytics
At Apotex, we are committed to fostering a welcoming andaccessible work environment, where all everyone feels valued, respected, and supported to succeed.
We offer accommodation for applicants with disabilities as part of its recruitment process. If you are contacted to arrange for an interview or testing, please advise us if you require an accommodation.
The hiring range for this position is $ 95,594.40- $ 133,832.16 CAD per year. The final agreed-upon salary may vary based on factors such as job-related knowledge, skills and experience.
We are looking for top talent. If your qualifications differ from those listed above, the scope of work and final agreed-upon salary may be adjusted to reflect your individual qualifications.
The Apotex Total Rewards package goes beyond base salary. Apotex offers bonus programs based on your position in the organization, you can excel based on our pay-for-performance philosophy. With comprehensive benefits, a pension plan to help you save for retirement and learning and development opportunities, we provide a comprehensive package for your personal and professional development.
Apotex will use artificial intelligence to screen, select and/or assess your application for this job.
This job posting is for a role that is currently available and vacant at Apotex
#J-18808-Ljbffr
Vacancy posted 2 hours ago
Similar jobs that could be interesting for youBased on the Manager, Bi & Reporting in Winnipeg, MB vacancy
$95.59k - $133.83k per year
...licensing and product acquisitions.The Manager, Business Intelligence & Reporting is responsible for designing and... ...requirements and translate them into scalable BI solutions, primarily using Power BI... ...responsible for ensuring that all reports, applications, and tools provided to...Business intelligenceWorldwide- Reporting & Dashboard Development Develop and maintain SSRS reports and Power BI dashboards for operational and strategic needs. Manage report development cycles including testing, stakeholder sign-off, and migration to production. Maintain and refine existing...Business intelligenceNight shift
- ...Apotex is seeking a Manager, Business Intelligence & Reporting to design and deliver commercial reporting architecture, data strategy, governance, and visualization... ...data management with Databricks. The role leads BI projects for Apotex Canada Commercial, delivering high-...Business intelligence
- Job TitleSAP BI Reporting Analyst Location: Calgary, AlbertaWork Environment: In officePrecision Drilling is a leading land drilling contractor... ...LIFE: Design, develop, and maintain BI solutions, including reports and dashboards in SAP Analytics Cloud (SAC) and Analysis for...Business intelligenceFor contractorsWork at officeFlexible hours
$82k - $92k per year
The RoleAs a Senior BI Analyst in the Reporting & BI team, you will be the owner of HelloFresh's data landscape for your domain. You will build and... ..., or similar) that reach senior leadership Stakeholder management — experience translating ambiguous business challenges into...Business intelligenceWork at officeRemote workWork from homeFlexible hours2 days per week3 days per week- Transform wealth management analytics at National Bank by leading BI, reporting, and AI-enabled data capabilities. This hybrid leadership role requires three office days weekly.As Senior Director of Wealth Management IT, you will lead the BI and Reporting team and deliver analytics...Business intelligenceWork at office
- Power BI expertise meets project performance reporting in this analyst role supporting cost, schedule, risk, and resource insights. The position is based in... ...communicating project information. You will develop dashboards, reports, datasets, and data models while supporting project...
- ...Lead financial reporting and strategic analysis as AMA’s Finance Manager, working in-office with accounting expertise and collaborative leadership. Turn complex data into decisions. As Finance Manager, you will prepare financial information, support audit and regulatory...Work at office
- Elevate your reporting skills with a Senior Report Developer role in Toronto at the forefront of data migration and modernization. Focus on Power BI and SQL to transform operational reports. This onsite... ...closely with the Project Manager and Business Areas. Your role emphasizes...
- ...accurately communicate tax matters. The Senior Manager, Income Tax actively engages with... ...capacity, and support recruiting. Tax Reporting, Provision and Compliance Manage the consolidated... ...Advanced Excel and data skills; Power BI or similar analytics tools an asset....Local area
- A recruitment services firm is seeking a Manager, Financial Reporting for a 6-month contract in Toronto, Ontario. The role involves preparing financial... ...or Finance and proficiency in Microsoft Excel and BI tools. The salary ranges from CA$125,000 to CA$139,000. #J-18808...Business intelligenceContract work
- ...Torys LLP in Toronto is seeking a Data Analyst, Reporting to deliver accurate financial and business reporting... ...You will translate stakeholder needs into clear reports, dashboards and recurring deliverables, using Excel, Power BI and SQL, with emphasis on data accuracy and...Work at office
- ...BeachHead Inc. in Toronto, Canada seeks a Senior Power BI Developer to lead complex reporting projects for a banking client. You will own paginated reports, interactive dashboards, data validation, mapping, and remediation, partnering with business stakeholders and technology...Business intelligence
- ...Enterprise Report Developer Winnipeg, MB Manitoba Hydro is consistently recognized as... ...refresh, query folding, and large dataset management strategies. Monitor, troubleshoot, and... ...visualization platforms, such as Microsoft Power BI, SAP Analytics Cloud (SAC), Tableau, Qlik...Business intelligenceHourly payLong term contractFull timeInternshipWork at office
- ...Kumaran Systems is seeking a hands-on Senior Analytics Engineer to modernise enterprise reporting solutions on Data-bricks and Power BI. You will develop governed datasets, interactive dashboards, and automated reporting for business users, collaborating across data engineering...
- Data & Reporting AnalystLocation: Toronto Work Model: Hybrid (4 Days WFO) Duration:... ...Top 3 Required Skills SQL Power BI Tableau Job DescriptionWe are seeking... ..., and maintain interactive dashboards and reports using Tableau and Power BI. Build scalable...
- ...Price Café offers free Tea and Coffee. Reporting & Process Analyst Campus: 638 Raleigh St., in-person Reporting To: Plant Manager, GRD Position Summary The Reporting... ...maintain, and continuously improve Power BI reports, dashboards, and analytical tools that...
$171.1k - $227.5k per year
Join to apply for the Manager II, Engineering - AI/BI role at DatabricksAt Databricks, we are passionate about helping data teams solve the world... ...expressivity of our business semantics products.You will report directly to the Senior Manager of Engineering.The Main...Business intelligenceLong term contract$102k - $141k per year
...Ontario M5E 1V3 Canada Job Title: Manager, Advanced Analytics & BI Canada Goose isn\ 't like anything... ..., and delivery of the enterprise reporting and advanced analytics ecosystem that... ...requirements into consumption patterns, reports, and multi-dimensional models...Business intelligenceLong term contractLive In- ...would love to hear from you.As the Manager, Analytics and Reporting, you will lead the development of data... ...enrolment trends for other departments and reports on programs, market segmentation, and... ...solutions using Tableau, Power BI, or similar visualization platforms....Business intelligence
- ...Connor, Clark & Lunn Financial Group Ltd. in Toronto and Vancouver is seeking a Senior Analyst for the Client Reporting Development Team. The role focuses on designing and implementing enhancements to our client reporting suite, translating complex logic into robust code...
- ...applicantsManager of Business Intelligence (BI) - Permanent FTLocation: London... ...of experience leading and managing a team of BI analysts and... ...and motivate a team, and to manage multiple projects simultaneously... ...and maintenance of dashboards, reports, and self-service analytics tools...Business intelligencePermanent employmentRemote work
$70k - $150k per year
...: 33 Dundas Street West Job Family Group: Data Analytics & Reporting As a Manager, Risk Report Development, you'll combine your deep technical expertise in... ...reporting solutions by using Python, SAS, SQL and Power BI to meet management and regulatory reporting requirements.Performs...Business intelligencePart timeWork at office- Lead reporting and data strategy remotely anywhere in Canada, using SQL,... ...to improve enterprise delivery. Manage a team while guiding dependable... ...while shaping internal data, BI capabilities, automation, and AI... ...Responsibilities: Own enterprise report requirements, accuracy, content...Business intelligenceRemote work
$98.83k - $123.54k per year
...District #33Manager of Financial Reporting and AnalyticsSchool District... ...in public education. The Manager of Financial Reporting and Analytics... ...Prepare financial performance reports for district, Board, Ministry,... ...and tools such as Excel and Power BI. Salary Range: $98,831 to...Long term contractFlexible hours$50.9k - $76.4k per year
...Overview: The Investment Reporting Analyst, Global Investment... ...reporting, financial statements, and Management's Discussion and Analysis (MD&... ...investment compliance reports and comparing Great-West Lifeco... ...~ Knowledge of SQL, Power BI, Microsoft Access and Microsoft...Permanent employmentFull timePart timeInternshipFlexible hours- Lead engineering reporting and Power BI systems within Sofina Canada, managing capital project information, AFE processes, and technical requirements. This data-driven... ..., Environment, Maintenance and Reliability, the Manager oversees processes, reporting, and systems. The position...Business intelligence
- ...hybrid Mississauga office through AI tools, Power BI dashboards, and process improvement.In this Commercial Finance Manager role, you will support Canadian Finance... ...across a matrix organization. Your work includes reporting, compliance, internal controls, product costing...Business intelligenceWork at office
- ...in our unique and ambitious world. The Manager, Analytics & Reporting will lead the creation of trusted,... ...this hands‑on role, you will use Power BI, Snowflake, and SQL to build high‑impact... ...semantic models, scorecards, operational reports, executive insights, and self‑service...Business intelligenceLong term contractPermanent employmentContract workTemporary workFixed term contractWork at officeFlexible hours3 days per week
- The Manager role for the Workday Reporting and Analytics team will support practice leadership and provide expert... ...appropriately. The Manager role will report to a Director or Senior Manager within... ...on development items during the bi-annual review processManage the pursuit...Business intelligenceTemporary workImmediate startRemote work
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Manager, Bi & Reporting. Be the first to apply!

