Lead Data Engineer

INSPYR Solutions; Houston (TX); On-site; USD 140,000 - 190,000; Full time

Job summary

INSPYR Solutions in Houston, TX is seeking an experienced Lead Data Engineer to join our Big Data and Advanced Analytics team. You will design and implement an Enterprise Data Lakehouse to support analytics for oil, gas operations, engineering, and measurements.

You will lead data pipelines, ensure data quality, govern data assets, and work with AWS, Airflow, Iceberg/Delta Lake, and Kubernetes to deliver scalable solutions and enable data-driven decisions across the business.

Qualifications

• 8+ years designing and maintaining data pipeline architectures.
• 5+ years Python and SQL programming.
• Experience with data governance, security, and compliance.
• Experience building a Data Lakehouse with Iceberg or Delta Lake.

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
• Automate and optimize the data lifecycle, find insights from raw data, and applying DevOps principle to data pipelines
• Work with business leaders to deliver custom software solutions meeting data needs
• Build and support a data platform for data engineering teams to build, deploy and manage applications

Skills

Python programming

SQL

Data modeling

Data governance & security

DevOps for data pipelines

Distributed data processing

Leadership

Tools

Apache Airflow

Kubernetes

Snowflake

Delta Lake

Iceberg

AWS

DBT

Airbyte

Boto3

Pyarrow

Pandas

Job description

Title: Lead Data Engineer Location: Houston, TX 77002 (ONSITE) Duration: Direct Hire Work Requirements: US Citizen, GC Holders or Authorized to Work in the U.S.

Job Description

We are currently seeking an experienced Lead Data Engineer to join the Big Data and Advanced Analytics department. The Lead 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

• 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
• Automate and optimize the data lifecycle, find insights from raw data, and applying DevOps principle to data pipelines
• Work with business leaders to deliver custom software solutions meeting data needs
• Build and support a data platform for data engineering teams to build, deploy and manage applications

Qualifications

• 8+ years of experience as a Data Engineer designing and maintaining data pipeline architectures
• 5+ years of in-depth programming experience in Python and SQL
• 5+ years in software development lifecycle experience with software engineering, development, testing, version control, refactoring, and deployment
• Experience with common Python Data Engineering packages including Pandas, Numpy, Pyarrow, Pytest, Scikit-Learn, and Boto3
• Experience in implementing a Data Lakehouse using Apache Iceberg or Delta Lake
• Experience with data platform architecture responsible for high-level design, strategy and implementation of data infrastructure, including data modelling, designing scalable architectures and ensuring data governance, security and compliance
• Knowledgeable of modern data platform technologies including Apache Airflow, Kubernetes, and S3 Object Storage
• Experience with AWS, Snowflake, DBTand Airbyte is preferred
• Experience with infrastructure as code, building consistent and repeatable cloud infrastructure

About INSPYR Solutions

Technology is our focus and quality is our commitment. As a national expert in delivering flexible technology and talent solutions, we strategically align industry and technical expertise with our clients' business objectives and cultural needs. Our solutions are tailored to each client and include a wide variety of professional services, project, and talent solutions. By always striving for excellence and focusing on the human aspect of our business, we work seamlessly with our talent and clients to match the right solutions to the right opportunities. Learn more about us at inspyrsolutions.com.

INSPYR Solutions provides Equal Employment Opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, INSPYR Solutions complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities.

Information collected and processed through your application with INSPYR Solutions (including any job applications you choose to submit) is subject to INSPYR Solutions’ Privacy Policy and INSPYR Solutions’ AI and Automated Employment Decision Tool Policy: https://www.inspyrsolutions.com/policies/. By submitting an application, you are consenting to being contacted by INSPYR Solutions through phone, email, or text.