Data Migration Specialist – Salesforce

Job not on LinkedIn

November 4

🧀 Wisconsin – Remote

Although this job is listed in Wisconsin, this company may be open to hiring remote in other states.

💵 $60k - $80k / year

⏰ Full Time

🟢 Junior

🟡 Mid-level

🚰 Data Engineer

🚫👨‍🎓 No degree required

Apply Now

Receive Emails with Similar Jobs

Penrod

WebsiteLinkedInAll Job Openings

Healthcare Insurance • SaaS • Enterprise

Penrod is a leading Salesforce implementation, advisory, and managed services partner that specializes in the healthcare and life sciences sectors. They provide tailored solutions using Salesforce products such as Health Cloud, Sales Cloud, Experience Cloud, and more to help healthcare providers, medical device companies, pharmaceuticals, and insurance companies enhance their customer engagement and streamline business processes. Penrod is recognized for solving complex healthcare challenges with Salesforce, making them a trusted partner for providers, medtech, pharma, and laboratories. With a strong focus on healthcare, Penrod aims to deliver exceptional experiences through robust and custom Salesforce solutions. Their expertise is proven across the entire care ecosystem.

51 - 200 employees

⚕️ Healthcare Insurance

☁️ SaaS

🏢 Enterprise

💰 Venture Round on 2022-02

📋 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!