NEWPosted 5 hours ago

Job ID: JOB_ID_8628

Job Description:

The Data Engineer will be part of the datastore-migration Factory team responsible for the end-to-end datastore migration from on-prem DataLake to AWS hosted LakeHouse. This is a high visibility and crucial project for Goldman Sachs.

Responsibilities:

  • Pipeline Migration: Refactoring and migrating extraction logic and job scheduling from legacy frameworks to the new Lakehouse environment. Executing the physical migration of underlying datasets while ensuring data integrity. Acting as a technical liaison to internal clients, facilitating “handoff and sign-off” conversations with data owners to ensure migrated assets meet business requirements.
  • Consumption Pattern Migration: Translating and optimizing legacy SQL and Spark-based consumption patterns (raw and modeled) for compatibility with Snowflake and Iceberg. Understanding usage patterns to deliver the required data products. Acting as a technical liaison to internal clients, facilitating “handoff and sign-off” conversations with data owners to ensure migrated assets meet business requirements.
  • Data Reconciliation & Quality: A rigorous approach to data validation is required. Candidates must work with reconciliation frameworks to build confidence that migrated data is functionally equivalent to that already used within production flows. The engineer will also need to work with other internal data management platforms and must have an aptitude for learning new workflows and language constructs, as necessary.

Technical Skills:

  • Basic Qualifications:
    • Education: Bachelors or masters degree in computer science, Applied Mathematics, Engineering, or a related quantitative field.
    • Experience: Minimum of 3-5 years of professional “hands-on-keyboard” coding experience in a collaborative, team-based environment. Ability to troubleshoot (SQL) and basic scripting experience.
    • Languages: Professional proficiency in Python or Java.
    • Methodology: Deep familiarity with the full Software Development Life Cycle (SDLC) and CI/CD best practices & K8s deployment experience.
  • Core Data Engineering Competencies: Demonstrates a sophisticated understanding of the following modeling concepts to ensure data correctness during reconciliation:
    • Temporal Data Modeling: Managing state changes over time (e.g., SCD Type 2).
    • Schema Management: Expertise in Schema Evolution (Ref: Iceberg Apache) and enforcement strategies.
    • Performance Optimization: Advanced knowledge of data partitioning and clustering.
    • Architectural Theory: Balancing Normalization vs. Denormalization and the strategic use of Natural vs. Surrogate Keys.
  • Technical Stack Requirements: While candidates are not expected to be experts in every tool, the collective team must cover the following technologies:
    • Extraction & Logic: Kafka, ANSI SQL, FTP, Apache Spark
    • Data Formats: JSON, Avro, Parquet

Core Competencies:

  • Demonstrates strong integrity and consistently models good conduct and ethical decision-making.
  • Acts as a trusted team player who collaborates effectively across multiple teams and functions.
  • Communicates with clarity and confidence – concise written updates, structured verbal briefings, and proactive stakeholder management.
  • Works effectively with global teams across time zones and cultures; builds alignment and resolves issues constructively.
  • Delivery-focused with a strong sense of ownership; drives work to closure and meets commitments.
  • Brings high energy and urgency to achieve targets while maintaining quality and professionalism.
  • Shows intellectual curiosity; asks thoughtful questions, surfaces risks early, and seeks feedback to continuously improve.

Special Requirements

Interview Process: Video Interview. Domain: Finance (Goldman Sachs). Visa Constraints: Not specified. Note: The email mentions 'Only Locals F2F Interview' in the subject, but the body states 'Video Interview'. Prioritizing the body's explicit statement.

Compensation & Location

Salary: $110,000 – $150,000 per year (Estimated)

Location: Dallas, TX

Recruiter / Company – Contact Information

Recruiter / Employer: Goldman Sachs

Email: harsingh@usgrpinc.com

Interested in this position?
Apply via Email

Recruiter Notice:
To remove this job posting, please send an email from
harsingh@usgrpinc.com with the subject:

DELETE_JOB_ID_8628

to delete@join-this.com.