Data Architect at Utility Warehouse

London, England, United Kingdom -

Full Time

Start Date

Immediate

Expiry Date

16 Jul, 26

Salary

0.0

Posted On

17 Apr, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data architecture, BigQuery, Kimball dimensional modeling, Dataform, dbt, ELT design, Looker, LookML, GCP, System design, Data governance, SQL, Data modeling, Scalability, Data quality monitoring

Industry

Utilities

Description

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. The challenge For our customers and Partners, UW just needs to work – there when you need it, and invisible when you don’t. Just like flicking a switch. Our proposition to customers is simple, but for our technology teams, the behind-the-scenes complexity is what makes it so interesting. Learn more about life in our Tech teams here. Got your attention? Read on.. Job Description 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. We work together. Your team and the people you will work with… 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. We Deliver Progress.. What you'll do and how you'll make an impact: Enterprise Data Architecture: Design the end-to-end platform blueprint, ensuring scalability, reliability, and performance from ingestion to consumption. Greenfield Data Modelling: Champion Kimball dimensional modelling methodologies to design a robust, scalable schema for our new enterprise data warehouse. System Design: Architect complex systems for massive scale and high-frequency streams, defining batch and streaming patterns for implementation. Tooling & Integration: 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. Governance Support: Design systems that technically enforce the frameworks and policies owned by the Data Governance Manager. The First 6 Months: Success Looks Like... 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. Qualifications We put people first. It’s all about you.. Technical Mastery: 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. Impact & Scope: 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. Planning & Delivery: 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. Business & Domain Knowledge: You have experience of running similar initiatives in complex, highly-regulated environments Leadership & Culture: 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. Skills / Competencies: 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. Additional Information 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: 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 You’ve made it this far... hit apply! We can’t wait to hear from you. Worried you don’t hit every single bit of the criteria? We welcome applications from all backgrounds. If you’re a go-getter with a great heart, get your application in and let’s chat. Beth Rodgers will be your point of contact throughout the 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 don’t 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. Employment Status: Full-Time

Responsibilities

The Data Architect will lead the design and implementation of the enterprise data warehouse and platform blueprint. They will champion dimensional modeling methodologies and define system architectures for high-volume data processing.