Data Analytics Consultant - Energy | Expression of Interest

Stantec Consulting Services, Inc.; United Kingdom; Hybrid; GBP 40,000 - 65,000; Full time

Benefits offered by this job

Hybrid / Flexible working

Great Benefits

Professional subscriptions

Job summary

Stantec seeks a Data Analyst to sit at the heart of its digital delivery capability, turning complex datasets into meaningful insights that support smarter decisions across energy projects.

You'll collect, structure and analyse data from diverse sources, building dashboards, reports and analytical solutions while improving data quality and governance and enabling automated reporting processes. This role operates in a collaborative, forward-looking environment.

Qualifications

• Experience in data analytics, business intelligence or a similar data-focused role.
• Knowledge of Power Query, SQL and data modelling principles.
• Experience developing dashboards, KPIs and reporting solutions.
• Strong communication and stakeholder engagement skills.

Responsibilities

• Turn complex data into clear, actionable insights that help teams make informed decisions.
• Develop engaging dashboards, reports and visualisations that bring data to life.
• Help improve the quality, consistency and accessibility of data across projects and business functions.
• Support performance monitoring through KPI reporting and analytics.
• Identify trends, opportunities and areas for improvement that drive greater efficiency and value.
• Streamline processes through automation and smarter data workflows.
• Partner with stakeholders to understand challenges and deliver practical, data-driven solutions.
• Contribute to a culture where data is trusted, understood and used to support better outcomes.

Skills

Power BI

Excel

Data visualisation

Power Query

SQL

Data modelling

Dashboards

KPIs

Automation

Stakeholder comms

Tools

Power BI

SQL

Job description

Data has the power to transform the way we design, deliver and operate critical infrastructure. At Stantec, we're bringing together talented analysts, engineers and digital specialists to help solve some of the world's most complex energy challenges, and we're looking to connect with experienced Data Analysts who want to be part of that journey.

As our Energy & Resources business continues to grow, we're building a network of data professionals who are passionate about turning information into insight and helping project teams make smarter, evidence-based decisions. You'll have the opportunity to work across a diverse portfolio spanning Hydropower, Transmission & Distribution, Nuclear, Waste & Generation, and Minerals & Resources, supporting projects that are shaping a more sustainable future.

About the Role

As a Data Analyst, you'll sit at the heart of our digital delivery capability, helping transform complex datasets into meaningful insights that drive better business and project outcomes.

Working alongside technical specialists, project teams and business leaders, you'll collect, structure and analyse data from a variety of sources, developing dashboards, reports and analytical solutions that provide clarity and support decision-making. You'll be involved in everything from improving data quality and governance to building automated reporting processes and identifying trends that help projects perform more effectively.

This is an opportunity to influence how data is used across a growing business, whilst working with modern analytics tools and technologies in a collaborative and forward-thinking environment.

Your Impact

In this role, you'll:

• Turn complex data into clear, actionable insights that help teams make informed decisions.
• Develop engaging dashboards, reports and visualisations that bring data to life.
• Help improve the quality, consistency and accessibility of data across projects and business functions.
• Support performance monitoring through KPI reporting and analytics.
• Identify trends, opportunities and areas for improvement that drive greater efficiency and value.
• Streamline processes through automation and smarter data workflows.
• Partner with stakeholders to understand challenges and deliver practical, data-driven solutions.
• Contribute to a culture where data is trusted, understood and used to support better outcomes.

About You

We're keen to hear from people who are naturally curious, enjoy solving problems and are passionate about using data to make a real impact.

You'll likely bring:

• Experience in data analytics, business intelligence or a similar data-focused role.
• Strong skills in Power BI, Excel and data visualisation.
• Experience with data preparation, cleansing and transformation.
• Knowledge of Power Query, SQL and data modelling principles.
• Experience developing dashboards, KPIs and reporting solutions.
• An understanding of data governance and data quality best practice.
• Experience improving processes through automation and analytics.
• Strong communication and stakeholder engagement skills, with the ability to explain technical concepts to a wide range of audiences.
• A collaborative mindset and enthusiasm for continuous improvement.

WHY JOIN US

We put people first: We're proud of our friendly, inclusive and collaborative environment where everyone feels valued and driven to succeed.

We are driven to achieve: Named in the top 50 companies to work by Glassdoor 2025. Recognised by Corporate Knights as one of the world's top 10 most sustainable companies 2025. Named ‘Best Place to Work’ and ‘International Consulting Firm of the Year’ at the NCE Awards 2024.

We do what is right: Industry leading training and development as well as paid for professional subscriptions. A professional progression plan, supporting you to become chartered with ICE.

We are better together: A supportive and collaborative team environment and Early Careers peer group and wider ERG network (see more on our ERGs here: Stantec Employee Resource Groups).

Growth: We're on an exciting growth journey across the UK - we want you to be part of it!

Great Benefits: Competitive salary, bonus schemes, enhanced pension plan, annual leave with the option to buy/sell additional days, private medical insurance, group income protection & life assurance included as standard as well as discounted gym membership and lots more.

Hybrid / Flexible working: Enjoy a healthy work-life balance with our hybrid approach to flexible working