Business intelligence developer Jobs in Brampton, ON

Job Description

As a senior member of the Enterprise Portfolio Management Office (EPMO) within McKesson Technology (MT), this position plays a critical role in translating complex data into strategic insights that drive enterprise decision-making, portfolio optimization, and operational efficiency. The Sr. BI Analyst will lead data initiatives that enhance visibility, drive accountability, and support performance measurement across portfolios, programs, and IT investments.

This role requires a high degree of technical expertise, cross-functional collaboration, and business acumen to influence outcomes at both tactical and strategic levels. You will champion data quality, standardization, and governance practices, working closely with stakeholders across MT, finance, and business units to design and deliver impactful analytical products and visualizations.

This position will focus on designing and deploying automation solutions and scalable data products using tools such as Power Automate, Power Apps, Power BI, and Microsoft Fabric. You will collect, connect, and transform data from a variety of systems, building reusable workflows, apps, and self-service analytics that drive decision-making and operational efficiency. A key responsibility will be to establish and protect trusted data sources—ensuring they are well-governed, consistently structured, and easily accessible for business users.

The role requires a strong understanding of automation, low-code/no-code platforms, and data modeling practices that support both operational reporting and proactive insights. You will work closely with internal teams to translate business needs into automated solutions, self-service dashboards, and predictive analytics. Responsibilities include designing user-friendly interfaces, developing automated data pipelines, enabling self-service capabilities, and supporting best practices in data quality, governance, and reusability.

Key Responsibilities

• Design, build, and operationalize automated workflows that reduce manual effort across portfolio lifecycles
• Develop AI-assisted capabilities that enhance decision-making and governance
• Build predictive and rules-based models that support prioritization, risk detection, and delivery forecasting
• Engineer clean, reliable data pipelines needed for automation and AI models
• Collaborate with IT, Finance, and EPMO leaders to translate business questions into scalable AI and automation solutions
• Implement data quality and integrity practices that ensure AI and automation outputs remain reliable and auditable
• Build reusable analytics assets that serve as the foundation for AI-enabled portfolio insights
• Continuously assess emerging tools and capabilities to advance maturity of AI and automation

Minimum Requirements

• Degree or equivalent and typically requires 7+ years of relevant experience.

Critical Skills

• Strong experience building automated analytics solutions in Power BI and/or Fabric
• Hands-on experience designing workflow automations using Power Automate or similar tools
• Solid SQL proficiency for transforming complex operational and financial data
• Experience with modern data engineering platforms (Fabric, Databricks, or Snowflake)
• Practical experience applying generative AI tools (e.g., Copilot, Azure, OpenAI) to business workflows
• Experience with predictive analytics (e.g. correlational studies, regression analysis)
• Experience working with executive leadership
• Ability to translate business problems into decision intelligence solutions
• Strong cross-functional partnership and product-thinking mindset

Additional Skills and Qualifications

• Familiarity with portfolio and project management platforms
• Working knowledge of Python for data engineering and ML experimentation
• Strong understanding of modern data architecture and governance principles
• Exposure to MLOps or operationalizing machine learning workflows
• Experience designing user-centric analytics or automated workflows

Physical Requirements
Professional office environment

Travel may be required in some circumstances < 10%

We are proud to offer a competitive compensation package at McKesson as part of our Total Rewards. This is determined by several factors, including performance, experience and skills, equity, regular job market evaluations, and geographical markets. The pay range shown below is aligned with McKesson's pay philosophy, and pay will always be compliant with any applicable regulations. In addition to base pay, other compensation, such as an annual bonus or long-term incentive opportunities may be offered. For more information regarding benefits at McKesson, please

Our Base Pay Range for this position

$99,100 - $132,100

McKesson has become aware of online recruiting-related scams in which individuals who are not affiliated with or authorized by McKesson are using McKesson’s (or affiliated entities, like CoverMyMeds or RxCrossroads) name in fraudulent emails, job postings or social media messages. In light of these scams, please bear the following in mind:

McKesson Talent Advisors will never solicit money or credit card information in connection with a McKesson job application.

McKesson Talent Advisors do not communicate with candidates via online chatrooms or using email accounts such as Gmail or Hotmail. Note that McKesson does rely on a virtual assistant (Gia) for certain recruiting-related communications with candidates.

McKesson job postings are posted on our career site: .