Data Migration Specialist – Salesforce

Job Description:• Execute and validate specific phases of the data migration lifecycle, including data extraction, transformation, and loading (ETL/ELT). • Build and optimize complex SQL queries for manipulating, cleansing, and transforming large datasets from source systems. • Develop and manage efficient SOQL queries to extract, update, and validate data within the Salesforce environment. • Work hands-on with AWS data services (e.g., S3, Glue, Lambda) to stage, process, and prepare data for ingestion.• Utilize Salesforce integration tools, such as the Data Loader and Bulk API, to efficiently load data into Health Cloud objects. • Collaborate with Data Architects andSenior Engineers on the development of data mapping documents from legacy models to the Salesforce Health Cloud data model. • Assist in performing data profiling, cleansing routines, and reconciliation activities. • Support rigorous testing efforts, including unit testing and User Acceptance Testing (UAT), to ensure data integrity and accuracy post-migration.• Strictly adhere to protocols ensuring data handling and security comply with HIPAA and other relevant healthcare privacy regulations. • Troubleshoot data integrity issues and optimize ETL performance under supervision. Requirements:• 2–3 years of practical experience in data engineering, ETL, or dedicated data migration, with exposure to the Salesforce platform. • Solid foundational knowledge of Salesforce Administration. • Understanding of the standard Salesforce data model (objects, field types, relationships).• Proven ability to write, debug, and optimize complex SQL queries. • Experience in writing and managing SOQL queries for data interaction within Salesforce. • Familiarity with the Salesforce Health Cloud data model and common standard objects. • Hands-on proficiency with Salesforce Data Loader & Workbench• Advanced Excel/Google Sheets data manipulation skills (e.g., pivot tables, text-to-columns, VLOOKUP, cleaning functions). • Basic understanding of ELT principles and tools (e.g., MuleSoft, Talend, or Python scripting).• Comfortable managing user access, profiles, and permission sets• Experience working with AWS services (S3, RDS, or Glue) in a data environment. • Exposure to the Healthcare industry and an awareness of sensitive data, PHI, and HIPAA requirements. • Strong analytical skills and a dedication to detail and accuracy. • Meticulous Attention to Detail in tracking data quality and accuracy. • Process-Oriented, with the ability to follow a multi-step data migration checklist accurately. • Eager to learn complex ETL processes and advanced SQL / SOQL from senior team members• Salesforce Certified Developer or Administrator (preferred)• AWS Certified Cloud Practitioner or AWS Certified Solutions Architect – AssociateBenefits:• 100% employer-paid medical, dental, and vision premiums for eligible employees• Employer-paid short-term disability• Unlimited PTO• Volunteer Time Off• 10 company holidays• 401k + 4% Company Match + No Vesting Period• Monthly wellness and phone stipends• Training cost coverage• Paid parental leave for birthing and non-birthing parents• Annual company get-together — Penrod Palooza!Apply tot his job