Data Architect, Utility Warehouse
+ Performance bonus: An annual discretionary bonus ranging from 15-40%
2+ days a week in office
Multiservice utilities provider
Be an early applicant
Multiservice utilities provider
1001+ employees
Be an early applicant
+ Performance bonus: An annual discretionary bonus ranging from 15-40%
2+ days a week in office
1001+ employees
Company mission
To be the nation’s most trusted utility supplier by simplifying home services, helping customers to stop wasting time and money.
Role
Who you are
- The BigQuery Specialist: You don’t just know SQL; you understand BigQuery reservations, partitioning, clustering, and how to optimize costs in a multi-terabyte environment
- The Modeler: You are a master of Kimball/Dimensional modeling but know when to use OBT (One Big Table) for modern BI performance
- The Tech Stack Ninja: Deep experience with Dataform (or dbt), ELT design patterns, Looker (LookML), and all things GCP
- The Communicator: You can explain to a Product Manager why a 2-week "foundation build" is better than a 2-hour "quick fix" that breaks next month
- The Pragmatist: You understand that "Perfect is the enemy of Shipped." You can navigate a high-change environment where changes to our Partner proposition are complex and often time-sensitive
- You have experience of running similar initiatives in complex, highly-regulated environments
- You role-model UW values by promoting a data-driven culture, mentoring peers, and communicating technical successes and failures clearly to the wider Technology & Product department
- Strategic Problem Solving: Ability to break down vague, high-level business requirements into concrete, scalable technical architectures
- Clear Communication: Excellent verbal and written skills, with the ability to influence technical and non-technical audiences
- Accountability: Willingness to take ownership of critical systems and participate in on-call rotations
- Continuous Learning: Proactively seeking out the latest industry trends and introducing relevant innovations to the team
- Don’t worry if you don’t have the whole list. If you feel you have most of it and can learn the rest pretty quickly then please don’t hesitate to apply
- Overall we are looking for imaginative and pragmatic problem-solvers who want to help make a positive impact with data at UW
What the job involves
- We are seeking a Data Architect to lead a greenfield initiative: building the backbone of our new Enterprise Data Warehouse and migrating our data estate to a dimensional modelling environment
- In this pivotal role, you will own the enterprise data architecture and platform design. Working closely with Data Engineers, Data Analysts and Data Governance Manager, you will focus on system design, modelling strategy, and handling high-volume challenges — such as processing half-hourly meter reads — at scale
- Design the end-to-end platform blueprint, ensuring scalability, reliability, and performance from ingestion to consumption
- Champion Kimball dimensional modelling methodologies to design a robust, scalable schema for our new enterprise data warehouse
- Architect complex systems for massive scale and high-frequency streams, defining batch and streaming patterns for implementation
- Partner with Data Governance to select and integrate modern tooling (e.g., Dataform, cataloging) into the platform architecture. You will lead the selection and implementation of our first Data Catalog and Observability tools
- Work with our regulated domains to design patterns that allow us to efficiently meet the continuous data needs of our regulators and auditors
- Design systems that technically enforce the frameworks and policies owned by the Data Governance Manager
- 30 Days: A complete "As-Is" map of our most critical data flows (Commission, Billing) and a clear identification of the "Top 10" tech-debt bottlenecks
- 3 Months: The launch of a "Golden Path" Dataform template and the first "V2" Medallion-compliant data models for a core business domain
- 6 Months: A 2-year North Star roadmap and the implementation of basic Automated Data Quality monitoring on our top-tier Gold tables
Application process
- Beth Rodgers will be your point of contact throughout the process
Salary benchmarks
Our take
Budgeting for a household is no easy task, especially when you've got to keep track of various bills from different providers. That's why Utility Warehouse provides customers with all their home services – including energy, broadband, mobile and insurance – in one simple, monthly bill.
The company says that this all-in-one approach ‘makes budgeting so much easier’ for customers, which is backed up by a strong customer services record. Though it does not advertise heavily, its partners are given incentives to sign up new customers, which has contributed to its impressive growth thus far.
Boasting over 1 million customers across the services they sell, Utility Warehouse is one of the largest energy providers outside the 'Big 6'. Its unique approach, and established footing in the market, should ensure it continues to compete with other challengers as the utilities sector further evolves.
Kirsty
Company Specialist at Welcome to the Jungle
Insights
Company
Employee endorsements
Opportunities to learn
"My manager is always looking to create more opportunities for me to have my voice heard and be stretched into areas I've not necessarily worked in..."
Company benefits
- An industry benchmarked salary. We’ll share it during your first conversation
- Annual discretionary performance based, annual bonus scheme
- Hybrid working, with 2 days in the office. (We’re definitely open to discussing flexible working arrangements)
- Holiday trading- buy & sell up to 5 days holiday each year
- Discount on our services and you get our coveted Cashback Card for free. You’ll also get access to 100s of rewards and discounts through Perkbox
- A matched contribution pension scheme and life assurance up to 4x your salary. You can also access free mortgage advice and a financial wellbeing tool
- Save as You Earn scheme
- Family-friendly policies, designed to help you and your family thrive
- Flexible benefit choices such as Private health insurance, a free Virtual GP, Gym discounts and wellbeing apps
- Electric Car salary sacrifice scheme through Tusker
- Belonging groups that help UW shape an even more inclusive future
- A commitment to helping you develop your career journey through learning, coaching and new experiences
Company values
- We’re people helping people: Because it keeps us real
- We’re open, empathetic, and foster belonging
- We get it done together: Because it helps us get things done
- We keep things simple, take ownership, and win together
- We’re all about results: Because we're ambitious
- We’re impact-focused, daring, and spirited
Company HQ
Farringdon, London, UK
Leadership
Stuart Burnett
(CEO)Stuart began his career as a corporate lawyer before working in several notable insurance firms. He joined UW in 2016 and has held several leadership roles, becoming CEO in 2021.
People progressing
Kerry
Joined as an Electricity Operations Analyst. Promoted 6 times and is now Head of Energy Operations.
Diversity, Equity & Inclusion at Utility Warehouse
Stuart Burnett (Co-CEO)
- We’re a unique bunch of people here at UW – and that’s just how we like it. We embrace different perspectives, experiences, and personalities, creating an inclusive environment where people feel they can belong
- We write job description requirements as minimally as possible to encourage candidates who may exclude themselves to apply, and the Recruitment team work with our hiring managers to minimise bias in the hiring process
- We have a number of active Employee-led Inclusion groups - Menopause Support Pride, Women in Leadership Carers Support
- We openly publish our D&I results internally and externally as well as our targets for improvement.
- We put on unconscious bias workshops and training for all team members
- We provide mental health support and other wellness initiatives to support all our team members
- We are a member of the Women in Utilities network and actively support opportunities for mentoring through the group
- We provide inclusive leadership learning to all people leaders at UW
- We have committed to the Race at Work Charter
- We have an active, zero-tolerance, Harassment and Bullying policy
Share this job
View 29 more jobs at Utility Warehouse