Lead Data Engineer

Lead Data Engineer

Anywhere

Type: Contract

Category: Engineer

Industry: Financial Services

Workplace Type: Remote

Reference : JN -

Date Posted: 02/02/2026

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

• 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 Data Stage 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 Data Stage 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.

• Expert-level experience designing and overseeing ETL workflows using IBM Data Stage.
• 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 work streams 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 Data Stage or ETL pipelines (preferred).

• Bachelor’s degree or equivalent experience.

Eliassen Group is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.