DeveloperJobs.io
← Back to all jobs

Job Description

Jennmar is hiring a Data Engineer to strengthen its reporting and analytics foundation. In this onsite role based in Pittsburgh, PA, you will design, build, and maintain ETL/ELT pipelines that feed a data warehouse used for Power BI reporting.

You will work within the BI team to extract data from systems including Ross and D365 F&O, transform it into well-structured warehouse data, and keep pipelines running with accuracy, timeliness, and reliability. The work also includes SQL development and tuning, monitoring and troubleshooting, and documentation of data flows and transformation logic.

What you’ll do

  • 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 structured for downstream reporting.
  • Write, optimize, and tune complex SQL queries and processes.
  • Monitor ETL jobs and troubleshoot to 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.

What you bring

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

  • WhereScape RED or TimeXtender.
  • Microsoft Fabric, Lakehouse, and Dataverse.
  • D365 Finance & Operations.
  • DBA experience.
  • Dimensional modeling, SSIS, and Power BI.
  • 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

This is an onsite full-time position at PITCORP in Pittsburgh, PA, with two remote days per month after the initial ramp period.

Similar Jobs