Data Engineer III (Enterprise Products Partners)

Data Engineer III

The Data Engineer will use existing data lakehouse environment (Apache Iceberg/Dremio) to design and implement solutions for new consumers in the business. This person will work closely with project teams and members of new internal customers to deliver solutions using Python, SQL, creating data pipelines for the consumer.

This is a 6000 person company where everyone wears multiple hats and it is not uncommon for the Data Engineering team to work with the customer directly to better understand their needs.

Every candidate needs to have experience doing this or we will not submit. We clearly need very senior people considering the rate. This is not a production support position. This person will not be moving on-prem to cloud, so any S3 or Snowflake migration or AWS cloud migration exp is worthless. This job has nothing to do with any of that.

Location: 100% onsite Day 1 in Downtown Houston (77002)

Duration: 12 months, option to extend

Visa: USC, GC, GC-EAD, H4-EAD

We are currently seeking an experienced Data Engineer to join the Big Data and Advanced Analytics department. The Data Engineer will work closely with business domain experts to create an Enterprise Data Lakehouse to support data analytic use cases for the midstream oil and gas operations, engineering, and measurements business units. Responsibilities include:

• Design and implement reliable data pipelines to integrate disparate data sources into a single Data Lakehouse
• Design and implement data quality pipelines to ensure data correctness and building trusted datasets
• Design and implement a Data Lakehouse solution which accurately reflects business operations
• Assist with data platform performance tuning and physical data model support including partitioning and compaction
• Provide guidance in data visualizations and reporting efforts to ensure solutions are aligned to business objectives

The successful candidate will meet the following qualifications:

• 5+ years of experience as a Data Engineer designing and maintaining data pipeline architectures
• 5+ years of programming experience in Python, ANSI SQL, PLSQL, and TSQL
• Experience in various data integration patterns including ETL, ELT, Pub/Sub, and Change Data Capture
• Experience with common Python Data Engineering packages including pandas, Numpy, Pyarrow Pytest, Scikit-Learn, and Boto3
• Experience in software development practices such as Design Principles and Patterns, Testing, Refactoring, CI/CD, and version control
• Experience in implementing a Data Lakehouse using Apache Iceberg or Delta Lake
• Knowledgeable of modern data platform technologies including Apache Airflow, Kubernetes, and S3 Object Storage
• Experience with Dremio and Airbyte is preferred