Data Architect - Snowflake, Databricks, DBT, SQL

Data Architect / Senior Data Architect

• £600 - £650 P.D - Outside IR35
• 6 Month contract
• 1 day a week onsite in central London

Overview:

We're working with a Data Architect to provide expert-level consulting services over a 6-month engagement. This role will lead the evolution and implementation of a unified data architecture across customer and operational domains. This is a strategic, delivery-focused engagement intended to produce clear, measurable outputs aligned to our transformation roadmap.

As a Data Architect, you will work as part of teams building solutions that make data accessible to enable evidence-based optimisation. You will engage with stakeholders and clients to design and implement integrated data solutions aligned with both internal systems and strategic goals.

Key Deliverables

• Delivers work packages collaboratively, with clarity on scope, measures of success, and technical integrity
• A comprehensive Enterprise Data Domain Map, aligned with organisational functions and platforms
• Evaluation and recommendation of semantic and physical data architecture alignment across customer and operational systems
• Support the development of the "data passport" concept for existing and new datasets in line with enterprise governance requirements
• Design patterns and integration guidance for evolving our data product strategy
• Collaborate with Data Governance Leads and Data BAs to design semantic models and logical data layers to support trusted reporting and analytics.
• Recommend standards for master data and reference data governance.
• Support adoption of federated governance, metadata management, and lineage tooling
• Support the development and implementation of a "data passport" model - a metadata construct that travels with datasets across the estate, capturing critical attributes such as ownership, purpose, classification, expiry, and governance status to ensure transparency and control.

Key responsibilities:

• Data Architecture Leadership
• Define and maintain a coherent data architecture spanning customer, operational, and analytical domains.
• Work with Principal Data Engineer and other data leaders to design a scalable achitecture, ensuring compliance, resilience, and security across cloud-based environments.
• Establish integration patterns between customer platforms and back-office systems (e.g. Finance, HR, CRM).

Overview of the role:

• Work with Engineering, Product, Data, and Commercial leaders to identify and prioritise architectural opportunities.
• Align data architecture principles with strategic business and technology goals.
• Present architectural findings, roadmaps, and decisions to both technical and non-technical audience
• Define and maintain a coherent data architecture spanning customer, operational, and analytical domains.
• Design semantic models and logical data layers to support trusted reporting and analytics.
• Establish integration patterns between customer platforms and back-office systems (e.g. Finance, HR, CRM).
• Recommend standards for data modelling, master/reference data, and metadata governance.
• Collaborate with engineering, product, and commercial leaders to align architecture with business needs.
• Evaluate third-party APIs and reverse-engineer live system data models as needed.
• Author agile stories and support engineering teams throughout development.
• Support testing, reconciliation, and integration verification activities.

Core skills and experience:

• Proven experience designing scalable data architectures in cloud and hybrid environments.
• Expertise in data modelling, SQL, and platforms like Snowflake, dbt, Power BI, and Databricks.
• Fluency in Python and knowledge of multiple cloud providers (AWS, Azure, GCP).
• Understanding of security principles including role-based access control.
• Experience with legacy-to-cloud data migration and API integration testing (e.g. using Postman).
• Experience leading data strategy and architecture delivery across complex environments.
• Broad awareness of IT architecture including networking and security considerations.
• Familiarity with Agile methodologies, TDD/BDD, and modern CI/CD practices.
• Strong communication and stakeholder influence skills.
• Practical experience with a major cloud platform (AWS, Azure, or GCP).
• Hands-on experience with Snowflake and dbt.
• Familiarity with varied data formats including CSV, JSON, and XML.
• Deep understanding of data modelling and data architecture principles.
• Any domain experience with the data for loyalty, travel (airline, hotels, cruises) or finance systems is beneficial.

Reasonable Adjustments:

Respect and equality are core values to us. We are proud of the diverse and inclusive community we have built, and we welcome applications from people of all backgrounds and perspectives. Our success is driven by our people, united by the spirit of partnership to deliver the best resourcing solutions for our clients.

If you need any help or adjustments during the recruitment process for any reason, please let us know when you apply or talk to the recruiters directly so we can support you.