Colossus Recruitment Ltd

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 This is a high-performance environment where growth, innovation and continuous improvement are part of everyday life. The pace is faster than many organisations, with constant opportunities to improve systems, processes and ways of working. Success comes from embracing change, taking ownership, and contributing ideas that drive better outcomes. 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 APIs Interfaces System integrations 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 Data architecture Conceptual and logical data models Integrations and interfaces Experience producing technical designs successfully delivered by development teams Ability to make and own architecture decisions independently Personal Attributes 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. When submitting your application to Colossus, please ensure the following Your CV has your address and postcode. You also have your correct phone number and email address so we can contact you asap regarding your application.