Hybrid Data Architect – Scalable Models & Governance

Tain; Greater London; Hybrid; GBP 70,000 - 110,000; Full time

Benefits offered by this job

26 days holiday

Hybrid working

Pension plan

Life assurance (4x salary)

Private medical insurance

Team building opportunities

Flexible core hours 10am–4pm

Employee assistance program

Job summary

Tain is seeking a Data Architect to design and govern data architecture, models, and standards for scalable, reliable data products. You will ensure consistent data definitions and support both operational reporting and advanced analytics.

Lead data modelling efforts, define integration patterns, and collaborate with engineering and analytics teams to deliver high-quality data assets.

Qualifications

• 5–10+ years of experience in data architecture, data modelling, or senior data engineering roles.
• Strong expertise in data modelling (dimensional modelling, normalization, semantic layers).
• Proven experience designing scalable data architectures (warehouse, lake, or lakehouse).
• Solid understanding of ETL/ELT pipelines and transformation patterns.
• Experience with API-driven and/or event-based systems.
• Ability to define and enforce data standards and governance practices.
• Experience collaborating with engineering and analytics teams.
• Strong problem-solving skills with focus on data consistency.

Responsibilities

• Define and maintain canonical data models across domains.
• Design scalable data structures to support analytics and reporting.
• Ensure consistent definitions of key business entities and metrics.
• Align data models across multiple source systems and integration layers.
• Provide architectural guidance to Data Engineers and review design decisions.
• Ensure scalability, performance, and maintainability of data solutions.
• Define frameworks for data quality, validation, and reconciliation.
• Support governance and data ownership initiatives with the Data & Insights Manager.
• Promote reuse of datasets across teams and reduce data duplication.

Skills

Data modelling

Data architecture

Dimensional modelling

Data warehousing

ETL/ELT pipelines

APIs / event-driven

Data governance

Cross-functional collaboration

Data quality

Tools

Snowflake

BigQuery

dbt

Kafka

Job description

Tain is seeking a Data Architect to design and govern data architecture, models, and standards for scalable, reliable data products. You will ensure consistent data definitions and support both operational reporting and advanced analytics.

Lead data modelling efforts, define integration patterns, and collaborate with engineering and analytics teams to deliver high-quality data assets.