JobCubby JobCubby
Sign up
Frank Calandra Jennmar Services

Data Engineer

Frank Calandra Jennmar Services Pittsburgh, Pennsylvania, United States

Mining · 1,001-5,000 employees

Oct 06
data-engineer Senior (5-10 yrs) Full-time United States
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

Applying here? Try the free cover letter tool — paste this posting and your résumé, no account needed.

About the role

The Data Engineer will design, build, and maintain ETL/ELT pipelines to support reporting and analytics environments. They are responsible for ensuring data accuracy, optimizing SQL queries, and collaborating with the BI team to support Power BI reporting.

What they look for

SQL ETL ELT Data warehousing Data engineering Oracle Power BI D365 F&O Dimensional modeling Data integration Microsoft Fabric Lakehouse Dataverse SSIS WhereScape RED TimeXtender

Requirements

Candidates must have a bachelor's degree in a relevant field and at least 5 years of experience in data engineering or ETL development. Strong hands-on SQL development, tuning skills, and Oracle database experience are required.

Benefits

Medical insurance Wellness credit Concierge primary care 401k plan Dental insurance Vision insurance Telemedicine services Basic life insurance Long-term disability coverage Short-term disability coverage

Full description

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

EOE M/F/D/V

#IND11

Similar roles