Data Migration Specialist
6 days ago
We're looking for a technically skilled Salesforce CRM Data Migration Specialist to drive complex data migration projects. In this critical role, you will actively execute the precise movement of data from diverse legacy sources directly into the Salesforce CRM and Health Cloud platform. Your expertise is vital for ensuring the accurate, compliant, and secure transfer of sensitive patient and clinical data. You'll leverage advanced SQL and SOQL query skills, proficiency with AWS cloud services, and a deep command of established Salesforce best practices to deliver flawless data integrity and client success.
What you will do
- 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.
- 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)
- Ability to travel up to 20% domestically to client sites as required.
- AWS Certified Cloud Practitioner or AWS Certified Solutions Architect - Associate
$60,000 - $80,000 a year
At Penrod, we believe in supporting our team members both professionally and personally. We offer a comprehensive benefits package designed to ensure your well-being and growth, including generous health, dental, and vision insurance, a 401(k) with company match to help you plan for the future, and ample paid time off for a healthy work-life balance. Beyond the standard, we're proud to provide opportunities for continuous learning and career development, fostering an environment where you can truly thrive and build a lasting career with us.
Our Benefits Package Includes:
• 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
Penrod is a healthcare and life sciences consulting company that empowers exceptional experiences by engaging and consulting on technology and enabling digital transformation. Founded in 2011, a Summit Salesforce Partner since 2016, and HIPAA compliance accredited, Penrod has helped hundreds of companies ranging from startup to the Fortune 500; from pre-FDA approval to full commercialization; from specialty clinic to major healthcare system; improve their own patient experiences and implement technology to meet the challenges of the industry as they continue to evolve.
Penrod is an equal opportunity employer. Penrod does not discriminate against any employee or applicant because of race, religion, sex, sexual orientation, age, national origin, ancestry, disability, arrest or conviction record, marital status, military service or any other characteristic protected by applicable local, state or federal law and reasonably accommodates applicants and employees as required by applicable law.
-
Milwaukee, WI, United States INSPYR Solutions Full timeOverview We are looking for a motivated Junior Project Manager to support a large-scale AWS-to-AWS cloud migration initiative. This role will focus on coordinating the migration of VPCs across AWS accounts, ensuring schedules, deliverables, and communications are properly managed. The Junior PM will work closely with senior engineers, architects, and...
-
Junior Project Manager AWS Cloud Migration Project
20 hours ago
Milwaukee, WI, United States INSPYR Solutions Full timeOverview We are looking for a motivated Junior Project Manager to support a large-scale AWS-to-AWS cloud migration initiative. This role will focus on coordinating the migration of VPCs across AWS accounts, ensuring schedules, deliverables, and communications are properly managed. The Junior PM will work closely with senior engineers, architects, and...
-
Milwaukee, WI, United States INSPYR Solutions Full timeOverview We are looking for a motivated Junior Project Manager to support a large-scale AWS-to-AWS cloud migration initiative. This role will focus on coordinating the migration of VPCs across AWS accounts, ensuring schedules, deliverables, and communications are properly managed. The Junior PM will work closely with senior engineers, architects, and...
-
Milwaukee, WI, United States INSPYR Solutions Full timeOverview We are looking for a motivated Junior Project Manager to support a large-scale AWS-to-AWS cloud migration initiative. This role will focus on coordinating the migration of VPCs across AWS accounts, ensuring schedules, deliverables, and communications are properly managed. The Junior PM will work closely with senior engineers, architects, and...
-
Milwaukee, WI, United States INSPYR Solutions Full timeOverview We are looking for a motivated Junior Project Manager to support a large-scale AWS-to-AWS cloud migration initiative. This role will focus on coordinating the migration of VPCs across AWS accounts, ensuring schedules, deliverables, and communications are properly managed. The Junior PM will work closely with senior engineers, architects, and...
-
Milwaukee, WI, United States INSPYR Solutions Full timeOverview We are looking for a motivated Junior Project Manager to support a large-scale AWS-to-AWS cloud migration initiative. This role will focus on coordinating the migration of VPCs across AWS accounts, ensuring schedules, deliverables, and communications are properly managed. The Junior PM will work closely with senior engineers, architects, and...
-
Milwaukee, WI, United States INSPYR Solutions Full timeOverview We are looking for a motivated Junior Project Manager to support a large-scale AWS-to-AWS cloud migration initiative. This role will focus on coordinating the migration of VPCs across AWS accounts, ensuring schedules, deliverables, and communications are properly managed. The Junior PM will work closely with senior engineers, architects, and...
-
Milwaukee, WI, United States INSPYR Solutions Full timeOverview We are looking for a motivated Junior Project Manager to support a large-scale AWS-to-AWS cloud migration initiative. This role will focus on coordinating the migration of VPCs across AWS accounts, ensuring schedules, deliverables, and communications are properly managed. The Junior PM will work closely with senior engineers, architects, and...
-
Milwaukee, WI, United States INSPYR Solutions Full timeOverview We are looking for a motivated Junior Project Manager to support a large-scale AWS-to-AWS cloud migration initiative. This role will focus on coordinating the migration of VPCs across AWS accounts, ensuring schedules, deliverables, and communications are properly managed. The Junior PM will work closely with senior engineers, architects, and...
-
Milwaukee, WI, United States INSPYR Solutions Full timeOverview We are looking for a motivated Junior Project Manager to support a large-scale AWS-to-AWS cloud migration initiative. This role will focus on coordinating the migration of VPCs across AWS accounts, ensuring schedules, deliverables, and communications are properly managed. The Junior PM will work closely with senior engineers, architects, and...
