Data Integration Architect

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

• Naturally analytical and inquisitive
• Comfortable working with ambiguity and incomplete information
• Strong problem-solving skills
• Excellent communication and stakeholder management abilities
• Pragmatic and solutions-focused
• Able to balance technical excellence with business needs

What’s On Offer?

• Private medical insurance
• Enhanced pension contributions
• Enhanced family-friendly leave and pay
• Income protection
• Life assurance
• Time Off

Working Environment

• Hybrid working model
• Flexible and collaborative culture
• Modern office environment
• Dog-friendly workplace
• Ongoing learning and professional development opportunities

All our roles are UK based.

#J-18808-Ljbffr…