BI and Data Analyst

Mission Are you passionate about data, analysis, and designing structured BI solutions, and do you want to grow in an environment where data serves as a strategic driver for operations and decision-making? As a BI Analyst, you'll play a key role in leveraging the company's data. You'll be responsible for both producing analytical solutions (Power BI) and structuring and gaining a deep understanding of the data. Beyond creating reports, you'll actively contribute to the evolution of our data environment, particularly by participating in data structuring initiatives and becoming a key expert on our ERP database.

In this role, you'll have the opportunity to:

Develop, maintain, and optimize Power BI reports
Design new dashboards with the teams
Ensure the performance, quality, and consistency of models
Write and optimize complex SQL queries
Create and maintain data views and structures
Develop a comprehensive understanding of the ERP database (data expert)
Contribute to data development in line with the group's priorities, while gradually improving data quality and structure
Handle data requests related to the ERP
Document models, queries, and the solution
Gather and translate business requirements to deliver concrete analytical solutions

Together, let's make innovation shine! Join our team!
Profile With the following skills and qualities, you'll thrive in this role:

DEC, BAC, or equivalent training in computer science, business intelligence, or a related field
At least 2 years of experience in BI/data
Advanced SQL (complex queries, optimization)
Advanced Power BI (modeling, DAX, M, performance)
Strong understanding of transactional databases (ERP)
Ability to understand business needs and translate them into data solutions
Ability to work independently and in a structured manner
Attention to detail in documentation and data quality
Analytical mindset and problem-solving orientation
Communication skills and a collaborative spirit
French required (spoken and written)
Functional English (documentation, tools, technical discussions)

And these assets will enhance your impact:

Experience with an ERP system and its databases
Experience setting up a data lake or structured data environment
Knowledge of ETL/ELT tools or data pipelines
Experience with dimensional modeling (star schemas)
Experience in a manufacturing environment
Knowledge of Azure, Fabric, or other data platforms
Experience in business analysis or managing small projects

Benefits designed to take you far!

A flexible work program tailored to your needs (flexible hours, compressed workweek, hybrid remote work, and more)
Group insurance plans that adapt to your situation
An RRSP with employer contributions to help you build a solid financial future
An Employee and Family Assistance Program (EFAP) and access to a telemedicine service for a helping hand when you need it
A $2,000 referral bonus to help you find colleagues who are as dedicated to their work as you are!

And there's even more!

Social activities to connect with your coworkers
Support for your professional development to help you advance in your career
A healthy and safe work environment and a health committee to ensure your daily well-being
Discounts on our Kimpex products to fuel your passion for motorsports