Data Analyst & BI Specialist

Data Analyst & BI Specialist

Are you looking for a challenging position that offers you the opportunity to grow and develop quickly your career?

If you have between 6 to 8 years of experience and are motivated and willing to gain experience and knowledge, this position is made for you.

You will have the opportunity to:

• Participate in end-to-end data flow topics, from business requirements gathering to the design and implementation of robust BI solutions.
• Collaborate closely with business stakeholders to understand their needs and translate them into clear functional and technical specifications.
• Collect and prepare raw data from various sources, ensuring data quality, consistency and reliability.
• Design and build insightful data visualizations, reports and interactive dashboards (mainly with Power BI / SSRS) to support operational and strategic decision-making.
• Perform data extraction and transformation, and automate recurring reports and dashboards.
• Design, implement, optimize and maintain SQL stored procedures, views and queries, with particular attention to performance and scalability.
• Build, manage and monitor ETL processes and workflows (including SSIS and other tools) for data integration, transformation and export.
• Contribute to the design and evolution of Data Warehouses and Data Lakes, including data modelling and documentation.
• Monitor and analyze data systems and pipelines, proactively identifying issues and opportunities for improvement.
• Participate in the continuous improvement of BI architecture, standards and best practices (governance, documentation, testing, version control).

Your profile:

• Bachelor’s degree in Business Intelligence, Data/Business Analytics, Mathematics, Computer Science or a related field (a Master’s degree is an asset).
• 6–8 years of proven experience in a Data Analyst, Data Engineer or similar role.
• Solid experience with BI and reporting tools, especially Power BI (row-level security, Power Query, DAX) and SSRS (experience with paginated reports).
• Strong expertise in T-SQL (complex queries, stored procedures, performance tuning, indexing, optimization).
• Hands-on experience in data modelling (star schema, snowflake, dimensional modelling) and data analysis.
• Good knowledge of concepts such as Data Warehousing, Data Lakes, ETL/ELT, and strong experience with traditional RDBMS, particularly Microsoft SQL Server.
• Practical experience with SSIS for building and maintaining ETL workflows.
• Experience with Databricks (or similar cloud-based data platforms) is considered a strong asset.
• Exposure to Azure (e.g. Azure Data Factory, Synapse, SQL Database, Data Lake) or other cloud environments is an advantage.
• Strong analytical mindset and problem-solving skills, with the ability to quickly understand complex datasets and business contexts.
• Structured, methodical and rigorous approach to work; able to manage multiple tasks, priorities and deadlines.
• Autonomous yet collaborative, with a strong team spirit and willingness to share knowledge.
• Proactive, dynamic and results-oriented, with a focus on delivering high-quality outputs.
• Excellent communication skills, able to explain technical topics in a clear and accessible way to non-technical stakeholders.
• Ability to work fluently in both English and French on a daily basis

Experience: 6+ years