{bc}
indeed

Data Analyst

Sports Experts
Laval, CAN
Full-time
Onsite
Discovered 6 days ago
SQLExcel advanced formulas and macrosPower BIMicrosoft AzureETLData analytics

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.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at Sports Experts