DataJobs.io
← Back to all jobs

Job Description

Jennmar is seeking a Data Engineer to design, build, and maintain ETL/ELT pipelines that power its reporting and analytics environment. In this onsite role in Pittsburgh, you will extract, transform, and load data from Ross, D365 F&O, and other systems into a data warehouse used for Power BI reporting.

You will work within the BI team to keep data accurate, timely, reliable, and well-structured for downstream use. The role also involves tuning complex SQL, monitoring ETL jobs, and troubleshooting pipeline failures while maintaining strong data quality through validation, error handling, and logging.

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.

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: WhereScape RED or TimeXtender.
  • Preferred: Microsoft Fabric, Lakehouse, and Dataverse.
  • Preferred: D365 Finance & Operations.
  • Preferred: DBA experience.
  • Preferred: Dimensional modeling, SSIS, and Power BI.
  • Preferred: Experience in a manufacturing or industrial environment.

Technologies

  • 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

Job Location: Pittsburgh, PA (onsite). This is a full-time onsite position at PITCORP, with two remote days per month after the initial ramp period.

Similar Jobs