Let’s find your next opportunity​

{{ job.job_posting_title }}
{{item.trim() }} {{item.trim() }} {{item.trim() }}
{{ job.job_posting_title }}

{{ job.is_cms_job ? (job.cities.split(';').length > 1 ? 'Various locations' : job.location_mappings[0]) : (job.location_mappings.length > 1 ? 'Various locations' : job.location_mappings[0]) }}

saved
viewed

Montréal, Quebec, Canada

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. The BI & nalytics Lead is accountable for the design, development, and implementation of data models and dashboards containing business intelligence and key performance indicators (KPIs) that support effective and informed management decision-making.

The role also ensures the standardization of data extract, transfer, and load (ETL) processes, as well as the development and ongoing maintenance of a data warehouse supporting 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.

Transportation Digital

Location

Montréal, Quebec, Canada

Job Type

Full time

Ref

R-154095

Salary range

-

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.

  • JD Edwards or ERP system experience is considered an asset.

  • Experience leading a team or coordinating technical and analytical resources.

  • Experience with cloud platforms, preferably Microsoft Azure.

  • You will have demonstrable experience working with clients and stakeholders to understand business requirements and deliver effective analytics solutions that address key challenges. You possess excellent communication skills and the ability to understand business needs, issues, and operating environments.

  • 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.

  • You are capable of building strong working relationships with stakeholders from diverse backgrounds and obtaining confidence and buy-in for proposed solutions. You thrive in collaborative environments, contribute effectively as part of a team, and demonstrate the ability to innovate while delivering solutions within complex technical and business constraints.

  • Bilingual French/English.*

  • Strong business acumen (Engineering & Construction industry experience 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.

  • Excellent communication skills and active listening.

  • Customer-focused mindset.

**This position requires knowledge of another language besides French, namely English, as the work produced is intended for audiences located elsewhere in Canada, internationally, or in another region of the world.

Why choose AtkinsRéalis?

Why choose AtkinsRéalis?

Wherever you are in your career – and whoever you are – AtkinsRéalis is for you. Here, support and collaboration are a vibrant part of a culture that lets you choose where – and how far – your career can go. Take on projects that push boundaries and drive sustainable impact, surrounded by colleagues who believe there's no limit to how brilliant you can be. It's time to join a like-minded team where you'll be rewarded, supported, and free to be your kind of brilliant.

Rewards & benefits

Explore the rewards and benefits that help you thrive – at every stage of your life and your career at AtkinsRéalis in Canada.

Enjoy competitive compensation, employee recognition, and a brilliant range of flexible benefits you can tailor to your health, wellbeing, financial and lifestyle needs.

Make the most of diverse opportunities for training and professional development to grow your skills and expertise.

And take advantage of our hybrid working culture and generous time-off policies to balance a fulfilling career with your personal life.

Be rewarded. Find out more.

video thumbnail

Make it brilliant, a career with AtkinsRéalis

Our supportive, collaborative culture inspires us as a global community every day.

Watch this short film and imagine what you could achieve here, too.

About AtkinsRéalis

About AtkinsRéalis

We're AtkinsRéalis, a world-class engineering services and nuclear organization. We connect people, data and technology to transform the world's'infrastructure and energy systems. Together, with our industry partners and clients, and our global team of consultants, designers, engineers and project managers, we can change the world. We're committed to leading our clients across our various end markets to engineer a better future for our planet and its people.

Find out more.

Aperçu

Vous souhaitez façonner l'avenir des données au cœur de grands projets d'ingénierie ? En tant que responsable en intelligence d'affaires (BI) et analytique, vous jouerez un rôle stratégique au sein de l'équipe Project Integration Management Systems (PIMS). Vous contribuerez directement à la performance du secteur Services d'ingénierie / Grands projets d'AtkinsRéalis en transformant des données complexes en informations décisionnelles à forte valeur ajoutée.

Additional information

AtkinsRéalis cares about your privacy. AtkinsRéalis and other subsidiary or affiliated companies of AtkinsRéalis (referred to throughout as "AtkinsRéalis") are committed to protecting your privacy. Please consult our Privacy Notice on our Careers site to know more about how we collect, use, and transfer your Personal Data.

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

Related jobs

Specialist Engineer – Fuel Channels
Nuclear Engineering Full time
Specialist Engineer – Fuel Channels

Mississauga, Ontario, Canada

Intermediate Structural Engineer (Bridges)
Transportation Engineering Full time
Intermediate Structural Engineer (Bridges)

Toronto, Ontario, Canada

Specialist Engineer - Reactor Structures
Nuclear Engineering Full time
Specialist Engineer - Reactor Structures

Mississauga, Ontario, Canada

Principal Building Services Technician
Operations, Maintenance & Building Services Full time
Principal Building Services Technician

Exeter, Devon, England, United Kingdom

Civil/ Structural Engineer
Nuclear Engineering Full time
Civil/ Structural Engineer

Mississauga, Ontario, Canada

Senior / Principal Mechanical Engineer
Engineering Full time
Senior / Principal Mechanical Engineer

Exeter, Devon, England, United Kingdom

Senior Structural Engineer
Engineering Full time
Senior Structural Engineer

Birmingham, England, United Kingdom

Structural Engineer
Engineering Full time
Structural Engineer

Birmingham, England, United Kingdom

Senior Civil Engineer
Nuclear Engineering Full time
Senior Civil Engineer

Mississauga, Ontario, Canada

Directeur(trice) adjoint(e), infrastructures municipales
Cities & development Design & Drafting Full time
Directeur(trice) adjoint(e), infrastructures municipales

Québec, Quebec, Canada

Ingénieur(e) en infrastructures municipales et traitement de l'eau
Cities & development Engineering Full time
Ingénieur(e) en infrastructures municipales et traitement de l'eau

Québec, Quebec, Canada

Technicien(ne) en surveillance de chantier
Transportation Engineering Full time
Technicien(ne) en surveillance de chantier

Montréal, Quebec, Canada

Related blogs

Aishwarya smiling in front of camera

From Pune to UK rivers: what Aishwarya’s intern work in water quality looks like.

At AtkinsRéalis, meaningful environmental impact can begin early in your career. As an intern in the Water Management Consultancy team, Aishwarya is helping assess water quality and pollution risks in UK rivers, applying her academic knowledge to real-world challenges that support healthier ecosystems and better environmental outcomes.

Card link for From Pune to UK rivers: what Aishwarya’s intern work in water quality looks like.
Mohit standing in front of lake

Building energy resilience where it matters most

Whether it's supporting global net-zero commitments or helping improve energy resilience in remote communities, Mohit’s work reflects the growing role sustainability professionals play in shaping a more sustainable future.

Card link for Building energy resilience where it matters most
Sahil in black suit

Designing cooler cities for a hotter world

Meet Sahil, driving resilient cities at AtkinsRéalis by turning climate challenges into solutions through urban planning, climate adaptation, and digital innovation.

Card link for Designing cooler cities for a hotter world

From data to impact: Varna’s journey shaping global sustainability reporting from India

At AtkinsRéalis, sustainability is driven by both strategy and data. Varna’s work focuses on turning complex environmental information into meaningful insights, supporting global sustainability reporting, climate action, and informed decision-making across regions.

Card link for From data to impact: Varna’s journey shaping global sustainability reporting from India

Why Pankaj came back to AtkinsRéalis to grow his sustainability career

From graduate engineer to Principal Sustainability Consultant, explore Pankaj’s journey and his work shaping sustainable building performance across the Middle East.

Card link for Why Pankaj came back to AtkinsRéalis to grow his sustainability career
road stretching off into the distance

A first for Ireland: building carbon reduction into the tender

How a career with AtkinsRéalis Ireland means building carbon reduction in from the beginning.

Card link for A first for Ireland: building carbon reduction into the tender

Tomasz on building a squiggly career in International Urban Development Advisory

Meet Tomasz and discover how embracing new opportunities can shape a truly global career path.

Card link for Tomasz on building a squiggly career in International Urban Development Advisory
Tom Johnson House, Dublin, Ireland - brick building against a bright blue sky

From C3 to A2: a deep retrofit in Dublin 4

How AtkinsRéalis’ structural engineering capability in Ireland drives sustainable and visible value – what could you add?

Card link for From C3 to A2: a deep retrofit in Dublin 4
Kristi smiling at the camera

Sustainability isn’t a job title. It’s a way of practising.

From early lessons in solar living, discover how Kristi is redefining sustainability in design and preparing for LEED v5.

Card link for Sustainability isn’t a job title. It’s a way of practising.
Image of Amy at the big bang fair

From music technology to acoustic consulting: Amy on building a career in environment digital

Discover how Amy is turning technical knowledge into real-world impact through acoustics and digital solutions.

Card link for From music technology to acoustic consulting: Amy on building a career in environment digital
Image of Tony smiling at the camera

25 years in flood risk: Tony on building a career at the intersection of science and infrastructure

Discover Tony’s journey from graduate to Associate Director, read how he’s built a career protecting communities from flood risk.

Card link for 25 years in flood risk: Tony on building a career at the intersection of science and infrastructure

A decade of curiosity, connection, and finding my voice: Growing through people, passion, and possibility.

Ten years is more than a milestone, it’s a reflection of the people, experiences, and moments that shaped the journey. What began in Talent Acquisition evolved into something richer, driven by curiosity, creativity, and meaningful connections.

Card link for A decade of curiosity, connection, and finding my voice: Growing through people, passion, and possibility.