Data Engineer - DataStage ETL IV

Job#: 3020780

Job Description:

Job Title: Data Eng.- DataStage ETL IV

Location: Remote (EST)

Pay Range: $87-$94

Length: 8 Months

Job Summary

The Lead Data Engineer will provide technical leadership and execution oversight for complex, enterprise-scale Salesforce data migration initiatives. This role is responsible for guiding solution design, ensuring quality and compliance, and directing all phases of the migration lifecycle-from data profiling and mapping through extraction, transformation, validation, mock runs, cutover, and reconciliation.

The position requires close collaboration with Salesforce architects, business subject-matter experts, DataStage developers, enterprise data teams, and project leadership to ensure migrations are accurate, scalable, repeatable, and fully documented. This is a hands-on leadership role that involves designing, reviewing, troubleshooting, and building key components while supporting and guiding other engineers.

Key Responsibilities

Technical Leadership & Ownership

• Lead 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 decision-maker for mapping logic, transformation patterns, validation strategies, and DataStage/Python ETL design.
• Review, guide, and approve mapping documents, data cleansing rules, and ETL workflows produced by engineering team members.

Execution Leadership

• Oversee all migration phases: profiling, mapping, extraction, transformation, cleansing, mock runs, remediation, final load, and post-load reconciliation.
• Develop reusable migration templates, including mapping patterns, validation scripts, transformation libraries, and reconciliation frameworks.
• Troubleshoot complex DataStage ETL issues, load failures, and Salesforce API limitations.

Cross-Team Coordination

• Collaborate with Salesforce architects to define object load order, relationship handling, and platform constraints.
• Work with business SMEs to validate mapping logic, resolve data issues, and approve reconciliation results.
• Coordinate with Salesforce, infrastructure, release management, and governance teams to align dependencies and cutover activities.

Quality, Governance & Controls

• Establish and enforce data validation rules, data-quality thresholds, rejection criteria, and reconciliation metrics.
• Ensure adherence to metadata, lineage, audit, and regulatory requirements.
• Lead defect-management processes during mock runs and ensure timely root-cause resolution.

Documentation & Repeatability

• Oversee and approve the migration runbook, including workflows, controls, schedules, rollback strategies, and support procedures.
• Ensure comprehensive documentation of mappings, transformation rules, cleansing logic, and validation designs.

Mentorship & Team Leadership

• Mentor DataStage developers, senior engineers, and analysts on transformation logic, debugging, and migration best practices.
• Lead technical reviews and provide coaching to strengthen team capability and consistency.

Critical Deliverables

• Approved end-to-end migration solution design, including mapping strategy, transformation patterns, and load sequencing.
• Final sign-off on:
  • Source-to-target mappings
  • Transformation logic
  • Cleansing and validation rules
  • Data extraction frameworks
  • ETL designs (DataStage/Python)
• Oversight and acceptance of three mock migration cycles.
• Decision authority for defect triage and remediation.
• Leadership of final production load and verification.
• Post-migration reconciliation and executive-level reporting.
• Completed and approved migration runbook suitable for audit or reuse.

Required Skills

Core Technical Expertise

• Expert-level experience designing and managing ETL workflows using IBM DataStage.
• Advanced SQL skills, including performance tuning, complex joins, windowing, and optimization for large datasets.
• Strong Python capabilities for automation, validation scripting, data corrections, and transformation logic.
• Extensive experience with mapping, cleansing, deduplication, validation, and reconciliation of large datasets.
• Strong understanding of data governance, including data-quality rules, lineage, controls, and audit requirements.

Salesforce Migration Expertise

• Strong knowledge of the Salesforce data model, including objects, relationships, lookups, constraints, and metadata.
• Experience leading migrations using Data Loader, Bulk API, or similar Salesforce ingestion tools.
• Experience designing load-ordering strategies and resolving hierarchical or relational dependencies.

Leadership & Delivery

• Demonstrated experience leading data migration workstreams or teams.
• Ability to drive technical decisions and mentor engineering staff.
• Strong communication skills and ability to align stakeholders.

Nice to Have

• Experience with nCino.
• Experience with cloud data platforms (Snowflake, Azure, AWS) for staging or preprocessing.
• Familiarity with CI/CD practices for DataStage or ETL pipeline scheduling.
• Experience with data migrations in banking, regulatory, or compliance-driven environments.

Qualifications

• Bachelor's degree or equivalent experience.
• 10+ years of experience in data engineering, including 3+ years in technical leadership roles.
• Successful delivery of at least one large-scale Salesforce or enterprise CRM migration.

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or .

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico. Apex uses a virtual recruiter as part of the application process. Click for more details.

Apex Benefits Overview: Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our 'Welcome Packet' as well, which an Apex team member can provide.