Data Architect

Synergize Consulting Ltd; Bristol; On-site; GBP 70,000 - 90,000; Full time

Job summary

A leading consulting firm is seeking experienced SC Cleared Data Architects to support design and delivery of data-intensive systems. The role involves defining and implementing data architectures, ensuring data integrity, security, and compliance. Responsibilities include collaborating with various teams, optimizing ETL pipelines, and providing technical leadership. Candidates should have strong experience in data architecture and excellent SQL skills, preferably with a STEM degree. Competitive package offered in the UK.

Qualifications

• Strong experience in data architecture, database design, or data engineering.
• Excellent SQL skills and experience with various databases.
• Solid understanding of enterprise-grade data architectures.

Responsibilities

• Design and implement enterprise-level data architectures.
• Develop and maintain conceptual and physical data models.
• Define and enforce data management standards and policies.

Skills

Data architecture

Database design

SQL

Data governance

Data security

ETL/ELT

Communication

Education

Bachelor's degree in STEM or related field

Master's degree (preferred)

Tools

Oracle

SQL Server

PostgreSQL

MySQL

Informatica

Talend

Apache Airflow

Job description

We are seeking two experienced SC Cleared Data Architects (Level 6) to support the design, delivery, and governance of data-intensive systems for a major programme based in Edinburgh.

You will be responsible for defining and implementing enterprise-grade data architectures that ensure data is accurate, secure, accessible, and aligned to business objectives. This role requires hands-on experience across the full delivery life cycle, from requirements gathering and solution design through to implementation and handover.

You will work proactively with IT teams, data engineers, system engineers, and business stakeholders, playing a key role in shaping data models, data flows, and governance frameworks across cloud and on-prem environments.

Key Responsibilities

• Design and implement enterprise-level data architectures, including databases, data warehouses, and data lakes
• Develop and maintain conceptual, logical, and physical data models
• Define and enforce data management standards, policies, and best practices
• Collaborate with data engineers to design and optimise ETL/ELT pipelines
• Ensure data quality, consistency, security, and compliance across platforms
• Translate business data requirements into scalable technical solutions
• Support data governance initiatives, including metadata management and MDM
• Oversee data integration across cloud and on-premises systems
• Evaluate and recommend new data technologies and platforms
• Provide technical leadership and mentoring to data engineering and analytics teams

Essential Skills & Experience

• Bachelor's degree in STEM, Computer Science, Data Science, or related field (Master's preferred)
• Strong experience in data architecture, database design, or data engineering
• Excellent SQL skills and experience with databases such as Oracle, SQL Server, PostgreSQL, MySQL
• Solid understanding of data warehouse and lakehouse architectures
• Experience with ETL/ELT and orchestration tools (e.g. Informatica, Talend, Apache Airflow)
• Proven experience designing data models
• Strong understanding of data governance and data security requirements
• Excellent communication, documentation, and problem-solving skills
• Exposure to AI/ML data pipelines and analytics platforms

Desirable Experience

• Cloud data platforms (AWS, Azure, Google Cloud)
• Big data technologies (Hadoop, Spark, Kafka)
• UML/SysML
• API integration and microservices data flows