At a Glance
- Tasks: Lead data mapping between legacy systems and new platforms, ensuring accurate data transformation.
- Company: Join a forward-thinking company focused on innovative data solutions.
- Benefits: Competitive pay, flexible working options, and opportunities for professional growth.
- Why this job: Be at the forefront of a greenfield project, shaping the future of data management.
- Qualifications: Experience in data mapping, strong analytical skills, and stakeholder management.
- Other info: Collaborative environment with potential for career advancement.
The predicted salary is between 36000 - 60000 Β£ per year.
Overview: To define the source and target object modelling and lead the data mapping between source and target systems.
Contract Type: Fixed Term Contract (FTC)
Duration: 12 months
Start Date: Jan 2026
Current day rate and contract type: Business Context
This is a greenfield data mapping exercise β no validated source-to-target mapping specification currently exists. The role requires designing the object model alignment between legacy platforms (RIBS and Milvis) and the target Avaloq Opus instance, which is still being built out for the CI business unit. The migration is complicated by 40+ years of legacy client, banking, and custody data, requiring strong data modelling and interpretation skills.
Summary: We require someone who has lived and breathed, been hands on in leading and pulling together a data migration mapping specification/document for a wealth migration platform. Usual legacy platform migration to new target platform and the complication that brings with having data that is 40 years old on the legacy side. Mapping spec, object modelling, data modelling experience. Avaloq and wealth management experience would be advantageous. Clear and crisp stakeholder management and the ability to drive a decision.
- Define and document source and target object models and how they align.
- Act as the bridge between raw data sources and actionable insights, ensuring that data is accurately transformed, integrated, and routed to the right destinations.
- Create accurate and easy to understand mapping specification documents for use by developers and for business teams to consume and sign off against.
- Collaborate with IT and business SMEs to define mapping specifications.
- Ensure data integrity and accuracy throughout the mapping process.
- Assist in defect triage and root cause analysis where mappings are deemed to be incorrect.
- Own necessary updates to mapping documents with robust version control and detailed explanation of changes.
- Build and develop relationships with IT and business stakeholders.
- Aid and assist both ETL developers and test teams in their requests for source data extracts from IT team.
- Lead workshops and draw decisions to swift conclusion regarding data mapping and golden source.
- Lead the structural alignment of legacy RIBS and Milvis data models with Avaloq Opus, ensuring conceptual, logical, and physical consistency across platforms.
- Engage with Avaloq platform SMEs to validate assumptions about target data structures, behaviours, constraints, and how new CI business-unit functionality will be built.
- Represent mapping proposals to architecture and business teams, resolving object-model ambiguity and obtaining alignment on the proposed structure before detailed mapping begins.
- Act as the senior mapping authority for the team, providing direction to the incoming junior Data Mapping Analyst and ensuring consistent modelling standards across outputs.
- Work closely with the ETL developer to unblock development work early, clarifying modelling decisions so ETL design is not delayed by mapping uncertainty.
- Manage iterative refinement of models and mapping specifications as the target platform evolves, maintaining full version control and clear rationale for structural decisions.
Required Experience/Skills:
- Experience mapping into non-mature or in-build platforms, where target data structures are evolving and require architectural interpretation.
- Ability to analyse, rationalise, and model poorly structured or inconsistent legacy datasets spanning multiple decades.
- Proven ability to drive structural decisions and achieve stakeholder alignment where multiple interpretations or source-of-truth options exist.
- Comfortable presenting and defending mapping and modelling proposals to architecture, IT, business SMEs, and Avaloq teams.
- Competent SQL user capable of profiling data, validating mapping logic, and supporting defect investigations (not as a developer, but confident enough to interrogate datasets).
Data Mapping Engineer employer: Data Inc
Contact Detail:
Data Inc Recruiting Team
StudySmarter Expert Advice π€«
We think this is how you could land Data Mapping Engineer
β¨Tip Number 1
Network like a pro! Reach out to folks in the industry, especially those who have experience with data mapping and legacy systems. Attend meetups or webinars, and donβt be shy about asking for informational interviews. You never know who might have the inside scoop on job openings!
β¨Tip Number 2
Show off your skills! Create a portfolio that highlights your data mapping projects, especially any work with legacy systems or complex migrations. This will give potential employers a clear view of what you can bring to the table.
β¨Tip Number 3
Prepare for interviews by brushing up on your stakeholder management skills. Be ready to discuss how you've successfully navigated complex data mapping scenarios and resolved ambiguities in past roles. Real-life examples will make you stand out!
β¨Tip Number 4
Donβt forget to apply through our website! Weβve got some fantastic opportunities waiting for you, and applying directly can sometimes give you an edge. Plus, itβs super easy to keep track of your applications that way!
We think you need these skills to ace Data Mapping Engineer
Some tips for your application π«‘
Tailor Your CV: Make sure your CV is tailored to the Data Mapping Engineer role. Highlight your experience with data mapping, object modelling, and any relevant legacy platform migrations. We want to see how your skills align with our needs!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're the perfect fit for this role. Share specific examples of your past experiences that relate to the job description, especially around stakeholder management and data integrity.
Showcase Your Technical Skills: Donβt forget to mention your technical skills, especially your SQL proficiency and experience with data modelling. Weβre looking for someone who can confidently engage with datasets and support defect investigations, so make that clear in your application!
Apply Through Our Website: We encourage you to apply through our website for a smoother process. It helps us keep track of applications and ensures you get all the updates directly from us. Plus, it shows youβre keen on joining the StudySmarter team!
How to prepare for a job interview at Data Inc
β¨Know Your Data Inside Out
Before the interview, dive deep into data mapping concepts and the specific challenges of legacy systems. Familiarise yourself with the intricacies of RIBS, Milvis, and Avaloq Opus. Being able to discuss these platforms confidently will show that youβre not just a candidate, but someone who understands the landscape.
β¨Prepare Your Mapping Specifications
Bring examples of mapping specifications you've created in the past, especially those involving complex legacy data. Be ready to explain your thought process and how you ensured data integrity. This will demonstrate your hands-on experience and ability to create clear documentation.
β¨Engage Stakeholders Effectively
Think about how youβve managed stakeholder relationships in previous roles. Prepare to share specific examples of how youβve resolved conflicts or aligned differing opinions on data structures. This will highlight your communication skills and ability to drive decisions.
β¨Showcase Your SQL Skills
Brush up on your SQL knowledge, as itβs crucial for profiling data and validating mapping logic. Be prepared to discuss how youβve used SQL in past projects, even if you werenβt a developer. This will illustrate your capability to interrogate datasets effectively.