Summary: The Data Engineer III role involves collaborating with business domain experts to develop an Enterprise Data Lakehouse for midstream oil and gas operations. The position requires extensive experience in software development, particularly with Python, and a strong background in data engineering practices. The successful candidate will design and implement data pipelines and ensure data quality for analytics use cases. This role is critical for supporting the data needs of engineering and measurement business units.

Key Responsibilities:

• 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

Key Skills:

• 5+ years of experience as a Data Engineer designing and maintaining data pipeline architectures
• 5+ years of programming experience in Python and ANSI SQL
• 2+ years of development experience with DBT, Data Build Tool
• Experience in various data modelling methods such as Star Schema, Snowflake, and Data Vault design
• Experience in implementing a Data Lakehouse using a Medallion Architecture with Apache Iceberg on S3 Object Storage
• Experience in various data integration patterns including ELT, Pub/Sub, and Change Data Capture
• Experience with common Python Data Engineering packages including Pandas, Numpy, Pyarrow Pytest, Scikit-Learn, and Boto3
• Excellent communication skills with experience presenting complex concepts to technical and non-technical stakeholders
• Experience in software development practices such as Design Principles and Patterns, Testing, Refactoring, CI/CD, and version control
• Experience with Dremio, Apache Airflow, and Airbyte is preferred

Salary (Rate): 80

City: Houston

Country: United States

Working Arrangements: undetermined

IR35 Status: undetermined

Seniority Level: Mid-Level

Industry: IT