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 and Senior 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 – Associate Benefits: • 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