Energy Data Analyst

Company Description

Hi! We're UW. We’re on a mission to take the headache out of utilities by providing them all in one place. One bill for energy, broadband, mobile and insurance and a whole lot of savings!

We’re aiming to double in size as we help more people to stop wasting time and money. Big ambitions, to be delivered by people like you. 

Got your attention? Read on…

We put people first. It’s all about you..

• Background in Energy domain
• Experienced in building and delivering regulatory reports that require attention to detail
• Experienced in building and managing data tables of high data quality
• You have a wealth of experience in business insights and data analytics (exploratory and descriptive analysis).
• You are routinely hands-on with Advanced SQL (analytical functions, window functions, pivots) and data visualisation tools. 
• You’re adept at creating and shaping datasets (as opposed to making use of prepared data). Experience with data modelling tools such as Dataform or dbt would be highly advantageous.
• You’re used to managing time to produce high-quality work to tight deadlines.
• Experience with BQ / GCP / Looker / Terraform will be beneficial.
• You’re used to working within a diverse team spanning business leaders, product managers, software engineers and data scientists.
• Excellent communication skills (particularly in written content production);
• Strong organisational skills with the ability to manage own time and prioritise tasks;
• Problem-solving skills: Positive approach to identifying and resolving data issues 
• Strong attention to detail, excellent numeracy understanding with strong emphasis on financials

This is a hybrid role working from one of our London hubs 2 days per week.

We work together. Your team and the people you will work with…

Energy is at the heart of our customer proposition at Utility Warehouse and we aim to deliver an excellent service to each and every one of our members. To help us achieve this, our operations team supports and problem-solving solutions for our customers, ensuring they have accurate monthly bills and the efficiency of our back office processes.

The role will actively engage the energy business to provide data analyst services.

We deliver progress. What you’ll do and how you will make an impact.

• Work with large volumes of data to draw out business insights, highlight opportunities, and spot issues and risks;
• Build reporting and dashboard solutions using tools such as Data Studio, Google Sheets, Looker and QlikSense; 

What you’ll do

• Engage energy industry teams to understand their data requirements;
• Ensure accurate and timely collection of data 
• Maintain and manage large datasets, ensuring integrity and security
• Identify data sources; analyse the data; and build a solution using the various tools we have access to (e.g. google sheets, data studio)
• Working collaboratively with the rest of the business for testing the reports/ dashboards built;
• Provide insight and commentary on the data trends;
• Track changes to our gas and electricity portfolio using a variety of factors including; a mix of payment methods, consumption levels, customer demographics and any other relevant factors;
• Analyse consumer patterns 
• Use tools and data visualisation techniques to present insights
• Respond to regulators (Ofgem, Citizens advice, etc) requests for information;
• Adhere to the regulatory data requests – enacting a review and sign-off process;
• Building a deep knowledge of energy data, systems, and tools for efficient solution design
• Represent Energy’s data requirements to the Data and Insights team in Technology 
• Build cohesive data strategies
• Communicate complex data findings to non-technical stakeholders clearly and concisely.
• Propose and implement improvements to data collection, analysis and reporting processes
• Identify opportunities for automation and efficiency gains 

So why pick UW?

We’ve got big ambitions so there’s going to be plenty of challenges. There are also a lot of benefits: 

• An industry benchmarked salary. We’ll share it during your first conversation.
• Share Options and a Save as You Earn scheme.
• Hybrid working, with 2 days in the office. (We’re definitely open to discussing flexible working arrangements)
• Discount on our services and you get our coveted Cashback Card for free. 
• A matched contribution pension scheme and life assurance up to 4x your salary.
• Family-friendly policies, designed to help you and your family thrive.
• Discounted private health insurance, access to an Employee Assistance line and a free Virtual GP.
• Belonging groups that help UW shape an even more inclusive future.
• A commitment to helping you develop and grow in your role.

Apply here!  

You’ve got this far… Hit apply - we can’t wait to hear from you! Worried you don’t hit all the criteria? We welcome applications from diverse and varied backgrounds so get your application in and let’s chat!

Jen Pass will be your point of contact throughout the recruitment process. 

Additional Information

We provide equal opportunities, a diverse and inclusive work environment, and fairness for everyone. You are welcome to apply no matter your age, disability, gender, marriage or civil partnership status, pregnancy and maternity status, race, religion or belief, or sexual orientation. If you need any help, support, or advice at any point during the hiring process please just let us know.

Please note, if you are applying for a role which involves having access to personal data, you will be subject to a background check. Where checks are unsatisfactory or incomplete and/or a failure to reveal information relating to convictions that you are required to identify as part of the background checks, could lead to withdrawal of an offer of employment.