Skip to content

Open nowPosted 10 hours ago

Data Migration Analyst (Salesforce, SQL) - Fixed Term Contract

keyloop57 open roles

Where
UK (Reading)
Work mode
Hybrid
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowData Migration Analyst (Salesforce, SQL) - Fixed Term Contractkeyloop · UK (Reading)
  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on keyloop's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

7.7% of postings close within 7 days. Measured by our own scanner across the market. keyloop postings stay open a median of 2 days.

Share of postings closed within
  1. 1.6%1 day
  2. 3.3%3 days
  3. 7.7%7 days
  4. 14.0%14 days
  5. 33.7%30 days
This job: posted 10 hours ago

keyloop median: 2 days open

The posting

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, dbAmp, 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, dbAmp, 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 (ContentVersion, ContentDocumentLink).
  • 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."

From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against keyloop's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.
  3. We apply on keyloop's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.
  4. Every reply, sorted

    keyloop's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.
  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

By hand5–10
With CV Rocket100
applications a day

Nearby

Live postings like this one

Same employer first, then the same role elsewhere.

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.