Lead Analyst Data Engineer

Boardwalk Pipelines; Houston (TX); On-site; USD 120,000 - 150,000; Full time

Job summary

Boardwalk Pipelines is seeking a Lead Data Engineer to architect scalable data pipelines. This role requires proficiency in AWS, particularly with services such as Glue and Redshift, and experience in Databricks.

The ideal candidate will lead data integration efforts, support analytics use cases, and have a Bachelor's degree in a relevant field. Boardwalk Pipelines values sustainability and offers a competitive work environment.

Qualifications

• 7–10 years of experience in cloud data architecture, focusing on AWS.
• Proficiency with AWS services: Glue, Redshift, Athena.
• Extensive experience with Databricks.

Responsibilities

• Architect and deliver scalable, high-performance data pipelines.
• Lead adoption of modern data architectures like Lakehouse.
• Mentor junior data engineers and analysts.

Skills

Cloud Data Architecture

AWS Services (Glue, Redshift, Athena)

Databricks

SQL (T-SQL)

Python (PySpark/Pandas)

Power BI

Alation

Leadership

Education

Bachelor’s degree in Computer Science, Data Science, Engineering

Masters Degree

Tools

SQL Server

Oracle

PostgreSQL

Azure SQL

Teradata

Visual Studio Code

Git

Job description

Overview

Boardwalk is a limited partnership operating in the midstream portion of the natural gas and natural gas liquids industry, providing transportation and storage services for our customers. Our 14,000 miles of pipeline and storage assets provide diverse market connectivity to producers and end-users who need reliable sources of natural gas for power generation, home heating or petrochemical feedstocks. We have the experience, knowledge, and flexibility to design service offerings and create system enhancements tailored to our customers’ needs throughout the 13 states in which we operate. As an organization focused on sustainability, we are committed to protecting the environment while delivering this energy source. This commitment is made to our customers, employees, and the communities in which we operate. We incorporate environmental stewardship, safety, and compliance into our day-to-day operations and seek to strengthen and support the communities we serve. Additional information about the company can be found online at www.bwpipelines.com.

Position Description

The Lead Data Engineer is responsible for architecting and delivering scalable, high-performance data pipelines and platforms across cloud environments. This role leads the adoption of modern data architectures such as a Lakehouse and Databricks, strengthens data integration and governance, supports analytics and AI/ML use cases, and mentors data engineers and analysts to advance engineering standards and team capability.

Required Skills, Knowledge, And Experience

• 7–10 years of implementation experience in cloud data architecture, with at least 5 years in AWS environments.
• Proficiency in AWS services: Glue, Redshift, Athena, Lake Formation, SageMaker, Bedrock, Step Functions.
• Extensive experience working with Databricks.
• Working knowledge of the Alation data governance tool.
• Strong skills in SQL (T-SQL), Python (PySpark/Pandas), DAX, Power Query (M), PL/SQL.
• Experience with databases: SQL Server, Oracle, PostgreSQL, Azure SQL, Teradata.
• Skilled in Power BI, Git, Visual Studio Code, SSMS.
• Knowledge of architectural patterns: Medallion architecture, data mesh, Lakehouse, SOA data layers.
• Excellent communication, collaboration, and leadership abilities.

Preferred Skills, Knowledge, And Experience

• AWS and Databricks certifications.
• Experience leading cloud migration and data modernization initiatives.
• Designing and implementing scalable data architectures in AWS and Databricks.
• Managing data governance, security, and compliance in complex environments.
• Mentoring junior architects and engineers.
• Working with cross-functional teams to deliver business value through data.

Required Education

• Bachelor’s degree in Computer Science, Data Science, Engineering, or related field

Preferred Education

• Masters Degree

Additional Information

Boardwalk Pipelines, LP, maintains a drug-free workplace and will require pre-employment drug & substance abuse testing before hiring.

Boardwalk Pipelines, LP, is an equal opportunity employer. All applicants will be considered for employment regardless of race, color, religion, age, sex, gender identity, national origin, veteran, or disability status.