Data Engineer @ Dallas, TX 75201 - (Locals Preferred) - Full Time

BURGEON IT SERVICES is recruiting for a Data Engineer role on a high-visibility Goldman Sachs project. The engineer will support end-to-end migration from an on-premises DataLake to an AWS-hosted LakeHouse, including pipeline and consumption-pattern migration, stakeholder coordination, and data reconciliation.

Responsibilities

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 "hand-off and sign-off" conversations with data owners to ensure migrated assets meet business requirements

Translating and optimizing legacy SQL and Spark-based consumption patterns (raw and modeled) for compatibility with Snowflake and Iceberg

Understand usage patterns to deliver the required data products

Acting as a technical liaison to internal clients, facilitating "hand-off and sign-off" conversations with data owners to ensure migrated assets meet business requirements

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

Engineer will also need to work with internal data management platforms team and must have an aptitude for learning new workflows and language constructs as necessary

Company

IT staff augmentation and consulting provider

Claymont, Delaware, USA

https://burgeonits.com/

Founded in 2010

51-200 employees

Qualifications

Bachelor's or Masters in Computer Science, Applied Mathematics, Engineering, or a related quantitative field

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

Professional proficiency in Python or Java

Deep familiarity with the full Software Development Life Cycle (SDLC) and CI/CD best practices & K8s deployment experience

Candidates must demonstrate a sophisticated understanding of the following modeling concepts to ensure data correctness during reconciliation:

Managing state changes over time (e.g., SCD Type 2 )

Expertise in Schema Evolution (Apache Iceberg) and enforcement strategies

Advanced knowledge of data partitioning and clustering

Balancing Normalization vs. Denormalization and the strategic use of Natural vs. Surrogate Keys

Kafka, ANSI SQL, FTP, Apache Spark

JSON, Avro, Parquet

Hadoop (HDFS/Hive), Snowflake, Apache Iceberg, Sybase IQ

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

Burgeon is a Global Technology & Consulting company specialized in Application Development, Consulting Services & IT Staff Augmentation.

Claymont, Delaware, USA

https://burgeonits.com

H1B Sponsorship

Data Powered by

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Engineering and Development

Trends of Total Sponsorships

*2025

(1)

Growth Stage

Company data provided by

AI Tools

Customize Your Resume

Maximize your interview chances

Build Cover Letter

Make your application stand out

Analyze How Well You Fit

Understand your strength & weakness

Required skills

Python, Java, SQL, Apache Spark, Snowflake, Apache Iceberg, Kubernetes (K8s), CI/CD, Software Development Life Cycle (SDLC), SCD Type 2, Schema Evolution, Data Partitioning and Clustering

Experience

3-5 years