Specialist, AI-BI Developer

Apply now »

Date: Jul 21, 2025

Location: North York, ON, CA, M9L 1N7

Company: Apotex

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 BI and AI Developer, you will be instrumental in building and enhancing our business intelligence capabilities, with a strong emphasis on Microsoft Power BI development. Your responsibilities will span the entie Power BI lifecycle, from gathering user requirements and wireframing initial designs to developing interactive dashboards, paginated reports, and implementing write-back functionalities. You will also contribute to exciting AI initiatives, including exploring and implementing natural language processing models and other AI/ML solutions to augment our analytical capabilities. You will collaborate closely with business analysts, data engineers, and architects to understand needs, build user-centric solutions, and foster a data-driven culture within the organization.

Job Responsibilities

  • Lead requirements gathering sessions with stakeholders to understand their reporting and analytical needs.
  • Create wireframes and mockups of Power BI dashboards and reports to effectively communicate design concepts and ensure optimal user experience (UX).
  • Design, develop, and deploy interactive and visually appealing reports and dashboards using Microsoft Power BI, adhering to UX best practices.
  • Develop and maintain Power BI data models, ensuring optimal performance and scalability.
  • Connect to various data sources and transform data using Power Query (M language) within Power BI.
  • Implement and manage Power BI security models and access controls.
  • Develop and deploy paginated reports using Power BI Report Builder for formatted, print-ready outputs.
  • Design and implement write-back solutions within Power BI to enable users to input or modify data through reports (where applicable).
  • Utilize Git for version control of Power BI project files, code (e.g., DAX, M), and other relevant development artifacts.
  • Collaborate with the team using Git for branching, merging, and code reviews.
  • Troubleshoot and resolve issues related to Power BI reports, dashboards, and paginated reports.
  • Participate in the design and development of data pipelines within Azure and Databricks to support Power BI reporting.
  • Explore and experiment with AI/ML technologies, particularly natural language processing models like GPT, to identify potential business applications.
  • Assist in the development and implementation of AI-powered features and solutions, working alongside senior team members.
  • Prepare and present findings and prototypes related to AI initiatives.
  • Document BI solutions and AI experiments.
  • Stay up-to-date with the latest advancements in Power BI and AI technologies.
  • Participate in code reviews and contribute to BI and AI development best practices

Job Requirements

  • Education
    • Bachelor's degree in Computer Science, Data Science, Information Systems, or a related field.
  • Knowledge, Skills and Abilities
    • Deep understanding of Microsoft Power BI development, including data modeling, DAX (Data Analysis Expressions), Power Query (M language), and report/dashboard design principles.
    • Proven ability to conduct requirements gathering and translate business needs into technical specifications.
    • Experience in wireframing and designing user-friendly Power BI dashboards and reports, with a strong understanding of UX principles.
    • Expertise in developing and deploying paginated reports using Power BI Report Builder.
    • Experience implementing write-back solutions in Power BI (e.g., using Power Apps visual or other custom solutions).
    • Proven ability to connect to various data sources (e.g., databases, cloud services, APIs) within Power BI.
    • Strong skills in data visualization and creating impactful dashboards.
    • Understanding of Power BI service administration basics, including workspace management and sharing.
    • Knowledge of Power BI performance optimization techniques.Technology and Data savviness, passionate about latest technology trends and data driven mindset, innovative and curious mindset, with a passion for learning and teaching
    • Familiarity with basic concepts of Artificial Intelligence and Machine Learning.
    • Exposure to Natural Language Processing (NLP) concepts and models, including large language models like GPT.
    • Understanding of how to interact with APIs for AI services.
    • Basic programming skills in Python or a similar language relevant to AI/ML.
    • An interest in exploring and experimenting with new AI technologies.
    • Understanding of data warehousing concepts and dimensional modeling.
    • Proficiency in SQL for querying and manipulating data.
    • Familiarity with cloud data platforms, particularly Microsoft Azure.
    • Experience with platforms like GitHub, GitLab, or Azure DevOps for repository management.
  • Experience
    • Minimum of 3 years of hands-on experience in Business Intelligence development with a strong focus on Microsoft Power BI.
    • Proven experience in the full Power BI development lifecycle, including requirements gathering, wireframing, development, and deployment.
    • Experience developing paginated reports using Power BI Report Builder.
    • Experience implementing write-back functionalities in Power BI is a plus.
    • Experience using Git for version control in a collaborative development environment.
    • Some exposure to or participation in AI-related projects or experimentation is a plus.
    • Familiarity with Azure and Databricks is beneficial.
    • Experience working in an agile development environment is preferred.
    • Experience with Dash or Plotly development is considered a strong plus.

At Apotex, we are committed to fostering a welcoming and accessible 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.