Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead data reconciliation initiatives and transform data for actionable insights.
- Company: Join a forward-thinking company focused on data excellence and innovation.
- Benefits: Competitive salary, annual bonus, generous leave, and private medical insurance.
- Why this job: Make a real impact in a dynamic environment while shaping the future of data strategy.
- Qualifications: Advanced skills in Snowflake, SQL Server, and experience with large data sets.
- Other info: Hybrid work model with opportunities for career growth and development.
The predicted salary is between 36000 - 60000 £ per year.
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.
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.
Essential Criteria
- 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
Desirable Criteria
- 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 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)
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.
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.
Senior Data Reconciliation Analyst employer: St. Jamess Place
Contact Detail:
St. Jamess Place Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior Data Reconciliation Analyst
✨Tip Number 1
Network like a pro! Reach out to current employees on LinkedIn or attend industry events. This can give you insider info about the company culture and maybe even a referral.
✨Tip Number 2
Prepare for the interview by researching the company’s data strategy and recent projects. Show us that you’re not just interested in the role, but also in how you can contribute to their goals.
✨Tip Number 3
Practice your storytelling skills! Be ready to share specific examples of your past experiences with data reconciliation and how they align with what SJP is looking for.
✨Tip Number 4
Don’t forget to follow up after your interview! A quick thank-you email can keep you top of mind and show us that you’re genuinely interested in the position.
We think you need these skills to ace Senior Data Reconciliation Analyst
Some tips for your application 🫡
Tailor Your CV: Make sure your CV reflects the skills and experiences that align with the Senior Data Reconciliation Analyst role. Highlight your advanced Snowflake and SQL Server skills, as well as any experience with data architecture and large-scale migration projects.
Craft a Compelling Cover Letter: Use your cover letter to tell us why you're passionate about data and how you can contribute to our mission. Share specific examples of how you've inspired teams or improved data processes in your previous roles.
Showcase Your Data Skills: In your application, don’t shy away from showcasing your technical prowess. Mention any relevant projects where you’ve built data schemas or created reconciliation suites, as this will resonate with what we’re looking for.
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at St. Jamess Place
✨Know Your Data Inside Out
Before the interview, make sure you have a solid understanding of data schemas and how they relate to the role. Brush up on your Snowflake and SQL Server skills, as well as any relevant data architecture concepts. Being able to discuss specific examples of your experience with data reconciliation will show that you're not just familiar with the theory but can apply it in practice.
✨Showcase Your Problem-Solving Skills
Prepare to discuss past projects where you've tackled complex data migration challenges. Think about how you identified issues, developed solutions, and what the outcomes were. This will demonstrate your analytical abilities and your capacity to deliver measurable benefits, which is key for this role.
✨Engage with Stakeholders
Since the role involves working with various teams and stakeholders, be ready to talk about how you've successfully collaborated in the past. Share examples of how you’ve built relationships and communicated effectively to assess requirements and provide insights. This will highlight your interpersonal skills and ability to foster collaboration.
✨Understand the Company’s Vision
Familiarise yourself with the company's strategy and how the Data Acquisition, Quality, and Strategy division fits into the bigger picture. Be prepared to discuss how you can contribute to their goals and help create a strong data culture. Showing that you align with their vision will set you apart from other candidates.
