Are you ready tochart 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.
The Data Acquisition, Quality, and Strategy (DAQS) Division focuses on data relationships, Data Quality, Data Strategy, and Data Literacy at SJP. The division is essential to D&I to oversee and manage relationships with our third party data providers, monitor the quality of incoming data and data within the SJP estate, define SJP's data strategy and how it aligns with the overall business vision, and enable SJP to become a truly data literate organisation with a strong data culture.
Reporting to the Divisional Director – Data Acquisition, Quality, & Strategy in the Data Acquisition, Quality, & Strategy division of the Data & Insights (D&I) team, the role holder will be responsible for the initiation and delivery of corporate wide data reconciliation 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
* Building 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
* 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.
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.
* Highly experienced data professional with advanced Snowflake and SQL Server Skills
* Highly experienced with data architecture, schema design, and working with large data sets.
* 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.
Special Requirements:
* 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 bothpersonal and company performance, competitive annual leave allowance (28 daysplus bank holidays, with the option to purchase an additional 5 days), oronline rewards platform with a variety of discounts.
We also havebenefits 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)
Reasonable Adjustments
We're an equalopportunities employer and want to ensure our recruitment process is accessibleand inclusive for all, if you require reasonable adjustment(s) at any stageplease let us know by emailing us at careers@sjp.co.uk
Research tells usthat applicants (especially those from underrepresented groups) can be put offfrom applying for a role if they do not meet all the criteria or have been onan extended career-break. If you think you would be a good match for this role andcan demonstrate some transferable experience please apply, regardless ofwhether you tick every box.
What's next?
If you're excitedabout this role and believe you have the skills and experience we're lookingfor, we'd love to hear from you! Please submit an application by clicking ‘apply’ below and our team will be in touch.
As a businessregulated by the FCA we would advise you to familiarise yourself with theconduct regulations and in particular consumer duty obligations prior to aninterview with SJP.
#J-18808-Ljbffr