At a Glance
- Tasks: Lead data migration projects using Salesforce and SQL, ensuring accuracy and efficiency.
- Company: Join a forward-thinking tech company that values collaboration and innovation.
- Benefits: Performance-based pay, flexible working, and opportunities for career growth.
- Other info: No formal qualifications needed; we value your experience and potential.
- Why this job: Make a real impact by transforming data and shaping migration strategies.
- Qualifications: Experience with Salesforce data migrations and strong SQL skills required.
The predicted salary is between 58500 - 71500 £ per year.
- Data Migration Analyst (Salesforce, SQL) - Contractor
- UK (Reading)
- Information Technology /
- Contractor /
- Hybrid
Role overview
We are looking for an experienced contractor to lead the analysis, design and execution of a data migration from one Salesforce instance (source org) to another (target org), using Microsoft SQL Server as the staging and transformation layer.
You will own the end-to-end migration data workstream: profiling source data, mapping objects and fields, building transformation logic, loading and reconciling data, and supporting cutover.
This is a hands-on, delivery-focused role.
The right person will combine strong Salesforce data model knowledge with proven, real-world experience of moving data between orgs safely and accurately.
The role can be filled at Data Analyst or Data Architect level depending on the candidate’s experience; architect-level candidates will additionally be expected to shape the overall migration approach and standards.
Main Duties / Responsibilities
- Define and document the data migration approach, scope, and sequencing for moving data between Salesforce orgs, including cutover and rollback considerations.
- Analyse and profile source Salesforce data to assess volumes, quality, duplication, and dependencies across standard and custom objects.
- Produce object-level and field-level mapping documents between source and target orgs, covering data types, picklist values, record types, required fields, and validation rules.
- Design and maintain SQL Server staging databases and schemas to extract, cleanse, transform, and stage Salesforce data ahead of loading.
- Write, optimise, and test T-SQL (stored procedures, views, ETL logic) to implement transformation and data-cleansing rules.
- Manage the migration of parent/child relationships and record ownership, preserving referential integrity through ID cross-referencing (source ID to target ID) and correct load order.
- Extract and load data using appropriate tooling (e. g., Salesforce Data Loader, Bulk API, SSIS, Azure Data Factory, db Amp, or equivalent) and manage error handling and re-runs.
- Plan and run multiple migration cycles (development, test/UAT, and production dress rehearsals) and execute the production cutover.
- Design and run reconciliation and validation checks (record counts, field-level comparisons, sampling) and produce sign-off evidence for business stakeholders.
- Work with Salesforce administrators, developers, business analysts, and data owners to resolve data quality issues and agree transformation rules.
- Identify and manage migration risks and issues, including data volume limits, API limits, automation and trigger impacts, and sharing/ownership considerations.
- Ensure the handling of personal data complies with GDPR and internal data governance and security standards.
- Produce clear documentation and a handover pack (mapping specifications, scripts, runbooks, lessons learned) so the migration can be supported after your engagement ends.
Essential Skills & Qualifications
- Proven, hands-on experience delivering data migrations between Salesforce orgs or from other systems into Salesforce, ideally including at least one full production cutover.
- Strong working knowledge of the Salesforce data model, including standard objects (e. g., Account, Contact, Lead, Opportunity, Case, User) and custom objects, relationships (lookup and master-detail), record types, and field types.
- Strong SQL Server and T-SQL skills, including stored procedures, joins across large data sets, performance tuning, and data quality checks.
- Experience with data extraction and loading tools for Salesforce (e. g., Data Loader, Bulk API, SSIS, Azure Data Factory, Informatica, Talend, Boomi, db Amp, or similar).
- Solid experience in data profiling, cleansing, deduplication, and mapping, with a methodical approach to reconciliation and audit trails.
- Understanding of Salesforce migration considerations such as ownership and sharing, validation rules, triggers/flows, API limits, and managing record IDs across orgs.
- Awareness of data privacy requirements (e. g., GDPR) and secure handling of customer data.
- Excellent communication skills, with the ability to translate technical data concepts for business stakeholders and to work independently in a fast-paced delivery environment.
Desirable skillsets
- Salesforce certifications (e. g., Salesforce Certified Data Architecture and Management Designer, Administrator, or Platform App Builder).
- Experience with multi-org consolidation or Salesforce org merge/split projects.
- Experience with Salesforce Sales Cloud and/or Service Cloud in an automotive or retail environment.
- Familiarity with Salesforce attachments, files, and content migration (Content Version, Content Document Link).
- Experience using Power BI or similar tools to present reconciliation and migration progress reporting.
- Working knowledge of Agile delivery and tools such as Jira and Confluence.
- Be rewarded for your efforts
We believe people should be paid based on their performance so our pay and benefits reflect this and are designed to attract the very best talent.
We encourage everyone in our organisation to explore opportunities which enable them to grow their career through investment in their development but equally by working in a culture which fosters support and unbridled collaboration.
Keyloop doesn’t require academic qualifications for this position. We select based on experience and potential, not credentials.
Interim Data Migration Analyst (Salesforce, SQL) in Reading employer: Go Fractional
At Cambridge Spark, we pride ourselves on being an exceptional employer that values autonomy and expertise. As a Fractional CISO, you will enjoy the flexibility of remote work while contributing to a dynamic security strategy for our clients. Our culture fosters professional growth through independent advisory roles, ensuring you have the opportunity to make a significant impact in a supportive environment focused on delivering high-quality outcomes.
StudySmarter Expert Advice🤫
We think this is how you could land Interim Data Migration Analyst (Salesforce, SQL) in Reading
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Go Fractional!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Interim Data Migration Analyst (Salesforce, SQL) at Go Fractional.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Go Fractional.
✨Apply Directly through Our Website
When you find a suitable opening like Interim Data Migration Analyst (Salesforce, SQL) at Go Fractional, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Interim Data Migration Analyst (Salesforce, SQL) in Reading
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Go Fractional, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Go Fractional. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Go Fractional
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Go Fractional!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.