Salesforce Data Migration Specialist

About Us :

Kelley Austin takes a different approach to Salesforce Consulting by putting our employees first. That's not hyperbole, either. Our team takes a proactive approach to employee satisfaction by having every single person fill out a "happiness list," which comprises the top ten things each employee finds happiness in outside of work. We review those happiness lists regularly to ensure everyone is checking most of the boxes and adjust their project load, responsibilities, or schedule accordingly if not. Look at our benefits and perks below to learn more about our culture. We're growing fast (more than doubling YOY) but staying diligent in hiring the best possible people who don't just want a job, but will actually care about the success of their co-workers and clients. Our growth, coupled with the distinction of being recognized as the 'fastest Salesforce Implementation Partner to achieve Platinum / Summit status,' attests to the success of our approach. Take a look at the 'About You' and 'Responsibilities' below to learn more.

Benefits :

• Base Salary
• Work From Home Flexibility
• Flexible PTO (we treat people like adults here)
• Paid Holidays (including an entire week off around Christmas and New Year)

Tools We Use :

• As a technology software consulting company, we use many tools, but the big four are Google Drive, Slack, Lucid Chart, and Salesforce, of course.

Perks Of The Job :

• You won't really find egos here. We hire slowly and purposefully to keep our culture strong and our team cohesive.
• We don't say yes to every client and are not afraid to part ways with a client, either. If there's no mutual respect or success involved, we politely decline and help them find a different partner. That means fewer 'tough' clients and more clients who "get it" and work harmoniously together.
• We offer half a dozen different clubs like book club, health club, movie club, hobby club, and more. These bring people together to grow intellectually and get to know one another outside of project work.
• We work an average of 40 hours per week (I know, that's unheard of in consulting, but we stand by it).

About You :

We are seeking a Data Migration Specialist with deep hands-on expertise in Salesforce, Salesforce SOQL, Salesforce APEX, relational databases, SQL, scripting, and large-scale data migration. This role is highly execution-focused and detail-oriented — you will be designing and running ETL processes, writing queries and scripts, validating data quality, and ensuring successful end-to-end migrations between enterprise systems.

• Plan, execute, and manage end-to-end data migration projects, including extraction, transformation, loading, and validation.
• Write and optimize complex SQL and SOQL queries for data validation, migration, and reconciliation.
• Build, configure, and run ETL jobs to move and transform data across Salesforce, ERP, and external databases.
• Develop and maintain automation scripts (APEX, Python, Shell, PowerShell, or similar) for data processing, cleansing, and quality checks.
• Perform data profiling, mapping, and transformation to meet business and technical requirements.
• Troubleshoot and resolve migration issues such as data mismatches, performance bottlenecks, and integrity errors.
• Collaborate with internal and external Salesforce, integration, and business teams to coordinate cutovers and validate migrated data.
• Document migration procedures, scripts, mappings, and reconciliation steps for repeatability and compliance.
• Ensure all migrations follow best practices for data quality, security, and governance.

Required Technical and Professional Expertise

• Bachelor's degree in Computer Science, Information Systems, or related field (or equivalent hands-on experience).
• 5+ years of direct experience in data migration, ETL, or database engineering roles.
• Strong technical expertise in relational databases (Salesforce, Oracle, SQL Server, or similar).
• Advanced proficiency in SQL (query optimization, joins, stored procedures).
• Practical experience with Salesforce SOQL, APEX, and Salesforce data model.
• Proven track record in data migration projects, including reconciliation and cutover planning.
• Hands-on scripting skills in Python, Shell, PowerShell, or similar.
• Familiarity with ETL tools, APIs, and bulk data processing.
• Experience with cloud platforms (AWS, Azure, or GCP) is a plus.
• Strong analytical skills, attention to detail, and ability to deliver under tight deadlines.

NOTE: Kelley Austin will not be able to sponsor applicants for work visas.