Data Analyst
Role Overview
Supports Data Architecture by developing query requirements across enterprise databases.
Designs, implements, and manages reporting systems; performs data extraction and validation for ad hoc analysis and projects.
Key Skills for This Role
Full Job Posting
Role overview
Supports Data Architecture by developing query requirements across enterprise databases.
Designs, implements, and manages reporting systems; performs data extraction and validation for ad hoc analysis and projects.
Responsibilities
- Optimize and create SQL queries for business requests; build and manage Excel and Power BI models and reports.
- Present data from enterprise sources and participate in data architecture and solution design.
- Develop database connections and extractions, including Dynamics 365, Azure, and I Hub ingestion; validate system integrations.
- Analyze change-request impacts and collaborate on specifications for new software and applications.
- Understand and document processes, recommend automation, and gather requirements in workshops.
- Recommend reporting and BI solutions; translate processes into functional requirements for developers and project teams.
- Use data-product and visualization knowledge to advise stakeholders; prioritize work and maintain forward-looking roadmaps.
- Collaborate with BI analysts and IT on requirements, maintenance, and data-product evolution.
Requirements
- Bachelor's degree in a quantitative discipline such as mathematics, statistics, computer science, or economics.
- At least 3 years of data analytics experience and a good understanding of data architecture.
- Working knowledge of AI and data warehouse concepts and terminology.
- Excellent Excel skills, especially advanced formulas and macros; strong SQL, ETL, Power BI, and Microsoft Azure knowledge.
- Microsoft Dynamics 365 experience is an asset.
- Experience with analysis, modeling, verification, and business and technical requirements methodologies.
- Ability to communicate data modeling standards, policies, guidelines, and governance structures, and prioritize projects.
- Able to work independently; excellent oral and written French and English communication skills.
- Thorough and quality-focused, with interest in innovative technologies.
Skills and tools
- SQL, Excel, Power BI, Microsoft Azure, and ETL.
- Data analytics, data architecture, data modeling, and data warehousing.
- Microsoft Dynamics 365 experience is an asset; AI concepts and terminology are within the requested working knowledge.
Benefits
- Benefits and retirement programs, continuing education, well-being perks, career growth opportunities, and product discounts.
About the employer
Sports Experts is part of the Canadian Tire family and is headquartered in Laval, Quebec.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Sports Experts
Conseiller(ère) à la vente | Temps plein
Salaberry-de-Valleyfield, CAN
Conseiller(ère) à la vente Équipement | Temps plein
Québec, CAN
Conseiller(ère) à la vente Vêtement | Temps plein
Beloeil, CAN
Conseiller(ère) à la vente | Temps plein
Salaberry-de-Valleyfield, CAN
Gérant(e) | Temps plein
Mirabel, CAN
Conseiller(ère) à la vente Équipement | Temps plein
Québec, CAN
Technicien(ne) d'atelier | Temps plein
Amos, CAN
Conseiller(ère) à la vente Vêtement | Temps plein
Beloeil, CAN
Technicien(ne) d'atelier | Temps partiel
, CAN
Technicien(ne) d'atelier | Temps plein
, CAN
Commis expédition/réception | Temps plein
Beloeil, CAN