Data Analyst

Canadian Tire Financial Services; Laval; On-site; CAD 65,000 - 92,000; Full time

Benefits offered by this job

Benefits & retirement

Education programs

Well-being perks

Product discounts

Job summary

Canadian Tire Financial Services in Laval, QC is seeking a Data Analyst to support data architecture and reporting development. You will design and manage reporting structures, extract data, and validate ad hoc requests across enterprise sources.

You will design SQL queries, build models and reports in Excel and Power BI, and collaborate with Dynamics 365, Azure and IT teams to deliver data solutions. Fluent English and French preferred.

Qualifications

• Bachelor’s degree in quantitative discipline with strong analytic focus.
• 3+ years of data analytics experience and understanding of data architecture.
• Excellent Excel skills with advanced formulas and macros; strong SQL and Power BI knowledge.

Responsibilities

• Support data requests by optimizing and creating SQL queries.
• Design, build, and deliver models and reports using Excel and Power BI.
• Present data from multiple enterprise database sources to stakeholders.
• Collaborate on data architecture and data solution design across systems (Dynamics 365, Azure, IT).
• Assist in workshops to gather requirements for BI solutions and document functional requirements.

Skills

SQL

Excel

Power BI

Azure

Dynamics 365

Data modeling

ETL

Data analysis

Communication

Education

Bachelor’s degree in quantitative discipline

Tools

Azure Data Factory

Excel macros

Job description

## Data AnalystApply: Laval, QC: Full time: Posted Today: JR166738Joining 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. You will design, implement and manage the structure of reporting systems. The Data Analyst will be responsible for data extraction initiatives from our various systems, validation with business departments for ad hoc analysis requests and project developments.**What You’ll Do*** 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.* 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 (Dynamics 365, Azure, I Hub ingestion).* 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*** Bachelor's degree in quantitative discipline (mathematics, statistics, computer science, economics)* 3+ years of experience in data analytics and good understanding of data architecture.* 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 365 (asset)* 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**We’re always looking for great talent! In addition to competitive pay, we offer:*** Comprehensive benefits and retirement programs* Continuing Education Programs* Other perks to support your well-being* Career growth opportunities and product discounts