At a Glance
- Tasks: Own the data-to-insight process, transforming complex data into actionable business insights.
- Company: Join Utility Warehouse, a leader in the energy sector with a focus on innovation.
- Benefits: Enjoy a competitive salary, performance bonuses, and flexible working options.
- Other info: Embrace a culture of inclusion and growth with opportunities for professional development.
- Why this job: Make a real impact by driving decisions through data analysis in a dynamic environment.
- Qualifications: Proven SQL skills and experience in building analytics-ready data models are essential.
The predicted salary is between 40000 - 50000 £ per year.
As a Data Analyst at Utility Warehouse you will own the complete "Data-to-Insight" value chain for single projects. This role combines the technical skills to build production‑grade data pipelines with the soft skills to manage stakeholders and drive domain‑specific decisions.
Analytics Engineering (Dataform/dbt): Build and maintain end‑to‑end analytics‑ready data models in Dataform, independently handling complex logic and transformations.
CI/CD & DevOps (Data version control): Apply version control (through tools like Git & Github) and unit testing practices to analytics models, to ensure data assets are stable, reproducible, and ready for deployment.
Performance Engineering: Write optimised SQL, proactively tuning for performance (cost & runtime) and addressing alerts about data quality.
Ownership: Independently plan and execute medium‑to‑large requests through to completion; identify and proactively address tech debt.
Actionable Insight: Translate complex data into actionable business insights. Move beyond "what happened" to explain "why it happened" and recommend "what to do next."
Dashboards/Reporting: Build visual self‑serve dashboards and reports for users to access KPIs / metrics and explore/analyse pre‑built data sets.
Stakeholder Management: Manage the full request lifecycle. Actively engage with stakeholders to refine broad requests into clear requirements, providing accurate estimations and delivering within agreed timelines.
Domain Ownership: Develop deep knowledge of a specific domain (e.g., Marketing, Product, Finance). Understand the impact of key metrics on the business and participate in defining team goals based on this knowledge.
Qualifications
Technical & Data Engineering Mastery: Proven experience in writing optimised, modular SQL (Intermediate - advanced proficiency). Experience of building end‑to‑end, analytics‑ready data models in Dataform, underpinned by a strong grasp of the engineering lifecycle (including Git/GitHub version control, merge conflict resolution, and automated unit testing).
Solid expertise in building reusable LookML code within Looker and the ability to independently lead medium‑to‑large analytical projects—from selecting the right tool for the job (e.g. Looker vs Mixpanel) to providing accurate estimations and hitting delivery timelines.
Commercial Impact & Domain Knowledge: A track record of aligning analysis with business needs and translating complex datasets into actionable insights that influence stakeholder decisions. Ideally you will have experience in a regulated utility or a similar high‑volume consumer industry.
Operational Excellence & Collaboration: Experience in maintaining high data standards through observability (configuring freshness and quality alerts) and producing traceable documentation (Data Dictionaries), with a demonstrated ability to support non‑technical teams through clear data storytelling.
UW skills and competencies:
- Prioritisation
- Collaboration
- Communication
- Attention to Detail
- Project Management
Benefits
- Competitive salary: We benchmark against the industry and will share the salary openly during our first conversation.
- Performance bonus: An annual discretionary bonus ranging from 15-40%.
- Work‑life balance: We offer an optional four‑day working week (90% pay for 90% impact).
- Work from anywhere: You can work abroad for up to three weeks, twice every tax year.
- Holiday: 25 days plus bank holidays (increasing with tenure), with the option to trade up to five days each year.
- UW discounts: Save on our services and you’ll also get access to 100s of rewards and discounts through Perkbox.
- Future planning: Matched‑contribution pension scheme and life assurance (up to 4x salary).
- Family first: Policies designed to help you and your family thrive.
- Flexible benefits: An allowance for private health insurance, dental insurance, or gym membership.
- Sabbaticals: An eight‑week paid sabbatical after four years of service.
- Growth: A dedicated learning and development budget and bi‑annual promotion cycles.
- Inclusion: Join belonging groups that help shape our culture.
- Events: Company‑wide celebrations including the ‘Great Big Get Together’ and our ‘Good Hearted Go‑Getter Awards’.
Equity, Opportunity, and Background Checks
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. Please don’t be afraid to ask about what we can do to support your needs. All requests will be carefully and fairly considered. If you are successful and offered a role at UW, 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.
Data Analyst - Energy in London employer: Utility Warehouse Limited
Utility Warehouse is an exceptional employer that prioritises employee well-being and professional growth, offering a competitive salary, performance bonuses, and the flexibility of a four-day working week. With a strong focus on collaboration and inclusion, employees benefit from a dedicated learning budget, generous holiday allowances, and unique perks like the opportunity to work abroad and take paid sabbaticals. Join a vibrant culture that celebrates achievements and fosters a sense of belonging while making a meaningful impact in the energy sector.
StudySmarter Expert Advice🤫
We think this is how you could land Data Analyst - Energy in London
✨Tip Number 1
Get your networking game on! Reach out to current employees at Utility Warehouse on LinkedIn. A friendly chat can give you insider info and maybe even a referral, which can really boost your chances.
✨Tip Number 2
Prepare for the interview like it’s the final exam! Research the company’s recent projects and think about how your skills in SQL and data modelling can add value. Show them you’re not just another candidate, but the perfect fit!
✨Tip Number 3
Practice your storytelling skills! Be ready to explain complex data insights in a way that’s easy to understand. Use examples from your past work to demonstrate how you’ve turned data into actionable business decisions.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who take that extra step to connect with us directly.
We think you need these skills to ace Data Analyst - Energy in London
Some tips for your application 🫡
Tailor Your Application:Make sure to customise your CV and cover letter to highlight the skills and experiences that match the Data Analyst role. We want to see how your background aligns with our needs, so don’t hold back on showcasing your relevant projects!
Show Off Your Technical Skills:Since this role involves building data pipelines and optimising SQL, be sure to include specific examples of your technical expertise. We love seeing hands-on experience with tools like Dataform and Git, so let us know what you've worked on!
Demonstrate Stakeholder Management:This position requires strong communication skills, so share instances where you’ve successfully managed stakeholder expectations or translated complex data into actionable insights. We’re keen to see how you can bridge the gap between data and decision-making!
Apply Through Our Website:We encourage you to submit your application directly through our website. It’s the best way for us to receive your details and ensures you’re considered for the role. Plus, it shows you’re serious about joining our team!
How to prepare for a job interview at Utility Warehouse Limited
✨Know Your Data Tools
Make sure you’re well-versed in the tools mentioned in the job description, like Dataform and Looker. Brush up on your SQL skills and be ready to discuss how you've used these tools in past projects. Being able to talk about specific examples will show that you can hit the ground running.
✨Master Stakeholder Management
Prepare to discuss how you’ve engaged with stakeholders in previous roles. Think of examples where you refined broad requests into clear requirements. This will demonstrate your ability to manage the full request lifecycle and deliver results that align with business needs.
✨Showcase Your Analytical Thinking
Be ready to explain complex data insights in simple terms. Practice translating 'what happened' into 'why it happened' and what actions should follow. This will highlight your ability to turn data into actionable business insights, which is crucial for the role.
✨Demonstrate Project Ownership
Think of instances where you independently planned and executed projects from start to finish. Be prepared to discuss how you identified and addressed tech debt along the way. This will showcase your ownership mentality and project management skills, which are key for this position.
