Data Analyst Energy

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

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. 

You are the core builder of the team. This role marks the transition from implementing to designing. The defining characteristic of this level is the independent management of the deployment lifecycle. You will be responsible for ensuring that data transformation logic is not just correct but reproducible tested and version-controlled. 

You will not just report on data; you will build and maintain the analytics layer data models and automated pipelines that power our companys decision-making engine. You will leverage modern data stack technologies (SQL BigQuery Dataform Looker Mixpanel) to transform raw data into high-value strategic assets ensuring scalability and accuracy across business functions.

Your responsibilities will include:

• 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 set.
• 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 :

Heres some of the key skills and experience were looking for you to bring:

• 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).
• Analytics Architecture & Delivery:
  • Solid expertise in building reusable LookML code within Looker and the ability to independently lead medium-to-large analytical projectsfrom 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 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

Additional Information :

Our Interview Process:

1. Application
2. Short online SQL Test (10 minutes)
3. Recruitment Screen (30 minutes)
4. SQL Programming test (up to 45 minutes)
5. Hiring Team Interview (1 hour)
6. Final Presentation (1 hour)

So why pick UW

Weve got big ambitions so theres going to be plenty of challenges. There are also a lot of 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%.
• Flexible working
• 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 get a free Cashback Card.
• 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.

Apply now!

Youve got this far... Hit apply - we cant wait to hear from you! Worried you dont hit all the criteria We welcome applications from diverse and varied backgrounds so get your application in and lets chat!

Beth Rodgers will be your point of contact throughout the recruitment process.  

Not sure you meet all the requirements Let us decide! Research shows that women and members of other underrepresented groups tend not to apply for jobs if they think they may not meet every qualification when in fact they often do.

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 dont be afraid to ask about what we can do to support your needs. All requests will be carefully and fairly considered.

Please note 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.

Remote Work :

No

Employment Type :

Full-time