Data Engineer: ETL Pipelines, Oracle & BI (On-Site)

LRSolutions, LLC

Pittsburgh (Allegheny County)

Sur place

USD 110 000 - 150 000

Plein temps

Il y a 2 jours

Soyez parmi les premiers à postuler

Obtenez une réponse de cet employeur

Votre CV et votre lettre de motivation, adaptés exactement à ce que l’employeur recherche.

Passez les filtres ATS

Résumé du poste

LRSolutions, LLC in Pittsburgh, PA is seeking a hands-on Data Engineer who loves turning complex, disconnected data into reliable intelligence. This role focuses on building the pipelines and warehouse foundations that power meaningful reporting and better business decisions.

The position is on-site in Pittsburgh with two remote days per month after ramp-up, and you’ll design, build, and optimize ETL/ELT pipelines while collaborating with BI teams to deliver trusted data for stakeholders.

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.

Responsabilités

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.