Lead Data Engineer

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. 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 support fairness, efficiency, and consistency, and Eliassen Group takes measures to prevent bias or discrimination in connection with its hiring practices. By proceeding, you acknowledge, agree, and consent to Eliassen Group’s use of these tools, including AI tools, as part of the application and hiring process. Skills, experience, and other compensable factors will be considered when determining pay rate. The pay range provided in this posting reflects a W2 hourly rate; other employment options may be available that may result in pay outside of the provided range. W2 employees of Eliassen Group who are regularly scheduled to work 30 or more hours per week are eligible for the following benefits: medical (choice of 3 plans), dental, vision, pre-tax accounts, other voluntary benefits including life and disability insurance, 401(k) with match, and sick time if required by law in the worked-in state/locality. Please be advised- If anyone reaches out to you about an open position connected with Eliassen Group, please confirm that they have an Eliassen.com email address and never provide personal or financial information to anyone who is not clearly associated with Eliassen Group. If you have any indication of fraudulent activity, please contact InfoSec@eliassen.com. Job ID: JN -022026-105333