1. Building a full understanding of source and target data schemas between multiple data stores.
2. Analysing both legacy and newly created data held within source and target data stores and systems.
3. Building a complete understanding of source and target data schemas and document source-to-target mapping rules.
4. Creating scripts to transform source data in accordance with mapping rules.
5. Creating reconciliation suites, including generating reporting, to compare expected versus actuals on pre-defined key data fields.
6. Completing ad-hoc data analysis tasks, including mapping data lineage and cataloguing.
7. Working within SJP’s central data management frameworks, for example data quality and data governance.
8. Engaging with project teams and business stakeholders to assess reconciliation requirements and provide narrative around reporting.
Who we’re looking for:
We are looking for an experienced data professional who has the ability to inspire, motivate, and guide teams, fostering collaboration and a shared vision for data excellence.
Essential Criteria
9. Highly experienced data professional with advanced Snowflake and SQL Server Skills
10. Experience with ETL, data cataloguing, and lineage tools.
11. Highly experienced with data structures, data modelling and architecture.
12. Experience with large scale complex data migration projects.
13. Capable of fostering mutually beneficial relationships across multiple business areas and all levels
Desirable Criteria
14. Proven experience in large-scale migration projects within financial services or other regulated industries, including client and plan integrations.
15. Previous work within a value stream driven environment is desirable.
Special Requirements:
16. Some business travel may be necessary
What's in it for you?
We reward youfor the work you do, whether that’s through our discretionary annual bonus scheme that reflects both personal and company performance, competitive annual leave allowance (28 days plus bank holidays, with the option to purchase an additional 5 days), or online rewards platform with a variety of discounts.
We also have benefits to support whatever stage of life you are in, including:
17. Competitive parental leave (26 weeks full pay)
18. Private medical insurance (optional taxable benefit)
19. 10% non-contributory pension (increasing with length of service)
Reasonable Adjustments
We're an equal opportunities employer and want to ensure our recruitment process is accessible and inclusive for all, if you require reasonable adjustment(s) at any stage please let us know by emailing us at
Research tells us that applicants (especially those from underrepresented groups) can be put off from applying for a role if they do not meet all the criteria or have been on an extended career-break. If you think you would be a good match for this role and can demonstrate some transferable experience please apply, regardless of whether you tick every box.