Data Migration Analyst (Salesforce, SQL) - Contractor in Reading

Data Migration Analyst (Salesforce, SQL) - Contractor in Reading

Reading Temporary On-site
K

At a Glance

  • Tasks: Lead data migration projects using Salesforce and SQL, ensuring accuracy and efficiency.
  • Company: Join Keyloop, a leader in automotive tech innovation.
  • Benefits: Competitive pay, flexible work options, and growth opportunities.
  • Other info: Inclusive culture that values diversity and supports career development.
  • Why this job: Be part of a transformative journey in the automotive industry with cutting-edge technology.
  • Qualifications: Experience in Salesforce data migrations and strong SQL skills required.

Keyloop bridges the gap between dealers, manufacturers, technology suppliers and car buyers.

We empower car dealers and manufacturers to fully embrace digital transformation.

How?

By creating innovative technology that makes selling cars better for our customers, and buying and owning cars better for theirs.

We use cutting-edge technology to link our clients’ systems, departments and sites.

We provide an open technology platform that’s shaping the industry for the future.

We use data to help clients become more efficient, increase profitability and give more customers an amazing experience.

Want to be part of it?

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.

Why join us?

We’re on a journey to become market leaders in our space – and with that comes some incredible opportunities.

Collaborate and learn from industry experts from all over the globe.

Work with game-changing products and services.

Get the training and support you need to try new things, adapt to quick changes and explore different paths.

Join Keyloop and progress your career, your way.

An inclusive environment to thrive

We’re committed to fostering an inclusive work environment.

One that respects all dimensions of diversity.

We promote an inclusive culture within our business, and we celebrate different employees and lifestyles – not just on key days, but every day.

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.

We are also an equal opportunity employer committed to building a diverse and inclusive workforce. We value diversity and encourage candidates of all backgrounds to apply.

"At Keyloop, AI is a daily ally: We encourage and train every employee to use our AI tools to boost their creativity and productivity."

Data Migration Analyst (Salesforce, SQL) - Contractor in Reading employer: Keyloop

At Keyloop, we pride ourselves on being an exceptional employer that champions innovation and inclusivity. Our collaborative work culture fosters personal and professional growth, allowing you to thrive while working with cutting-edge technology in the automotive industry. With a commitment to rewarding performance and providing opportunities for career advancement, joining our team means being part of a forward-thinking company that values diversity and empowers employees to explore their potential.

K

Contact Details:

Keyloop Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land Data Migration Analyst (Salesforce, SQL) - Contractor in Reading

✨Tap into Online Data Science Communities

Join online communities focused on data science like Kaggle, LinkedIn groups, or Reddit threads. These are goldmines for temporary gigs, as you can network with professionals and potentially hear about opportunities at companies like Keyloop before they're even advertised!

✨Show Off Your Skills With Projects

Got some cool data science projects? Showcase them on platforms like GitHub or create a personal portfolio website. This visibility is crucial for landing temporary roles—let recruiters see your actual skills in action, which can set you apart from the crowd.

✨Check Out Specialist Job Boards

For temp roles, hit up job boards dedicated to tech and data science, like Stack Overflow Jobs or DataJobs. These platforms often feature openings that you won’t find on general job sites, including contracts with companies like Keyloop.

✨Leverage University Resources

If you're currently at uni or recently graduated, tap into your school's career services. They often have connections with companies looking for temporary data science interns or contract workers, and they might even host job fairs with employers like Keyloop.

We think you need these skills to ace Data Migration Analyst (Salesforce, SQL) - Contractor in Reading

Salesforce Data Model Knowledge
Data Migration Experience
Microsoft SQL Server
T-SQL Proficiency
Data Extraction and Loading Tools
Data Profiling and Cleansing
Mapping and Reconciliation Skills

Some tips for your application 🫡

Highlight Your Data Projects:When applying for a temporary data science role at Keyloop, make sure to showcase any relevant projects you've worked on. Whether it's a personal project, an academic undertaking, or contributions to an open-source initiative, detailing these experiences can really set you apart and demonstrate your practical skills.

Emphasise Your Analytical Skills:In your CV and cover letter, focus on the specific analytical skills that are key to data science. Mention any experience with statistical tools, programming languages like Python or R, and data visualisation software. Don't forget to include any certifications that may bolster your expertise!

Show Your Flexibility:Since this is a temporary role, it's important to convey your adaptability and willingness to learn. In your cover letter to Keyloop, emphasise how quickly you can get up to speed with new tools or projects. Highlight any previous experiences where you've had to adjust to new environments or challenges.

Craft a Unique Data-Driven Cover Letter:Instead of the usual generic cover letter, spice it up with some data! Maybe you’ve improved a process by 20% in a past role or cleaned a dataset with over a million entries. Use these stats to your advantage to grab Keyloop’s attention and show the tangible impact of your work.

How to prepare for a job interview at Keyloop

✨Showcase Your Analytical Skills

For a data science gig, it's crucial to demonstrate your analytical abilities. Be ready to discuss previous projects and the methodologies you used. Think about how you can quantify your impact—did your analysis improve efficiency or save costs? These are the stories that will stick with interviewers at Keyloop.

✨Brush Up on Technical Skills

You might face technical questions on tools relevant to data science, like Python, R, or SQL. Prepare to solve a problem live—perhaps they'll ask you to write a simple query or code snippet. It’s cool to talk about them, but we need to show we can do it in practice, especially in a temporary role where quick results matter.

✨Highlight Your Adaptability

Since this is a temporary position, emphasise your ability to learn quickly and adapt to new tools or workflows. Share examples of how you've thrived in fast-paced environments before, and how you can hit the ground running at Keyloop.

✨Prepare a Portfolio of Your Work

Bring your portfolio to the table—showcase projects where you've leveraged data science techniques to solve problems. Whether it’s a GitHub repository or a set of case studies, having tangible examples of your work will help you stand out and show what you bring to the team at Keyloop.