Senior Data Lineage and Reconciliation Analyst
Are you ready to chart your own career path? With our refreshed strategy, we're building on our rich heritage and transforming our business to be more scalable and efficient, unlocking the capabilities needed for future success. This includes significantly investing in technology, streamlining the way we work and creating an environment where colleagues feel engaged, empowered and accountable; where they can show up, speak up and perform - because we believe in the difference our work makes.
At a glance:
Location: Cirencester Office
Workplace Type: Hybrid
Employment Type: Permanent
Seniority: Mid-Senior Level
The Data and Insights Division is comprised of four key areas: 1. Data Governance and Intelligence; 2. Data Acquisition, Quality, Strategy and Literacy; 3. Data Insights; 4. Data Architecture, Platform and Engineering. This presents an opportunity to design a data strategy aligned with the organization's goals and execute the delivery of data effectively. D&I enables SJP to leverage value from its data through actionable insights and data led decision making.
Data Governance(DGOV) Division is responsible for implementing and managing a comprehensive data governance framework to ensure the integrity of SJPs data. The division works closely with stakeholders across the business the to foster a data driven culture whilst ensuring industries standards are met. This will enable SJP to use its data in the most effective and controlled manner to achieve its goal in becoming a data led organisation.
Reporting to the Head of Division – Data Governance and Intelligence in the Data Governance & Intelligence team within the Data & Insights (D&I) Division, the role holder will be responsible for the initiation and delivery of corporate wide data reconciliation, cataloguing and lineage initiatives which deliver measurable benefits to SJP, its clients, Partners and employees.
What you'll be doing:
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
We reward you for 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:
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.
What's next?
If you're excited about this role and believe you have the skills and experience we're looking for, we'd love to hear from you! Please submit an application by clicking 'apply' below and our team will be in touch.
As a business regulated by the FCA we would advise you to familiarise yourself with the conduct regulations and in particular consumer duty obligations prior to an interview with SJP.
At a glance:
Location: Cirencester Office
Workplace Type: Hybrid
Employment Type: Permanent
Seniority: Mid-Senior Level
The Data and Insights Division is comprised of four key areas: 1. Data Governance and Intelligence; 2. Data Acquisition, Quality, Strategy and Literacy; 3. Data Insights; 4. Data Architecture, Platform and Engineering. This presents an opportunity to design a data strategy aligned with the organization's goals and execute the delivery of data effectively. D&I enables SJP to leverage value from its data through actionable insights and data led decision making.
Data Governance(DGOV) Division is responsible for implementing and managing a comprehensive data governance framework to ensure the integrity of SJPs data. The division works closely with stakeholders across the business the to foster a data driven culture whilst ensuring industries standards are met. This will enable SJP to use its data in the most effective and controlled manner to achieve its goal in becoming a data led organisation.
Reporting to the Head of Division – Data Governance and Intelligence in the Data Governance & Intelligence team within the Data & Insights (D&I) Division, the role holder will be responsible for the initiation and delivery of corporate wide data reconciliation, cataloguing and lineage initiatives which deliver measurable benefits to SJP, its clients, Partners and employees.
What you'll be doing:
- Building a full understanding of source and target data schemas between multiple data stores.
- Analysing both legacy and newly created data held within source and target data stores and systems.
- Building a complete understanding of source and target data schemas and document source-to-target mapping rules.
- Creating scripts to transform source data in accordance with mapping rules.
- Creating reconciliation suites, including generating reporting, to compare expected versus actuals on pre-defined key data fields.
- Completing ad-hoc data analysis tasks, including mapping data lineage and cataloguing.
- Working within SJP's central data management frameworks, for example data quality and data governance.
- Engaging with project teams and business stakeholders to assess reconciliation requirements and provide narrative around reporting.
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
- Highly experienced data professional with advanced Snowflake and SQL Server Skills
- Experience with ETL, data cataloguing, and lineage tools.
- Highly experienced with data structures, data modelling and architecture.
- Experience with large scale complex data migration projects.
- Capable of fostering mutually beneficial relationships across multiple business areas and all levels
- Proven experience in large-scale migration projects within financial services or other regulated industries, including client and plan integrations.
- Previous work within a value stream driven environment is desirable.
- Some business travel may be necessary
We reward you for 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:
- Competitive parental leave (26 weeks full pay)
- Private medical insurance (optional taxable benefit)
- 10% non-contributory pension (increasing with length of service)
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.
What's next?
If you're excited about this role and believe you have the skills and experience we're looking for, we'd love to hear from you! Please submit an application by clicking 'apply' below and our team will be in touch.
As a business regulated by the FCA we would advise you to familiarise yourself with the conduct regulations and in particular consumer duty obligations prior to an interview with SJP.