Data Architect

Utility Warehouse

full-time

Posted on: 2/21/2026

Location Type: Remote

✨ AI Apply

About the role

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.

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.

Benefits

An industry benchmarked salary. We’ll share it during your first conversation.
Share Options and a Save as You Earn scheme.
Flexible remote working with the option to visit our London hubs for team meetings and company events.
You'll have access to a range of hot desking spaces around the UK
Electric Car salary sacrifice scheme through Tusker
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.
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.
Our wellbeing app Unmind supports your mental health.
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

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

BigQuerySQLKimball dimensional modelingDataformdbtLookerLookMLELT design patternsdata modelingautomated data quality monitoring

Soft Skills

communicationplanningdeliveryleadershipmentoringproblem-solvingadaptabilitycollaborationcritical thinkingstakeholder management