Colossus Recruitment
Data Integration Architect
Get notified of more jobs like this · No spam, ever
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Data Integration Architect (SQL, Reverse Engineering, MSSQL API)
Our client is seeking a Data Integration Architect to take ownership of how data and systems interact across a growing and evolving organization.
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 organizations, 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 behaviors
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
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 role
- 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
Get help with your application
Your very own career expert that helps elevate your application to the next level.
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.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London