Lead Data Engineer

Lead Data Engineer

Anywhere

Type: Contract

Category: Engineer

Industry: Financial Services

Workplace Type: Remote

Reference ID: JN -022026-105333

Date Posted: 03/04/2026

Shortcut: http://careers.eliassen.com/9Ppqv8

• Description
• Recommended Jobs

Description

Remote

Our client is a leading U.S. financial institution headquartered in Cincinnati, Ohio, operating an extensive branch and ATM network across multiple states. The organization is a Fortune 500 company and one of the largest banks in the United States, with a history dating back to the early twentieth century.

Due to client requirements, applicants must be willing and able to work on a w2 basis. For our w2 consultants, we offer a great benefits package that includes Medical, Dental, and Vision benefits, 401k with company matching, and life insurance.

Rate: $85.00 to $95.00/hr. w2

Responsibilities

• Own the end-to-end technical design of Salesforce migration pipelines, including load strategy, dependency sequencing, staging architecture, and data quality controls.
• Serve as the primary technical decision-maker for mapping logic, transformation patterns, validation strategies, and DataStage or Python ETL design.
• Provide guidance, reviews, and sign-off on mapping documents, data cleansing rules, and ETL workflows produced by engineers.
• Oversee and coordinate profiling, mapping, extraction, transformation, cleansing, mock runs, remediation, final load, and post-load reconciliation.
• Lead the creation of repeatable migration templates including mapping patterns, validation scripts, transformation libraries, and reconciliation frameworks.
• Troubleshoot complex DataStage ETL issues, load failures, and Salesforce API constraints.
• Partner with Salesforce architects on object load order, relationship handling, and platform constraints.
• Work with business SMEs to validate mapping logic, resolve data issues, and approve reconciliation reports.
• Coordinate across Salesforce, infrastructure, release management, and governance teams to align dependencies and cutover planning.
• Define and enforce data validation rules, DQ acceptance thresholds, rejection criteria, and reconciliation metrics.
• Ensure compliance with metadata, lineage, audit, and regulatory standards.
• Drive defect management for mock runs and ensure timely root-cause resolution.
• Oversee and approve the migration runbook, including workflows, controls, schedules, rollback strategies, and support procedures.
• Mentor developers and analysts on transformation logic, debugging, and best practices in migration engineering.
• Provide decision authority on defect triage and remediation and lead final production load execution and verification.

Experience Requirements:

• Expert-level experience designing and overseeing ETL workflows using IBM DataStage.
• Advanced SQL skills including performance tuning, complex joins, windowing, and large-volume optimization.
• Strong Python skills for automation, validation scripting, data corrections, and transformation logic.
• Deep experience with mapping, cleansing, deduplication, validation, and reconciliation for large datasets.
• Strong command of data governance including DQ rules, lineage, controls, and audit requirements.
• Strong understanding of the Salesforce data model including objects, relationships, lookups, constraints, and metadata.
• Experience leading migrations using Data Loader, Bulk API, or other Salesforce ingestion tooling.
• Experience designing load ordering strategies and resolving hierarchical or relational dependencies.
• Proven experience leading data migration workstreams or teams.
• Ability to drive technical decisions and mentor engineers.
• Strong communication and stakeholder alignment skills.
• Experience in banking, regulatory, or compliance-driven data migrations (preferred).
• Experience with nCino (preferred).
• Experience with cloud data platforms such as Snowflake, Azure, or AWS for staging or pre-processing (preferred).
• Familiarity with CI/CD for scheduling DataStage or ETL pipelines (preferred).

Education Requirements:

• Bachelor’s degree or equivalent experience.

Recruitment Transparency Notice

Eliassen Group values transparency in our recruitment practices. Please be advised that Eliassen Group utilizes artificial intelligence (AI) tools as part of its initial application screening process. You may receive email and SMS notifications from the Eliassen Virtual Recruiting Team ( noreply@eliassen.com , 781-808-2924) inviting you to complete a brief voice screening as part of your application process. These tools assist our hiring teams in different ways, including but not limited to, assistance in reviewing application materials to help identify candidates whose qualifications most closely match the requirements of the position. All AI-assisted evaluations and responses are reviewed by human recruiters before any hiring decisions are made. The use of AI in our process is intended to suppor