Data Engineer — ETL/ELT for Data Warehouse & Power BI

Frank Calandra Jennmar Services; Pittsburgh (Allegheny County); Hybride; USD 110 000 - 140 000; Plein temps

Avantages offerts par ce poste

Medical PPO plan

Wellness credit

Concierge primary care

Voluntary 401k 12% match

Dental and vision plans

Telemedicine

Résumé du poste

Jennmar is seeking a Data Engineer to design, build, and maintain ETL/ELT pipelines that support its reporting and analytics environment. You will extract data from Ross, D365 F&O, and other sources into the data warehouse, ensuring data is accurate, timely, and well-structured for Power BI reporting.

The role focuses on performance, reliability, SQL tuning, data quality, and documentation. It is onsite full-time at PITCORP with two remote days per month after ramp.

Qualifications

• Bachelor's degree or equivalent experience in CS/IS or related field.
• 5+ years as a Data Engineer/ETL Developer or similar role.
• Strong SQL development and tuning experience.

Responsabilités

• Design, build, maintain, and optimize ETL/ELT pipelines for reporting and analytics.
• Extract data from Ross, D365 F&O, and other sources into the data warehouse.
• Ensure data is accurate, timely, and well-structured for downstream reporting.
• Write, optimize, and tune complex SQL queries and processes.
• Monitor ETL jobs and troubleshoot pipeline failures.
• Document data flows and transformation logic; support data warehouse architecture.
• Collaborate with the BI team to support Power BI reporting needs.
• Build scalable pipelines emphasizing performance and reliability.

Connaissances

SQL development and tuning

ETL/ELT concepts

Data warehousing

Troubleshooting data issues

Formation

Bachelor's degree in CS/IS or related field

5+ years data engineering experience

Outils

WhereScape RED

TimeXtender

Microsoft Fabric

Lakehouse

Dataverse

D365 Finance & Ops

SSIS

Power BI

Description du poste

Jennmar is seeking a Data Engineer to design, build, and maintain ETL/ELT pipelines that support its reporting and analytics environment. You will extract data from Ross, D365 F&O, and other sources into the data warehouse, ensuring data is accurate, timely, and well-structured for Power BI reporting.

The role focuses on performance, reliability, SQL tuning, data quality, and documentation. It is onsite full-time at PITCORP with two remote days per month after ramp.