Canadian Tire Corporation Logo

Canadian Tire Corporation

Data Analyst

Posted 7 Days Ago
Laval, QC
Mid level
Laval, QC
Mid level
As a Data Analyst, you will support data architecture, optimize SQL queries, design reports using Power BI, and collaborate with various teams on data systems.
The summary above was generated by AI

What you’ll do

Joining the Canadian Tire team in the FGL Sports division, you will be working as part of a team of data management analysts. 

Your role as a Data Analyst will be to support the Data Architecture in the development of various query requirements across multiple enterprise database sources. Design, implement and manage the structure of reporting systems. The Data Analyst is responsible for data extraction initiatives from our various systems, validation with business departments for ad hoc requests and project developments.

  • Support various business requests by being responsible for the optimization and creation of SQL queries
  • Design, build, deliver and manage models and reports using Excel and Power BI. Experience in Power automate
  • Present data from multiple enterprise database sources
  • Participate in the data architecture and data solution design of our various systems 
  • Collaborate with analysts in the development of connections and extractions with our various databases ((DataLake, Dynamics 365, Azure, I Hub ingestion, Synapse).
  • Support data validations during the integration of systems under different platforms
  • Analyze impacts in existing systems during change requests; Analyze and collaborate on structural specifications for new software and applications
  • Develop an in-depth understanding of the various processes
  • Support process documentation and provide automation recommendations
  • Participate in workshops to gather requirements and provide recommendations for reporting and BI solutions
  • Convert processes into functional requirements clearly and understandable to developers and project teams
  • Leverage knowledge of specific data products available as well as visualization capabilities to improve requirements and offer relevant suggestions to stakeholders
  • Prioritize tasks with the team and ensure the availability of forward-looking roadmaps for features to be delivered on data products under the team's purview
  • Collaborate with the Business Intelligence analysts and IT department in the realization of various requirements, as well as maintenance and evolution activities  

What you bring

  • 3+ years of experience in data analytics and good understanding of data architecture
  • Bachelor's degree in quantitative discipline (mathematics, statistics, computer science, economics)
  • Working knowledge of AI and data warehouse concepts and terminology.
  • Excellent Excel skills, especially with the use of advanced formulas and macros
  • Strong knowledge of SQL, ETL, Power BI (report design & visualization) and Microsoft Azure
  • Experience in Microsoft Dynamics AX & Dynamics 365 
  • Experience in analysis, modeling, verification, and development of business and technical requirements methodologies
  • Ability to establish, document and communicate data modeling standards, policies, guidelines, and governance structures.  Ability to prioritize projects within timelines
  • Self-motivated and able to work independently
  • Excellent oral and written communication skills with the ability to relate and describe situations with data; Ability to explain complex phenomena clearly and concisely to any type of hearing
  • Thorough person with a passion for quality and innovative technologies
  • Excellent command of French and English, both oral and written

*Bilingualism in French and English is required for this position. The role involves frequent collaboration and discussion with colleagues and partners across Canada. These interactions necessitate a high level of proficiency in French and English to effectively perform the tasks associated with the job.

Hybrid
 

At Canadian Tire we work flexibility embracing ‘Hybrid’ whereby individuals utilize a combination of working at a CTC campus and or virtually in service of outcomes. Determined by managers, decisions around work location will be made based on business and team needs and grounded in a desire to support individual well-being and personal needs. Our goal is to empower teams and individuals to make the right decisions for them, and we expect that to look different for everyone
 

#LI-MM2

About Us

Part of the Canadian Tire family is Sports Experts.  Your Sports Experts!  Built on more than 50 years tradition on customer focus, Sports Experts is headquartered in Laval, Quebec. Sports Experts is proud to promote a wide selection of sports equipment, clothing and footwear of renowned and exclusive brands.  By joining Sports Experts you will appreciate to work with an experienced team that will welcome you. We are the destination to Stay fit. Live well.

Our Commitment to Diversity, Inclusion and Belonging 

We are committed to fostering an environment where belonging thrives, and diversity, inclusion and equity are infused into everything we do. We believe in building an organizational culture where people are consistently treated with dignity while respecting individual religion, nationality, gender, race, age, perceived ability, spoken language, sexual orientation, and identification. We are united in our purpose of being here to help make life in Canada better. .

Accommodations  

We stand firm in our Core Value that inclusion is a must. We welcome and encourage candidates from equity-seeking groups such as people who identify as racialized, Indigenous, 2SLGBTQIA+, women, people with disabilities, and beyond. Should you require any accommodation in applying for this role, or throughout the interview process, please make them known when contacted and we will work with you to help meet your needs.

Top Skills

Dynamics 365
Excel
Azure
Power Automate
Power BI
SQL

Similar Jobs

2 Days Ago
2 Locations
Mid level
Mid level
Insurance • Financial Services
Analyze data to drive performance improvements in digital initiatives, define KPIs, present reports, and collaborate with teams for optimization.
Top Skills: Adobe AnalyticsGoogle AnalyticsGoogle Tag ManagerPower BIPythonSQL
6 Days Ago
Montréal, QC, CAN
Senior level
Senior level
Gaming • Metaverse
As a Data Analyst at Epic Games, you will create automated ETL pipelines and reports, collaborating with finance, HR, and product teams to inform business strategies and enhance data quality.
Top Skills: AirflowAWSDatabricksPower BIPythonSnowflakeSQLTableau
8 Days Ago
Saint-Laurent, Montréal, QC, CAN
Mid level
Mid level
Aerospace
The Supplier Management Data Analyst manages supplier data relationships, ensuring data integrity, overseeing onboarding processes, resolving issues, and enhancing compliance and reporting.
Top Skills: AribaOracle 11IOracle CloudOracle R12

What you need to know about the Montreal Tech Scene

With roots dating back to 1642, Montreal is often recognized for its French-inspired architecture and cobblestone streets lined with traditional shops and cafés. But what truly sets the city apart is how it blends its rich tradition with a modern edge, reflected in its evolving skyline and fast-growing tech industry. According to economic promotion agency Montréal International, the city ranks among the top in North America to invest in artificial intelligence, making it le spot idéal for job seekers who want the best of both worlds.

Key Facts About Montreal Tech

  • Number of Tech Workers: 255,000+ (2024, Tourisme Montréal)
  • Major Tech Employers: SAP, Google, Microsoft, Cisco
  • Key Industries: Artificial intelligence, machine learning, cybersecurity, cloud computing, web development
  • Funding Landscape: $1.47 billion in venture capital funding in 2024 (BetaKit)
  • Notable Investors: CIBC Innovation Banking, BDC Capital, Investissement Québec, Fonds de solidarité FTQ
  • Research Centers and Universities: McGill University, Université de Montréal, Concordia University, Mila Quebec, ÉTS Montréal

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account