Data Insight and Optimisation Analyst

Job Description

Join us, be part of more.

We’re so much more than an energy company. We’re a family of brands revolutionising how we power the planet. We're energisers. One team of 21,000 colleagues that's energising a greener, fairer future by creating an energy system that doesn’t rely on fossil fuels whilst living our powerful commitment to igniting positive change in our communities. Here, you can find more purpose, more passion, and more potential. That’s why working here is #MoreThanACareer. We do energy differently - we do it all. We make it, store it, move it, sell it, and mend it.

About your team:

At British Gas, our mission is to sell it and mend it.

We’re the household heroes powering 1 in 3 homes in the UK – but supplying energy is just part of what we do. We’re making the UK’s homes greener and more energy efficient, together with our friends at Hive. By using their clever tech like thermostats, heat pumps, solar panels and EV chargers, we’re making it cheaper and easier to reduce your home’s carbon-footprint. And with our Peak Save programme, we’re actively rewarding better energy use too.

About your role:

The Data Insight and Optimisation Analyst works with key stakeholders to understand problems and create data-driven solutions using a range of data analysis and visualisation tools. This role involves building data pipelines, analysing data, and creating reports to help make decisions and improve performance. The analyst ensures data accuracy and compliance with regulations and collaborates with teams to maintain data quality. By improving efficiency and customer satisfaction, the Data Insight and Optimisation Analyst supports the organisation’s goals.

• Data Pipeline Management & Integration: Design, develop, and maintain data pipelines using SQL and Azure Databricks, ensuring seamless data flow and accurate insights.
• Stakeholder Collaboration & Reporting: Work with stakeholders to create insightful Power BI reports and dashboards, uncover trends, and support strategic initiatives for improved performance.
• Query Optimisation & Advanced Analytics: Develop and optimise queries using SQL and Hive QL, and perform advanced analytics with R and Python to support customer-centric initiatives.
• Automation & Data Solutions: Implement automated data solutions with Power Automate, streamline ETL processes, and ensure data accuracy and compliance with regulations.
• Performance Analysis & Customer Insights: Conduct deep dives into operational performance, analyse customer experience, and provide actionable insights to drive improvements and enhance customer service.

Here's what we’re looking for:

• Data Analysis & Reporting: Expertise in Power BI, SQL Server Management Studio, and advanced Excel for data analysis, reporting, and dashboard creation.
• Data Integration & Transformation: Proficient in Azure Databricks, ETL processes, and Hive QL for managing and transforming large datasets.
• Programming & Analytics: Advanced skills in R and Python for statistical analysis, predictive modeling, and data visualisation.
• Automation & Process Improvement: Experience with Power Platform applications (Power Apps, Power Automate) and identifying automation opportunities for process optimisation.
• Project Management & Stakeholder Engagement: Knowledge of Agile/Lean methodologies and experience working with stakeholders across multiple management levels.

Why should you apply?

We’re not a perfect place – but we’re a people place. Our priority is supporting all of the different realities our people face. Life is about so much more than work. We get it. That’s why we’ve designed our total rewards to give you the flexibility to choose what you need, when you need it, making sure that you and your family are supported not only financially, but physically and emotionally too. Visit the link below to discover why we’re a great place to work and what being part of more means for you.

https://www.morethanacareer.energy/britishgas

If you're full of energy, fired up about sustainability, and ready to craft not only a better tomorrow, but a better you, then come and find your purpose in a team where your voice matters, your growth is non-negotiable, and your ambitions are our priority.

Help us, help you. We would love for you to share any information about yourself throughout our recruitment process so that we can better understand you and help shape your journey.