Data Engineer: Build ETL Pipelines & Analytics Foundation

Meritas Advisory Group, LLC

Pittsburgh (Allegheny County)

Hybrid

USD 110,000 - 160,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Meritas Advisory Group, LLC seeks a hands-on Data Engineer to turn complex, disconnected data into reliable intelligence in a primarily on-site Pittsburgh setting. You will own ETL/ELT pipelines, build data warehouse foundations, and partner with BI to deliver trusted reporting data.

Responsibilities include integrating Oracle and ERP data, writing complex queries, monitoring loads, and ensuring data quality. A 5+ year background in data engineering and strong SQL are expected.

Qualifications

  • 5+ years in data engineering, ETL development, or a closely related role.
  • Strong hands-on SQL development and performance-tuning skills.
  • Experience with Oracle databases and sound ETL/ELT and data warehousing fundamentals.
  • Ability to troubleshoot pipeline failures and data accuracy issues with minimal direction.
  • Bachelor’s degree in a related discipline or equivalent professional experience.

Responsibilities

  • Design, build, and optimize ETL/ELT pipelines feeding an enterprise data warehouse.
  • Integrate data from Oracle, Ross ERP, Microsoft Dynamics 365 Finance & Operations, and other systems.
  • Write and tune complex SQL queries, stored procedures, and scripts for performance and reliability.
  • Monitor data loads, diagnose failures, and resolve discrepancies independently.
  • Strengthen data quality through validation, logging, and error handling.
  • Partner with BI developers, analysts, and business stakeholders to deliver trusted reporting data.
  • Document data flows and transformation logic; contribute to warehouse architecture, dimensional modeling, and code reviews.

Skills

SQL development
ETL/ELT engineering
Data warehousing
Troubleshooting pipelines
Documentation & collaboration

Education

Bachelor's degree

Tools

Oracle
WhereScape RED
TimeXtender
Microsoft Fabric
Dataverse
SSIS
Informatica
Power BI

Job description

Meritas Advisory Group, LLC seeks a hands-on Data Engineer to turn complex, disconnected data into reliable intelligence in a primarily on-site Pittsburgh setting. You will own ETL/ELT pipelines, build data warehouse foundations, and partner with BI to deliver trusted reporting data.

Responsibilities include integrating Oracle and ERP data, writing complex queries, monitoring loads, and ensuring data quality. A 5+ year background in data engineering and strong SQL are expected.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer: Build Enterprise Data Pipelines (On-Site)
Data Engineer: Build Enterprise Data Pipelines (On-Site)

Professional Recruiting Consultants, Inc. • Pittsburgh

Hybrid
USD 90,000 - 140,000
Data Engineer: Build ETL Pipelines & Data Warehouse
Data Engineer: Build ETL Pipelines & Data Warehouse

Management Performance Associates • Pittsburgh

On-site
USD 110,000 - 150,000
Data Engineer — Build ETL Pipelines for Industrial Analytics
Data Engineer — Build ETL Pipelines for Industrial Analytics

ExcelliSearch, Inc. • Pittsburgh

On-site
USD 110,000 - 140,000
Data Engineer - On-Site: Build Enterprise Data Pipelines
Data Engineer - On-Site: Build Enterprise Data Pipelines

Talent Solutions Partners • Pittsburgh

Hybrid
USD 120,000 - 160,000
Data Engineer - ETL/Warehouse Architect (On-Site Pittsburgh)
Data Engineer - ETL/Warehouse Architect (On-Site Pittsburgh)

Essenti Talent • Pittsburgh

On-site
USD 120,000 - 160,000
Data Engineer: Enterprise Pipelines (On-Site, Pittsburgh)
Data Engineer: Enterprise Pipelines (On-Site, Pittsburgh)

Workforce Recruiter • Pittsburgh

Hybrid
USD 120,000 - 160,000
Data Engineer: Build Robust Pipelines & Analytics (On-Site)
Data Engineer: Build Robust Pipelines & Analytics (On-Site)

Your Talent Team • Pittsburgh

Hybrid
USD 95,000 - 125,000
Data Engineer: Build Enterprise Data Pipelines & Warehouse
Data Engineer: Build Enterprise Data Pipelines & Warehouse

Top Echelon Software, LLC • Pittsburgh

Hybrid
USD 110,000 - 160,000
Data Engineer — ETL/Warehouse for Industrial Ops (On-Site)
Data Engineer — ETL/Warehouse for Industrial Ops (On-Site)

Hire Consulting Services • Pittsburgh

Hybrid
USD 110,000 - 150,000
Data Engineer - ETL & DW Lead (On-Site Pittsburgh)
Data Engineer - ETL & DW Lead (On-Site Pittsburgh)

Launching Point • Pittsburgh

Hybrid
USD 110,000 - 140,000