Data Engineer-DataStage

Encore Talent Solutions has partnered with a client in the Cincinnati, OH area to identify a Data Engineer on a contract need through 2026, including extensions/options to hire. This role will require FULL ONSITE WORK in the Cincinnati, OH area.

• Must be W2 eligible without any visa transfer/sponsorship restrictions
• C2C/1099 and 3rd party profiles will not be considered or reviewed at this time

Job Description

We are seeking a Senior Data Engineer to join our dynamic team. In this role, you will play a key part in executing end-to-end Salesforce data migrations.

You will collaborate with cross-functional teams and stakeholders to deliver high-quality solutions in a fast-paced environment.

Key Responsibilities

• 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.
• Profile source data; assess data quality issues; implement cleansing and standardization routines.
• Execute mock migration runs, capture error logs, perform root-cause analysis, and implement remediation steps.
• Perform final production data loads and verifications with business sign-off.
• Produce reconciliation reports to validate accuracy, completeness, and referential integrity post-migration.
• Author a comprehensive migration runbook covering workflows, schedules, controls, rollback, and support procedures.
• Implement quality checks, lineage notes, and audit artifacts aligned to governance and compliance requirements.
• Partner with Salesforce teams to respect object relationships, load order, and platform limits during migrations.
• Contribute to continuous improvement by optimizing ETL performance and automating repetitive validation tasks.

Required Qualifications:

• Proficiency in: IBM DataStage, SQL, Python.
• Relevant certifications: Bachelor’s degree in Computer Science, Information Systems, or equivalent practical experience.
• Strong problem-solving and analytical skills.
• Excellent communication and teamwork abilities.
• 7 years of data engineering experience, including 3 years building production ETL pipelines.
• 3 years of experience in ETL space.
• 3 years of proven experience with IBM DataStage.
• Business Intelligence - Systems/ETL.
• Demonstrated ability to perform data mapping, cleansing, deduplication, and validation.
• Working understanding of data governance, quality checks, lineage, and compliance.
• Experience optimizing ETL jobs and troubleshooting data load issues.

Preferred Qualifications

• Experience with: Python, Salesforce, Snowflake.
• Knowledge of the Salesforce data model (objects, relationships, metadata, constraints).
• Experience with Salesforce Data Loader or comparable migration tools.
• Familiarity with Snowflake or another cloud data warehouse for staging/landing zones.
• Exposure to CI/CD for scheduling and deploying DataStage jobs and Python scripts.
• Proficiency in Python (or similar scripting language) for data manipulation and automation.
• Prior delivery of at least one enterprise CRM or Salesforce migration is strongly preferred.

Work Environment & Location:

• Location: Onsite in Cincinnati.
• Collaborative team environment with opportunities for professional growth.