Senior Data Engineer, Data Pipelines & Lakehouse Expert

Elliott Company; Jeannette (Westmoreland County); On-site; USD 140,000 - 190,000; Full time

Job summary

Ebara Elliott Energy is seeking a Data Engineer in the United States to build robust data pipelines and data lakehouse workflows. You will architect, troubleshoot and design complex data transformations, collaborating with data analysts, visualization engineers, and data scientists across global locations.

The role requires strong ETL, Databricks, cloud experience (AWS/Azure), and expertise with Oracle/SQL Server databases.

Qualifications

• Bachelor's degree in CS/IS/Data Science or related field.
• Minimum 10 years hands-on ETL experience.
• 3+ years Databricks experience.
• Experience with Oracle/SQL Server databases.
• Cloud experience with AWS or Azure Data Factory.
• Deep understanding of extracting data from ODBC sources and APIs.
• Basic Python skills.
• Ability to work with multiple business units and data teams.
• Strong problem-solving and stakeholder negotiation skills.
• Independent consultant capable of resolving complex issues.

Responsibilities

• Review source-to-target mapping documents.
• Design and document ETL pipelines with industry standard tools.
• Streamline and build robust data pipelines with clear data lineage.
• Monitor data flows across databases, cloud and on-premise.
• Implement best practices and standardize data integration across sources.
• Profile data, detect anomalies and improve data quality.
• Build Master Data Management processes and cleansing code.
• Establish robust data flows with logging and troubleshooting.
• Collaborate with analysts, visualization engineers and data scientists.
• Interact with internal users across operations, sales, marketing and finance.

Skills

ETL pipelines

Databricks

Oracle Database

SQL Server

AWS

Data modeling

Informatica

Fivetran

Azure Data Factory

Python

APIs

Cross-functional collaboration

Education

Bachelor's degree in CS/IS/Data Science

Tools

Databricks

ODBC

SQL Server

Oracle DB

AWS Cloud

Informatica

Job description

Ebara Elliott Energy is seeking a Data Engineer in the United States to build robust data pipelines and data lakehouse workflows. You will architect, troubleshoot and design complex data transformations, collaborating with data analysts, visualization engineers, and data scientists across global locations.

The role requires strong ETL, Databricks, cloud experience (AWS/Azure), and expertise with Oracle/SQL Server databases.