Business Intelligence Analyst

Apotex•Toronto, ON

6d•CA$83,958 - CA$139,930

About The Position

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.

Requirements

Bachelor's degree in Computer Science, Data Science, Information Systems, or a related field.
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.
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.
Experience working in an agile delivery environment is preferred, including basic planning, estimation, and retrospectives.

Nice To Haves

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.

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.