Senior Data Lineage and Reconciliation Analyst

Senior Data Lineage and Reconciliation Analyst

Join to apply for the Senior Data Lineage and Reconciliation Analyst role at my Gwork - LGBTQ+ Business Community.

Please do not contact the recruiter directly. This job is with St. James's Place, an inclusive employer and a member of my Gwork – the largest global platform for the LGBTQ+ business community.

The Data and Insights Division is comprised of four key areas:
Data Governance and Intelligence;
Data Acquisition, Quality, Strategy and Literacy;
Data Insights;
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 SJP’s data. The division works closely with stakeholders across the business to foster a data‑driven culture while ensuring industry standards are met. This will enable SJP to use its data in the most effective and controlled manner to achieve its goal of 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.

• 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.
• Documenting source‑to‑target mapping rules.
• Creating scripts to transform source data in accordance with mapping rules.
• Creating reconciliation suites, including generating reports, 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 can inspire, motivate, and guide teams, fostering collaboration and a shared vision for data excellence.

• 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.

• Some business travel may be necessary.

Cirencester, England, United Kingdom

Full‑time

Mid‑Senior level

Accounting/Auditing and Finance

Referrals increase your chances of interviewing at my Gwork - LGBTQ+ Business Community by 2×.