Penrod · 1 month ago
Data Migration Specialist - Salesforce
Milwaukee, WI
Full-time
Hybrid
Entry, Mid Level
$60K/yr - $80K/yr
2+ years expPenrod is a healthcare and life sciences consulting company that empowers exceptional experiences by engaging and consulting on technology and enabling digital transformation. They are seeking a technically skilled Salesforce CRM Data Migration Specialist to drive complex data migration projects, ensuring accurate and compliant transfer of sensitive patient and clinical data into the Salesforce platform. The role involves executing data migration phases, optimizing SQL queries, and collaborating with data architects to maintain data integrity and security.
ConsultingInformation ServicesInformation TechnologyLead GenerationSaaSSales AutomationSoftware
Responsibilities
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
Qualification
Required
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
Preferred
Salesforce Certified Developer or Administrator (preferred)
AWS Certified Cloud Practitioner or AWS Certified Solutions Architect – Associate
Ability to travel up to 20% domestically to client sites as required
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!
Company
Penrod
Penrod develops and offers Salesforce.com solutions and consulting services.
51-200 employees
H1B Sponsorship
Penrod has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2024 (1)
Funding
Current Stage
Growth StageTotal Funding
$8M2022-02-03Series Unknown· $8M
Leadership Team
Brandon Alberti
Director Of Business Development, Healthcare and Life Sciences
Recent News
promontorypointcapital.com
2024-12-02
Company data provided by crunchbase