Data Engineer

Job Description

We are seeking a Senior Data Engineer to execute end to end Salesforce data migrations. Data will be moved from Snowflake to on premise systems to DataStage and then to Salesforce. This role focuses on source to target mapping, IBM DataStage–driven ETL development, data cleansing and validation, mock migration runs, cutover execution, and post load reconciliation. You will collaborate closely with Salesforce administrators, solution architects, product owners, and SMEs to deliver repeatable, auditable, and automation ready migration processes.

Key Responsibilities include :

• Develop source to target mapping specifications including field level transformations, deduplication logic, and validation rules.
• Build and configure ETL workflows using IBM DataStage, SQL, and Python to automate extraction, transformation, and loading into Salesforce.
• Provide source data assessment, data quality issues, implement cleansing and standardization routines.
• Support mock migration runs, capture error logs, perform root cause analysis, and implement remediation steps.
• Perform final migration including cutover activities with business sign off.
• Document data mapping rules, data lineage, quality completeness, and referential integrity checkpoints.
• Author a comprehensive migration runbook covering workflows, schedules, controls, rollback, and support processes.
• Apply migration governance, including quality checks aligned to governance and compliance requirements.
• Partner with Salesforce teams to inspect object relationships, loader jobs, and error remediation.
• Optimize ETL performance by improving ETL performance and automation.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity / affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and / or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy :

Required Skills & Experience

Nice to Have Skills & Experience

Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and / or other paid time off as provided by applicable law.