Senior BI Analyst

Canadian Tire Financial Services; Toronto; Hybrid; CAD 64,000 - 106,000; Full time

Benefits offered by this job

Benefits & retirement

Performance incentives

Education programs

Product discounts

Job summary

Canadian Tire Financial Services is seeking a Senior BI Analyst to transform data into actionable insights across marketing, loyalty, merchandising and promotions. You will design and deliver scalable analytics, pipelines and Power BI solutions, partnering with stakeholders to translate business questions into robust dashboards and datasets.

You will build data models, DAX calculations and semantic layers, apply governance, and drive self-service analytics across the organization, leveraging

Qualifications

• Bachelor's degree in a quantitative field like Statistics, Mathematics, Data Science, CS, Economics or related discipline.
• 3+ years of analytics, BI, or marketing analytics experience.
• Strong SQL skills for large datasets, data wrangling and validation.
• Hands-on experience building and maintaining Power BI solutions including data modeling and DAX.

Responsibilities

• Partner with stakeholders to translate requirements into scalable data and visualization solutions.
• Source and integrate data from multiple enterprise systems for BI initiatives.
• Design, develop and maintain automated data pipelines and datasets using SQL, Python/PySpark and cloud platforms.
• Build interactive Power BI dashboards, scorecards and visualizations for leadership and users.
• Ensure data accuracy, governance and quality through validation and best practices.

Skills

SQL

Power BI

Python

PySpark

Databricks

Azure Synapse

DAX

Dimensional modeling

Data pipelines

Stakeholder management

Education

Bachelor's degree in Statistics/Math/Data Science/CS/Analytics

Tools

Databricks

Azure Synapse

Microsoft Fabric

Job description

Senior BI Analyst# Careers## Senior BI AnalystApply: Toronto, ON: Oakville, ON: Full time: Posted Yesterday: End Date: November 13, 2026 (12 days left to apply): JR167169**What You’ll Do:** As a Senior BI Analyst, you will play a key role in transforming data into actionable business insights. You will work across the full analytics lifecycle, partnering with business stakeholders to design, develop, and deliver scalable analytics, reporting and BI solutions that support data-driven decision making across marketing, loyalty, merchandising, and promotional initiatives. In this role, you will: * Partner with business stakeholders to understand reporting and analytical requirements, translating business questions into scalable data and visualization solutions.* Identify, source, and integrate data from multiple enterprise systems to support business intelligence and analytical initiatives.* Design, develop, and maintain automated data pipelines and curated analytical datasets using SQL, Python/PySpark, and cloud-based analytics platforms.* Leverage modern analytics technologies such as Azure Synapse, Microsoft Fabric, Databricks, and Power BI to build efficient, scalable, and maintainable reporting solutions.* Design and develop robust data models, semantic models, and reporting datasets that enable trusted, high-performing self-service analytics.* Apply data modeling best practices, including dimensional modeling, star schema design, fact and dimension structures, and measure governance to support enterprise reporting needs.* Build and maintain interactive Power BI dashboards, scorecards, and visualization solutions that provide meaningful insights to business users and leadership teams.* Develop advanced DAX calculations, KPIs, performance metrics, custom tooltips, drill-through experiences, and other interactive reporting features to enhance analytical capabilities.* Conduct analysis of campaign, customer, loyalty, sales, and promotional performance to identify trends, opportunities, and business drivers.* Ensure data accuracy, consistency, and quality by implementing validation processes, data governance standards, and reporting best practices.* Communicate complex analytical findings through clear visualizations, presentations, and business-focused storytelling.* Continuously improve reporting frameworks, data assets, and analytical processes through automation, optimization, and innovation.**What You Bring:** * Bachelor's degree in Statistics, Mathematics, Data Science, Computer Science, Economics, Business Analytics, or a related quantitative discipline.* 3+ years of experience in analytics, business intelligence, marketing analytics, performance measurement, or a related field.* Strong SQL skills with experience querying, transforming, and validating large datasets.* Hands-on experience building and maintaining Power BI solutions, including data modeling, DAX development, report design, and dashboard visualization.* Strong understanding of dimensional modeling concepts, fact and dimension tables, star schema design, and semantic model development for Power BI.* Experience developing automated data pipelines using Python, PySpark, SQL, or similar technologies.* Experience working with cloud-based analytics and data engineering platforms.* Hands-on experience with Databricks is required.* Experience with Azure Synapse Analytics, Microsoft Fabric, or similar modern analytics platforms is highly desirable.* Excellent communication and stakeholder management skills with the ability to explain technical concepts to non-technical audiences. **Location**: Toronto, Ontario (Hybrid: In-office 4 days per week) We’re always looking for great talent! In addition to competitive pay, we offer:* Comprehensive benefits and retirement programs* Performance incentives, Continuing Education Programs* Other perks to support your well-being* Career growth opportunities and product discounts **Broadband Salary Range:** $64,000 – $106,000 Our typical *hiring range* is between $64,000 and $85,000. Salary decisions are also dependent on other factors such as your experience, industry benchmarks, internal equity and other role-specific requirements. For critical roles, the compensation offering will be reviewed to ensure alignment with market rate and conditions and the unique value you bring to the role.#LI-AK1We may use artificial intelligence tools as part of our recruitment process to assist in the initial screening of resumes. All hiring decisions, including candidate evaluation, selection, and disposition, are made by human recruiters.