Data Analyst

FGL Sports Ltd.; Laval; On-site; CAD 65,000 - 90,000; Full time

Benefits offered by this job

Comprehensive benefits and retirement

Continuing Education Programs

Other perks to support well-being

Career growth opportunities and staff/

Job summary

FGL Sports Ltd. in Laval is seeking a Data Analyst to support Data Architecture and develop reporting across enterprise sources. You will design, implement, and manage reporting structures, extract data, validate with business units, and deliver ad hoc analyses and projects.

You will build SQL queries, models and reports with Excel and Power BI, present data from multiple sources, and collaborate on data solution design and governance in a fast-paced environment.

Qualifications

• Bachelor's degree in quantitative fields (math, stats, CS, econ)
• 3+ years of data analytics experience
• Strong Excel skills with advanced formulas/macros
• Strong SQL, ETL, Power BI and Azure knowledge
• Experience with Dynamics 365 (asset) and data modeling standards

Responsibilities

• Support optimization and creation of SQL queries for business requests
• Design, build, deliver and manage models and reports using Excel and Power BI
• Present data from multiple enterprise database sources
• Participate in data architecture and data solution design of systems
• Collaborate on connections and extractions with databases (Dynamics 365, Azure)

Skills

SQL

Power BI

Excel

Data analytics

Data architecture

Azure

Dynamics 365

ETL

Education

Bachelor's degree in quantitative discipline

Tools

Dynamics 365

Azure

Job description

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 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

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 #LI-MM2

This posting represents an existing vacancy within our organization.

We 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.

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. We are one of Canada’s most admired and trusted companies. With world-class owned brands and exciting market-leading merchandising strategies, we are continually innovating with purpose: to excite and serve Canadian customers from coast-to-coast. We are connected to communities, big and small, from coast-to-coast, offering products and services that reflect the diverse nature of every one of them. From sports to outdoors, automobiles to homes, we know and understand life in Canada like no other retailer.

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.

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.

If you’re ready to take on new challenges – be it in digital, IT, marketing, data & analytics, merchandising, or one of the many other roles we have – there is a place for you here,