EngineerJobs.io
← Back to all jobs

Job Description

Jennmar is looking for a Data Engineer to help design, build, and maintain the ETL/ELT pipelines that power its reporting and analytics environment. In this onsite role in Pittsburgh, you will extract and transform data from systems such as Ross and D365 F&O, load it into a data warehouse, and support Power BI reporting through reliable, well-structured datasets.

You will work closely with the BI team to keep data accurate and timely, tune complex SQL and pipeline performance, and maintain the operational reliability of scheduled ETL jobs through monitoring, troubleshooting, and data quality controls.

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 processing logic.
  • Monitor ETL jobs and troubleshoot and resolve pipeline failures.
  • Implement data validation, error handling, and logging to support 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.

Requirements

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

  • Experience with WhereScape RED or TimeXtender.
  • Experience with Microsoft Fabric, Lakehouse, and Dataverse.
  • Experience with D365 Finance & Operations.
  • DBA experience.
  • Experience with dimensional modeling, SSIS, and Power BI.
  • Experience in a manufacturing or industrial environment.

Technology Stack

  • ETL/ELT, SQL, Oracle
  • Ross, D365 F&O
  • Power BI
  • WhereScape RED, TimeXtender
  • Microsoft Fabric, Lakehouse, Dataverse
  • D365 Finance & Operations, SSIS
  • Dimensional modeling

Benefits

  • 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

Location: Pittsburgh, PA (onsite). Schedule: Full time onsite at PITCORP, with two remote days per month after the initial ramp period.

Education: Bachelor’s degree in Computer Science, Information Systems, or a related field, or equivalent experience.

Similar Jobs