Data Integration Architect

Colossus Recruitment Ltd

Metropolitan Borough of Solihull

Hybrid

GBP 70,000 - 110,000

Full time

13 days ago

Application generator

An application made for this job — a tailored resume and cover letter that speak straight to the posting.

Get past ATS filters

Benefits offered by this job

Private medical insurance

Enhanced pension contributions

Enhanced family-friendly leave and pay

Income protection

Life assurance

Time Off

Job summary

Colossus Recruitment Ltd. is seeking a Data Integration Architect in the United Kingdom to own how data and systems interact across a growing organisation.

You will reverse-engineer existing and legacy systems, uncover how they operate, and translate that understanding into scalable architectures for development teams to implement. The role combines investigative analysis with future-state design, offering the chance to shape data architectures and practical integration strategies that support

Qualifications

Minimum 5 years' experience in Data and Systems engineering or related architecture roles.
Proven experience reverse-engineering existing and legacy systems.
Strong hands-on SQL and relational database expertise.
Experience investigating: APIs, interfaces, and system integrations.
Ability to read and interpret code to understand data processing and business logic.

Responsibilities

Discover how systems really work by reverse-engineering and mapping legacy systems.
Map end-to-end data flows, identify systems of record and data ownership.
Design future-state data architectures and practical integration interfaces.
Provide technical direction and translate architectural vision into implementable designs.
Bridge business requirements with technology, communicating clearly to stakeholders.
Support delivery through design validation, documentation, and evidence-based refinements.

Skills

SQL

Reverse engineering

MSSQL API

Job description

Data Integration Architect (SQL, Reverse Engineering, MSSQL API)

Our client is seeking Data Integration Architect to take ownership of how data and systems interact across a growing and evolving organisation.

This is a highly influential role that combines investigative analysis with future‑state design. You’ll reverse‑engineer existing and legacy systems, uncover how they truly operate, and translate that understanding into scalable, practical architectures that development teams can implement.

If you enjoy solving complex system challenges, making sense of undocumented processes, and designing clear, effective solutions, this role offers the opportunity to make a significant impact.

What It’s Like Working Here

Enjoy working in a dynamic and evolving environment
Are naturally curious and investigative
Take ownership of challenges and outcomes
Are comfortable making decisions with incomplete information
Value collaboration, honesty and continuous learning
Want to be stretched professionally and make a visible impact

The culture rewards expertise, accountability and problem‑solving rather than hierarchy or ego.

The Role

Discover How Systems Really Work

Reverse‑engineer existing and legacy systems to establish how they truly function
Investigate databases, SQL queries, stored procedures, APIs, integrations and application code
Identify how data is created, validated, transformed, stored and transferred
Uncover undocumented business rules, dependencies and system behaviours

Map End-to-End Data Flows

Trace data throughout its lifecycle
Identify systems of record, ownership and duplication
Understand relationships between applications, integrations and data sources
Document dependencies and technical risks

Design the Future State

Create future‑state systems and data architectures
Develop conceptual and logical data models
Design practical integration strategies and interfaces
Ensure solutions support business objectives and scalability

Provide Technical Direction

Translate architectural vision into technical designs developers can build
Define data structures, interfaces and integration requirements
Resolve ambiguity and answer technical questions throughout delivery
Review implementations to ensure alignment with architectural intent

Bridge Business and Technology

Work closely with business process teams and software development teams
Translate operational requirements into technical solutions
Communicate complex technical concepts to non‑technical stakeholders
Evaluate options and explain trade‑offs clearly

Support Delivery and Continuous Improvement

Remain involved throughout implementation and testing
Validate design assumptions through evidence and results
Refine solutions where necessary
Maintain clear, accurate architectural documentation and diagrams

About You

Essential Experience

Minimum 5 years' experience in Data and Systems engineering with related architecture in your rolerole
Proven experience reverse-engineering existing and legacy systems
Strong hands‑on SQL and relational database expertise
Experience investigating: Stored procedures
Experience investigating: APIsExperience investigating: Interfaces
Experience investigating: System integrations
Experience investigating: Application code
Ability to read and interpret code to understand data processing and business logic
Experience mapping complex end-to-end data flows
Strong understanding of systems of record, dependencies and business rules
Proven experience designing: Systems architecture
Proven experience designing: Data architectureProven experience designing: Conceptual and logical data modelsProven experience designing: Integrations and interfaces
Experience producing technical designs successfully delivered by development teams
Ability to make and own architecture decisions independently