Data Engineer

Frank Calandra Jennmar Services; Pittsburgh (Allegheny County); Hybrid; USD 110,000 - 140,000; Full time

Benefits offered by this job

Medical PPO plan

Wellness credit

Concierge primary care

Voluntary 401k 12% match

Dental and vision plans

Telemedicine

Job summary

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.

Responsibilities

• 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.

Skills

SQL development and tuning

ETL/ELT concepts

Data warehousing

Troubleshooting data issues

Education

Bachelor's degree in CS/IS or related field

5+ years data engineering experience

Tools

WhereScape RED

TimeXtender

Microsoft Fabric

Lakehouse

Dataverse

D365 Finance & Ops

SSIS

Power BI

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Pittsburgh, PA, US

2 days ago Requisition ID: 4320

JOB SUMMARY:

The Data Engineer will design, build, and maintain ETL/ELT pipelines that support Jennmar’s reporting and analytics environment. Works within the BI team to extract, transform, and load data from Ross, D365 F&O, and other source systems into the data warehouse, ensuring data is accurate, timely, and well-structured for downstream Power BI reporting. Builds and optimizes pipelines for performance and reliability; writes and tunes complex SQL; monitors and resolves ETL job failures; maintains data quality through validation, error handling, and logging; documents data flows and transformation logic; and supports data warehouse architecture and dimensional modeling. Position is onsite full time at PITCORP, with two remote days per month after the initial ramp period.

EDUCATION/EXPERIENCE:

• Bachelor’s degree in Computer Science, Information Systems, or a related field, or equivalent experience.
• 5+ years of experience as a Data Engineer, ETL Developer, or in a similar data engineering role.
• Strong hands-on SQL development and tuning experience.

QUALIFICATIONS:

• Solid understanding of ETL/ELT concepts, data warehousing principles, and data integration best practices.
• Ability to independently troubleshoot data discrepancies and diagnose pipeline failures.
• Preferred experience with WhereScape RED or TimeXtender.
• Preferred experience with Microsoft Fabric, Lakehouse, and Dataverse.
• Preferred experience with D365 Finance & Operations.
• Preferred DBA experience.
• Preferred experience with dimensional modeling, SSIS, and Power BI.
• Preferred experience in a manufacturing or industrial environment.

RESPONSIBILITIES:

• Design, build, maintain, and optimize ETL/ELT pipelines supporting reporting and analytics.
• Extract, transform, and load data from Ross, D365 F&O, and other source systems into the data warehouse.
• Ensure data is accurate, timely, reliable, and well-structured for downstream reporting.
• Write, optimize, and tune complex SQL queries and processes.
• Monitor ETL jobs and troubleshoot and resolve pipeline failures.
• Implement data validation, error handling, and logging to maintain data quality.
• Document data flows, transformation logic, and integration processes.
• Support data warehouse architecture and dimensional modeling.
• Collaborate with the BI team to support Power BI reporting and analytics needs.
• Build and optimize data pipelines for performance, scalability, and reliability.

• Excellent benefits include medical with a standard PPO plan with deductibles as low as $1,500 and wellness credit up to $750
• free concierge primary care
• voluntary 401k plan currently matching up to 12%
• voluntary dental and vision plans
• free telemedicine services
• basic life, long and short-term disability coverage