Overview

The Business Intelligence (BI) & Analytics Lead is a key position within the Project Integration Management Systems (PIMS) team and is responsible for developing, delivering, and maintaining the data and reports strategy, approach, and toolsets for the Engineering Services / Major Projects sector within AtkinsRéalis. This role partners closely with key project stakeholders, senior leadership, and IT teams to design and implement data models and dashboards containing business intelligence and key performance indicators (KPIs) that support effective and informed management decision‑making. The Lead also ensures the standardization of ETL processes, and the development and ongoing maintenance of a data warehouse that supports both operational and historical reporting.

Your role

- Understand the customer landscape and identify common analytical needs across the organisation.
- Work closely with senior stakeholders across AtkinsRéalis to translate business needs into a robust, transparent analytics platform and solution roadmap.
- Research emerging technologies and lead innovation across the analytics platform.
- Collect and document business and technical requirements, translating customer needs into scalable BI solutions.
- Communicate effectively with partners, vendors, and technology teams to track, resolve issues, and improve service levels.
- Take a lead role in solution and architecture design discussions, challenging technology assumptions where appropriate.
- Develop, support, and maintain business metrics and KPIs using Power BI, SQL, Power Automate, and Power Apps.
- Design and build analytics solutions using the corporate BI & Analytics technology stack.
- Apply working knowledge of Python for data analysis, automation, or advanced analytics use cases.
- Coordinate and follow up on system migrations and Azure cloud services.




- Design rapid prototypes or models using Excel or visualization tools to facilitate discussions with stakeholders and clearly capture functional requirements.
- Identify, analyse, and interpret trends or patterns in complex datasets from multiple platforms and data formats.

About You

- Bachelor’s degree in Computer Science, Engineering, Technology, or equivalent professional experience.
- 7+ years of experience designing, developing, analysing, and maintaining data warehousing and BI reporting solutions.
- Experience leading a team or coordinating technical and analytical resources.
- Experience with cloud platforms, preferably Microsoft Azure.
- Strong expertise in reporting tools and databases (e.g., SQL), including query writing, ETL development, data modelling, charting, and report development.
- Strong analytical skills with the ability to gather, structure, and analyse business requirements.
- In-depth technical understanding of relational database technologies.
- Excellent communication skills and the ability to understand business needs, issues, and operating environments.
- Strong business acumen; experience in Engineering & Construction industry is an asset.
- Strong technical background (Power BI, SQL, Azure, Python, Excel, Visio).
- Analytical, pragmatic, and solution‑oriented approach.
- Ability to thrive in a dynamic and changing environment.
- Bilingual French/English.
- Experience with JD Edwards or other ERP systems is considered an asset.

Rewards & benefits

Enjoy competitive compensation, employee recognition, and a comprehensive range of flexible benefits that can be tailored to your health, wellbeing, financial and lifestyle needs. Opportunities for training and career development are available, as well as a hybrid working culture and generous time‑off policies to help balance career and personal life.

Additional information

By submitting your personal information to AtkinsRéalis, you confirm that you have read and accept our Privacy Notice.

📌 BI & Analytics Lead (Montreal)
🏢 AtkinsRéalis
📍 Montreal