Affinity Water
Data Architect - 24 month FTC
Data Architect - 24 month FTC at Affinity Water, based in Hatfield, East of England. This is a permanent role.
- Pay
- Not given by the employer
- Hours and contract
- Permanent · On site
- Location
- Hatfield, East of England
- Closing date
- Sector
- Software Developer
Reference e089feb7-87fa-4d4d-bbfa-d575e40fc4d8
About the role
We are looking for a Data Architect to join us on a 24-month FTC, bringing the ability to translate business needs into robust, scalable data architectures and confidently lead end-to-end design across complex, multi-domain technology landscapes.
The role requires someone who can work collaboratively with business stakeholders, solution architects, data engineers, and product teams to shape, govern, and deliver scalable, reliable, and data-driven solutions that support operational, analytical, and regulatory objectives, while embedding integrity, lineage, and governance throughout the wider data estate and ensuring alignment to enterprise architecture and strategy.
The ideal candidate will bring strong expertise in conceptual, logical, and physical data modelling, alongside deep experience in data governance, data quality, and metadata management. A strong knowledge of Master and Reference Data Management (MDM/RDM), with experience working across integrated data governance and metadata management ecosystems, including Infosphere, Alation, Informatica, and Ataccama, supporting data quality, lineage, governance, and enterprise-wide data consistency, would be highly valuable.
Key Responsibilities
Data Architecture & Modelling
Develop conceptual, logical, and physical data models for operational, analytical, and regulatory workloads.
Create and maintain data architecture blueprints and reference architectures covering ingestion, integration, storage, lineage, and consumption.
Define modelling patterns (3NF, dimensional/star, Data Vault, canonical models) and guide teams on when and how to apply them.
Optimise physical designs for performance, scalability, cost and resilience across cloud data platforms (e.g., Snowflake, Databricks, Synapse, BigQuery).
Lead design reviews, ensuring models are accurate, high-quality, and aligned with business capabilities and domain boundaries.
Data Governance & Metadata Management
Define data ownership, stewardship models, and contribute to the governance operating framework.
Build and maintain data dictionaries, business glossaries, critical data elements (CDEs) and metadata standards.
Ensure all data solutions align with governance policies, including lineage, retention, access, and security requirements.
Support governance forums and collaborate with business stewards to drive consistent definitions and controlled change.
Data Quality Architecture & Pipelines
Embed data quality rules and dimensions (completeness, timeliness, accuracy, uniqueness, validity, consistency) across ETL/ELT and streaming pipelines.
Design data quality metrics, alerts, and monitoring frameworks to surface quality issues to stewards and downstream consumers.
Partner with engineering teams to implement automated DQ checks, profiling, and remediation patterns.
Ensure DQ scoring and lineage are built into architecture in a systematic and reusable way.
Stakeholder Engagement & Requirements Leadership
Lead architectural discovery to capture business needs, translate them into data requirements, and shape programme/solution scope.
Manage and communicate architectural decisions with senior business and technical stakeholders.
Navigate ambiguity and stakeholder nuance, ensuring alignment across product teams, SMEs, vendors, and governance bodies.
Produce high-quality design documentation and present designs to Architecture Review Boards or equivalent governance forums.
Delivery Governance & Technical Leadership
Oversee the implementation of data architectures and ensure engineering teams follow patterns, standards, and best practices.
Provide technical guidance on integration design, ingestion patterns, transformation methods, caching, orchestration, and storage optimisation.
Conduct design assurance throughout delivery, ensuring solutions adhere to non-functional requirements (performance, availability, resilience, cost).
Coach engineers, analysts, and stewards on modelling, data quality, and governance practices.
Skills & Experience Required
Essential
Proven experience as a Data Architect, Solution Architect with strong data background, or senior data engineer/analyst transitioning into architecture.
Knowledge of Master and Reference Data Management and experience of integrated associated systems (Infosphere, Alation, Informatica, Ataccama etc)
Demonstrable expertise in conceptual, logical, and physical data modelling with clear understanding of modelling patterns and trade-offs.
Strong understanding of data governance frameworks, metadata management, data ownership/stewardship models, and business glossaries.
Hands-on experience embedding data quality rules, profiling, scoring, and exception management into pipelines.
Familiarity with modern cloud data platforms (Snowflake, Databricks, Azure Synapse, BigQuery, Redshift, etc.).
Ability to lead architectural thinking across multiple domains and manage stakeholder complexity.
Ability to produce high-quality architectural artefacts: blueprints, models, solution designs, integration specifications.
Experience working in regulated sectors (utilities, financial services, health, etc.) is advantageous.
Desirable
Experience with data mesh, domain-driven design, or federated data ownership models.
Experience with Great Expectations, dbt tests, or enterprise DQ tooling.
Knowledge of MDM, reference data management, and semantic modelling.
Experience with streaming platforms (Kafka, EventHub) and API-based integration.
Understanding of AI/ML data preparation pipelines and feature store design.
What Success Looks Like in This Role
Clear, scalable data models adopted across teams and projects.
High trust and alignment among stakeholders because architectural decisions are well-reasoned and clearly communicated.
Measurable improvements in data quality, lineage visibility, and governance adoption.
Production of repeatable design patterns and frameworks that accelerate delivery.
Delivery teams are confident, aligned, and able to execute effectively because the architecture removes ambiguity.
Advert closes Friday 20th November
Benefits:
Competitive salary dependant on skills and experience
Learning and development opportunities, including mentoring and a range of formal courses and open learning resources.
Entry into the company annual bonus scheme.
Annual leave from 26-30 rising with length of service, and the option to purchase up to 5 extra days.
A ‘Celebration Day’ in addition to public holidays that people can use to celebrate a religious festival or other occasion that is important to them.
A generous 'double match pension scheme' that doubles the contributions you make (company contribution capped at 12%)
We offer a range of family benefits including enhanced Maternity, Adoption, Paternity, Shared Parental Leave, Fertility Support Leave and up to 5 full or 10 half days of paid Carers Leave.
Menopause policy
Reference: e089feb7-87fa-4d4d-bbfa-d575e40fc4d8 · Posted 4 days ago · Closes 9 Dec 2026 · Listed via Affinity Water
Apply for this job
This role is listed via Affinity Water. Applications are handled on the employer's site.
Apply on employer siteOpens the employer's website in a new tab.
Signed in? Every job you apply for counts toward your weekly goal and badges. How it works
Safe applying: a genuine employer will never ask you to pay for a DBS check, training or equipment, or move you onto WhatsApp before you are hired. If this listing does, report it and do not pay anything.