Data Analyst

Zero Trace Procurement; City Of London; Hybrid; GBP 30,000 - 45,000; Full time

Job summary

A growing energy consultancy in the UK seeks a Data Analyst to analyze large datasets and provide actionable insights to aid clients on their Net Zero journey. Candidates should have proven experience in data analysis, preferably in the energy sector, along with strong skills in Excel and analytical tools like Power BI or Tableau. This role offers a competitive compensation package and flexible working options.

Benefits

Competitive compensation package

Remote/Hybrid working

25 days annual leave

Career development opportunities

Pension

Family Friendly Policies

Vision and Flu reimbursement

We Work office membership

Wellbeing initiatives

Learning and Development opportunities

Travel expenses reimbursement

Qualifications

• Proven experience as a Data Analyst.
• Energy industry background (brokerage or consultancy experience preferred).
• Excellent attention to detail and data quality assurance.
• Strong analytical and communication skills.
• Highly organized and proactive.

Responsibilities

• Analyse and interpret complex energy data to identify trends.
• Create insightful dashboards and reports using Power BI or Tableau.
• Ensure accuracy and completeness of data through cleaning and validation.
• Collaborate with internal teams and clients for tailored analytical solutions.
• Provide data-driven recommendations for operational and sustainability goals.
• Continuously improve data processes and tools.

Skills

Analytical thinking

Communication skills

Attention to detail

Curiosity

Collaboration

Tools

Power BI

Tableau

Excel

Python

SQL

Job description

ZTP is rapidly growing and successful energy consultancy and software company, working with nationwide corporate and I&C clients. Our services are centred around our industry leading energy management and purchasing software solutions Trace and Kiveev, which are designed and built‑in house. Our consultancy offering includes energy procurement, energy management, and financial services, while our software services provide SaaS solutions to major energy users and competing consultancies. With ambitious growth plans, we are always looking for talented professionals from the energy industry to join our expanding team.

As a Data Analyst, you ll analyse large energy datasets, uncover trends, and deliver actionable insights that drive smarter energy decisions and help client on their Net Zero journey.

Key Responsibilities

• Analyse and interpret complex energy data to identify trends, inefficiencies, and opportunities.
• Create clear, insightful dashboards and reports using Power BI or Tableau.
• Ensure accuracy and completeness of data through cleaning, validation, and transformation.
• Collaborate with internal teams and clients to define requirements and deliver tailored analytical solutions.
• Provide data‑driven recommendations that support operational, financial, and sustainability goals.
• Continuously improve data processes and tools to enhance reporting and efficiency.

Experience / Knowledge

Please note: Only candidates with prior experience in the energy industry will be considered.

Essential

• Proven experience as a Data Analyst.
• Energy industry background (brokerage or consultancy experience preferred).
• Advanced Excel skills (VLOOKUPs, pivot tables, data sorting, conditional formatting).
• Excellent attention to detail, accuracy, and data quality assurance.
• Strong analytical thinking and communication skills able to turn data into meaningful insights.
• Highly organised, proactive, and comfortable working independently or in a team.

Desirable

• Power BI or Tableau experience.
• Knowledge of Python or SQL for data manipulation and automation.
• Understanding of energy data, consumption patterns, and sustainability metrics.

Key Skills / Competencies

• Curious, analytical, and solutions focused.
• Strong communicator with excellent stakeholder management.
• Collaborative and adaptable in a fast-paced environment.
• Passionate about using data to drive sustainability and performance.

Company Benefits

• Competitive compensation package
• Remote/Hybrid working and flexible working options
• 25 days annual leave
• Career development pathways and promotion opportunities
• Pension
• Family Friendly Policies
• Vision and Flu reimbursement
• We Work office membership
• Company and team meetups
• Wellbeing initiatives, recognition schemes, and paid volunteering days
• Learning and Development opportunities
• Travel expenses reimbursement

ZTP continues to grow at pace, making this an excellent opportunity to join us at an exciting stage of our development. If you are ready for a fresh challenge, we d love to hear from you apply today!