Data Analyst

**Help us boldly shape retail in Canada**

Canadian Tire Corporation’s (CTC) rich heritage of serving Canadians from coast-to-coast dates back to 1922. Our vision is to become the #1 retail brand in Canada and we are focused on innovating and making important investments in our business, especially when it comes to our people. To reach our goal, we need the best talent to help us evolve and drive change across the business - and boldly help shape Canada’s retail industry. As we strive to be at the forefront of a complex and vastly changing retail industry, it is an exciting time to join the Canadian Tire family of companies.

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. You will 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.

**Main responsibility**
- 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 ((DataLake, Dynamics AX or Dynamics 365, Azure, I Hub ingestion).
- Support data validations during the integration of systems under different platforms
- 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.

**Your qualifications and skills**
- 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 AX or Dynamics 365 (asset) or knowledge of Thoughtspot (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

LI-MM2
- Canadian Tire and its family of companies are boldly shaping retail in Canada and we continue to deliver a positive experience for our customers. As one of the most trusted brands in Canada, our employees take pride in the work we do across the country. It’s more than the iconic triangle that keeps our employees around. From benefits and perks, to learning and development opportunities, to our commitment to Jumpstart - these are some of the many reasons why Canadian Tire Corporation is one of _Canada’s Best Managed Companies _. _
- To learn more about this team and the Canadian Tire family of companies follow us on _LinkedIn _. _