Senior BI Analyst

Canadian Tire Corporation

. Partner with business stakeholders to understand reporting and analytical requirements, translating business questions into scalable data and visualization solutions .

Posted 10/30/2026full-timeToronto • CanadaSenior💰 CA$64,000 - CA$106,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in building and maintaining Power BI solutions, including data modeling and DAX development, while leveraging cloud-based analytics platforms like Azure Synapse and Databricks. Proficient in designing automated data pipelines and ensuring data quality through validation and governance practices.

Highest-signal resume keywords

Power BI DevelopmentSQL Querying and Data TransformationAutomated Data Pipeline DevelopmentDimensional ModelingCloud-Based Analytics

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLPythonPySparkDAXData ModelingDimensional ModelingData ValidationData GovernanceAnalyticsPerformance Measurement

Soft Skills

CommunicationStakeholder ManagementStorytelling

Tools & Technologies

Power BIAzure SynapseMicrosoft FabricDatabricksCloud-Based Analytics Platforms

Industry Keywords

Business IntelligenceMarketing AnalyticsPerformance MetricsData ScienceQuantitative Discipline

Tech Stack

Tools & technologies

AzureCloudPySparkPythonSQL

About the role

Key responsibilities & impact

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 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 for self-service analytics
Apply dimensional modeling best practices, including star schema design, fact and dimension structures, and measure governance
Build and maintain interactive Power BI dashboards, scorecards, and visualization solutions
Develop advanced DAX calculations, KPIs, performance metrics, custom tooltips, drill-through experiences, and interactive reporting features
Analyze campaign, customer, loyalty, sales, and promotional performance to identify trends, opportunities, and business drivers
Ensure data accuracy, consistency, and quality through validation processes, data governance standards, and reporting best practices
Communicate complex analytical findings through visualizations, presentations, and business-focused storytelling
Continuously improve reporting frameworks, data assets, and analytical processes through automation, optimization, and innovation

Requirements

What you’ll need

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

Benefits

Comp & perks

Comprehensive benefits and retirement programs
Performance incentives
Continuing Education Programs
Other perks to support your well-being
Career growth opportunities
Product discounts
Store discounts
Supported learning through the Triangle Learning Academy
Canadian Tire Profit Sharing
Retirement and savings programs for eligible employees
Mental health benefits in the amount of $5,000 per year for benefits-eligible employees and their families
Total well-being, and mental health tools and resources for all employees