Business Intelligence Analyst

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: www.apotex.com.

Job Summary

As a Business Intelligence Analyst, you will build and support Power BI reporting products and contribute to business-facing AI agents that improve everyday workflows. In this role you will also perform business analyst activities, including partnering with stakeholders to understand processes, elicit and document requirements, write user stories, and define acceptance criteria. You will translate business needs into dashboards, paginated reports, and semantic models, and you will support well-scoped Copilot/GenAI agent workflows (e.g., intake triage, knowledge lookup, summarization, and drafting) by configuring prompts, validating outputs, and maintaining documentation and runbooks under guidance to deliver reliable and compliant outcomes.

Job Responsibilities

• Clarify reporting and agent requirements with business analysts and stakeholders, confirming definitions, inputs, outputs, and success criteria.
• Draft and refine dashboard layouts and report mockups, incorporating feedback to improve usability and consistency.
• Develop and publish Power BI dashboards and reports using established visualization standards, ensuring accurate calculations and filters.
• Build and maintain Power BI semantic models (datasets), applying team patterns for performance, refresh reliability, and reuse.
• Implement report and dataset security based on defined roles, validating access and supporting audits when required.
• Develop and maintain paginated reports in Power BI Report Builder for formatted, print-ready, and operational outputs.
• Use Git-based version control for Power BI artifacts and supporting code, following branching and review practices.
• Collaborate with peers through code reviews and knowledge sharing, adopting feedback to improve solution quality.
• Troubleshoot and resolve issues across reports, datasets, and refreshes, communicating status and root cause clearly.
• Support data engineers by validating pipeline outputs (Azure/Databricks) and confirming that datasets meet reporting needs.
• Contribute to defined AI/ML tasks by prototyping, evaluating outputs, and documenting results with guidance from senior staff.
• Configure and enhance well-scoped Copilot/GenAI agent workflows for business use, validating responses and escalation paths.
• Run basic agent tests using curated prompts, record outcomes, and support updates to improve reliability over time.
• Prepare concise demos and status updates for BI deliverables and agent workflows, highlighting risks, decisions, and next steps.
• Document BI solutions, data definitions, agent prompts, and runbooks using team standards to enable support and reuse.
• Apply prompt engineering basics to guide agent behavior, using clear instructions, constraints, examples, and iterative refinement.
• Follow responsible AI and data governance practices, ensuring sensitive data is handled appropriately in BI and agents.
• Maintain awareness of Power BI and GenAI updates relevant to assigned work, applying improvements as directed.
• 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 Requirements

• Education
  • Bachelor's degree in Computer Science, Data Science, Information Systems, or a related field.
• Knowledge, Skills and Abilities
  • Working knowledge of Power BI development, including semantic modeling, DAX measures, Power Query (M), and report design.
  • Ability to translate business requirements into clear specifications for reports, datasets, and agent workflows and behaviors.
  • Working knowledge of visualization and UX practices to build dashboards that are clear, consistent, and actionable.
  • Experience building paginated reports in Power BI Report Builder to support operational and print-ready needs.
  • Working knowledge of data visualization practices and the ability to create clear, actionable dashboards.
  • Working knowledge of Power BI Service features (workspaces, sharing, refresh) and basic administration concepts.
  • Working knowledge of performance tuning basics (model design, DAX efficiency, refresh) and a continuous-improvement mindset.
  • Familiarity with Copilot Chat (or approved GenAI tools) and building simple business agents with human review, monitoring, and escalation.
  • Prompt engineering fundamentals to guide agent behavior, iterate on results, and verify outputs for accuracy and compliance.
  • Familiarity with core AI/ML concepts and common use cases (e.g., classification, summarization, information extraction).
  • Basic Python skills to write simple scripts or notebooks for data preparation, automation, and lightweight AI experimentation.
  • Demonstrated curiosity to learn new analytics and GenAI capabilities and apply them to assigned business problems.
  • Understanding of data warehousing concepts and dimensional modeling to support reliable reporting structures.
  • Advanced SQL skills to develop and optimize queries (joins, CTEs, window functions), validate data, and troubleshoot performance issues.
  • Familiarity with cloud data platforms, especially Microsoft Azure, and how services support data and analytics solutions.
• Experience
  • 1–3 years of experience delivering BI solutions, with hands-on Power BI development (or equivalent experience).
  • Experience across the BI lifecycle, including requirements, development, testing, deployment, and production support.
  • Hands-on experience using SQL for analytics, including joining multiple sources, creating reusable queries, and investigating data quality issues.
  • Experience using Git for version control and collaborating through branches, pull requests, and reviews.
  • Exposure to AI projects or coursework, including testing or configuring chat-based agents, is an asset.
  • Familiarity with Azure and Databricks is beneficial for understanding data pipelines that feed analytics products.
  • Experience working in an agile delivery environment is preferred, including basic planning, estimation, and retrospectives.

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 $83,958.00- $139,930.00 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.