Lead Data Engineer

Remote • Posted 22 days ago • Updated 9 hours ago

Contract W2

Remote

Eliassen Group

Fitment

Dice Job Match Score™

🫥 Flibbertigibetting...

Job Details

Skills

Network
SAP BASIS
Life Insurance
Technical Drafting
Data Quality
Data Cleansing
Extraction
Release Management
Data Validation
Defect Management
ROOT
Debugging
Management
Workflow
SQL
Performance Tuning
Optimization
Python
Scripting
Mapping
Data Deduplication
Data Governance
Auditing
Data Modeling
Meta-data Management
Migration
API
Salesforce.com
Mentorship
Communication
Banking
Data Migration
Cloud Computing
Snow Flake Schema
Microsoft Azure
Amazon Web Services
Continuous Integration
Continuous Delivery
Scheduling
IBM InfoSphere DataStage
Datastage
Extract
Transform
Load
Screening
Artificial Intelligence
Recruiting
Taxes
Insurance
Law
Management Consulting
Finance
Regulatory Compliance

Summary

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 (, ) 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 .

About Eliassen Group:

Eliassen Group is a leading strategic consulting company for human-powered solutions. For over 30 years, Eliassen has helped thousands of companies reach further and achieve more with their technology solutions, financial, risk & compliance, and advisory solutions, and clinical solutions. With offices from coast to coast and throughout Europe, Eliassen provides a local community presence, balanced with international reach. Eliassen Group strives to positively impact the lives of their employees, clients, consultants, and the communities in which they operate.

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.

Don't miss out on our referral program! If we hire a candidate that you refer us to then you can be eligible for a $1,000 referral check!

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: cxelisen
Position Id: a1WUQ000001GT772AG
Posted 22 days ago

Company Info

About Eliassen Group

Eliassen Group is a leading strategic consulting company that provides business and IT services for our clients as they seek to transform and execute strategies that will drive exceptional outcomes. Leveraging over 30 years of success, we focus on professional services, talent solutions, and life sciences. Eliassen Group offers local community presence and deep networks. We are committed to positively impacting the lives of our employees, clients, consultants, and the communities in which we operate.

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.

Go to company profile

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Data Engineer

Westlake, Texas

•

Today

Description: Hybrid Every Other Week onsite in Westlake, TX Our client is a leading U.S. financial services organization serving individuals and institutions with a broad portfolio of investment products and technology-driven solutions. Headquartered in Boston with major hubs across the U.S., the company operates at scale and invests in innovation across enterprise infrastructure, data, and customer platforms. Due to client requirements, applicants must be willing and able to work on a w2 bas

Contract

Senior PeopleSoft Developer

Hanover, New Jersey

•

Today

Description: Hybrid ideally 2-4 days a week onsite in Whippany, NJ. Hybrids is flexible, ie: 2 days a week or 1 week on 2 weeks off. The organization is transitioning from legacy PeopleSoft 9.1 to a modern enterprise platform and requires a seasoned developer to drive data conversion, SQR development, and synchronization through Component Interface while ensuring data integrity across phased migrations. We can facilitate w2 and corp-to-corp consultants. For our w2 consultants, we offer a gre

Contract

Tooling & Traceability Lead

Remote or Almont, Colorado

•

Today

Description: Remote The Tooling & Traceability Lead will implement system configurations, traceability structures, and performance instrumentation to make portfolio governance visible and sustainable. The role aligns Jira and Azure DevOps to the operating model, establishes data standards for reliable reporting, and produces executive-ready dashboards tied to governance cadence. The lead partners with portfolio and product leaders to translate governance requirements into practical configurati

Full-time

Senior Data Analyst (SQL, ETL, DevOps Engineering)

North Carolina

•

Today

Description: Hybrid every other week onsite/5 days in Merrimack, NH Our client is seeking a Data Engineer to join a collaborative team focused on providing solutions for financial professionals The role centers on analyzing and building robust ETL pipelines, leveraging AWS cloud services, and delivering high-quality data assets that enable decision-making across the organization. We are seeking a highly skilled Senior Data Analyst to join our team and play a pivotal role in the Agile developm

Contract

Search all similar jobs