Lead Data Engineer

Talentify; Houston (TX); On-site; USD 120,000 - 180,000; Full time

Job summary

INSPYR Solutions in Houston, TX is seeking an experienced Lead Data Engineer to help build an Enterprise Data Lakehouse supporting analytics for midstream oil and gas operations. You will design reliable pipelines and data quality processes, and collaborate with domain experts to reflect business needs in data architecture.

Strong background in Python and SQL, hands-on data engineering lifecycle, and knowledge of Airflow, Iceberg/Delta Lake, and cloud platforms will be essential as you lead

Qualifications

• 8+ years of experience designing and maintaining data pipeline architectures.
• 5+ years of in-depth programming with Python and SQL.
• Experience with data lakehouse technologies and data governance.
• Knowledge of SDLC, version control and deployment processes.

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 trusted datasets.
• Design and implement a Data Lakehouse solution reflecting business operations.
• Assist with data platform performance tuning and physical data model support including partitioning and optimization.
• Provide guidance in data visualizations and reporting aligned to business objectives.
• Automate and optimize the data lifecycle, applying DevOps principles to data pipelines.
• Collaborate with business leaders to deliver software solutions meeting data needs.
• Build and support a data platform for data engineering teams to build, deploy and manage applications.

Skills

Data pipeline design

Python programming

SQL programming

Software development lifecycle

Data governance

Education

Bachelor's degree in Computer Science or related field

Tools

Apache Iceberg

Delta Lake

Apache Airflow

Kubernetes

Snowflake

DBT

Airbyte

AWS

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, DBT and 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, genetics, or any other protected status. INSPYR Solutions complies with all applicable laws governing nondiscrimination in employment in every location in which the company has facilities. Applicants requiring reasonable accommodation during the application or interview process should contact [e-mail] for assistance. 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.