Specialist, AI-BI Developer

Apotex; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading health company in Toronto is looking for a BI and AI Developer to enhance its business intelligence capabilities. The role involves developing Power BI dashboards, collaborating on AI initiatives, and implementing write-back solutions. The ideal candidate has a Bachelor's degree, at least 3 years of relevant experience, and deep knowledge of Power BI. This position supports a welcoming work environment committed to accessibility.

Benefits

Accommodations for applicants with disabilities

Supportive work environment

Qualifications

• Deep understanding of Power BI development and report/dashboard design principles.
• Minimum of 3 years of BI development experience focusing on Power BI.
• Familiarity with AI/ML concepts and basic programming skills.

Responsibilities

• Lead requirements gathering sessions with stakeholders.
• Design and develop interactive reports and dashboards using Power BI.
• Collaborate with the team using Git for code management.
• Explore AI technologies for business applications.

Skills

Power BI development

Data modeling

DAX

Power Query

User experience (UX) design

Git

Natural Language Processing (NLP)

Python

Education

Bachelor's degree in Computer Science, Data Science, or related field

Tools

Microsoft Power BI

Azure

Databricks

Job description

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

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 entire 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 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

1. Lead requirements gathering sessions with stakeholders to understand their reporting and analytical needs.
2. Create wireframes and mockups of Power BI dashboards and reports to communicate design concepts and ensure optimal user experience (UX).
3. Design, develop, and deploy interactive and visually appealing reports and dashboards using Microsoft Power BI, adhering to UX best practices.
4. Develop and maintain Power BI data models, ensuring performance and scalability.
5. Connect to various data sources and transform data using Power Query (M language) within Power BI.
6. Implement and manage Power BI security models and access controls.
7. Develop and deploy paginated reports using Power BI Report Builder for formatted, print-ready outputs.
8. Design and implement write-back solutions within Power BI to enable user data input or modification through reports (where applicable).
9. Utilize Git for version control of Power BI project files, code (e.g., DAX, M), and other development artifacts.
10. Collaborate with the team using Git for branching, merging, and code reviews.
11. Troubleshoot and resolve issues related to Power BI reports, dashboards, and paginated reports.
12. Participate in designing and developing data pipelines within Azure and Databricks to support Power BI reporting.
13. Explore and experiment with AI/ML technologies, particularly NLP models like GPT, to identify business applications.
14. Assist in developing and implementing AI-powered features and solutions with senior team members.
15. Prepare and present findings and prototypes related to AI initiatives.
16. Document BI solutions and AI experiments.
17. Stay updated with the latest advancements in Power BI and AI technologies.
18. Participate in code reviews and contribute to BI and AI development best practices.

Job Requirements

1. Bachelor's degree in Computer Science, Data Science, Information Systems, or a related field.
2. Deep understanding of Power BI development, including data modeling, DAX, Power Query, and report/dashboard design principles. Proven ability to gather requirements and translate business needs into technical specifications. Experience in wireframing and designing user-friendly dashboards with UX principles. Expertise in deploying paginated reports using Power BI Report Builder. Experience implementing write-back solutions in Power BI. Ability to connect to various data sources, with skills in data visualization and dashboard creation. Basic knowledge of Power BI service administration and performance optimization techniques. Familiarity with AI/ML concepts, NLP models like GPT, interacting with AI APIs, and basic programming skills in Python or similar. Understanding of data warehousing, SQL, and cloud platforms like Azure. Experience with version control systems like GitHub, GitLab, or Azure DevOps.
3. Minimum of 3 years of hands-on BI development experience focusing on Power BI. Proven experience in the full development lifecycle, including requirements gathering, wireframing, development, and deployment. Experience with paginated reports and write-back functionalities a plus. Exposure to AI projects or experimentation is a plus. Familiarity with Azure, Databricks, and agile environments. Experience with Dash or Plotly is considered a strong plus.

At Apotex, we are committed to fostering a welcoming and accessible work environment, where everyone feels valued, respected, and supported to succeed.

We offer accommodations for applicants with disabilities during the recruitment process. If contacted for an interview or testing, please advise us if you require an accommodation.