Data Engineer

Jennmar Services

Pittsburgh (Allegheny County)

Hybrid

USD 90,000 - 130,000

Full time

45 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Medical insurance
Wellness credits
Concierge primary care
401k matching
Dental and vision
Telemedicine
Life insurance
Disability coverage

Job summary

Jennmar Services in Pittsburgh, PA is seeking a Data Engineer to design, build, and maintain ETL/ELT pipelines supporting reporting and analytics across Ross, D365 F&O, and other sources. You will ensure data quality and structure for downstream Power BI dashboards and analytics, collaborating with the BI team to optimize performance.

The role is onsite full-time at PITCORP with two remote days per month after ramp.

Qualifications

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

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.

Skills

SQL
ETL/ELT
Data warehousing
Data integration
Troubleshooting

Education

Bachelor’s degree in Computer Science, Information Systems, or related field

Tools

WhereScape RED
TimeXtender
Microsoft Fabric
Dataverse
D365 F&O
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.

Corp Managers Pittsburgh, PA, US

7 days ago Requisition ID: 4397

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer
Data Engineer

Jennmar • Pittsburgh

Hybrid
USD 110,000 - 140,000
Medical PPO
Wellness credit
Concierge primary care
+4
Data Engineer — ETL & Power BI Data Pipelines
Data Engineer — ETL & Power BI Data Pipelines

Jennmar • Pittsburgh

Hybrid
USD 110,000 - 140,000
Medical PPO
Wellness credit
Concierge primary care
+4
Data Engineer — ETL Pipelines & Power BI (Onsite/Hybrid)
Data Engineer — ETL Pipelines & Power BI (Onsite/Hybrid)

Jennmar Services • Pittsburgh

Hybrid
USD 90,000 - 130,000
Medical insurance
Wellness credits
Concierge primary care
+5
Data Engineer
Data Engineer

Calqulate Metrics Ltd • Pittsburgh

On-site
USD 90,000 - 130,000
Data Engineer
Data Engineer

Aminov Search Partners LLC • Pittsburgh

Hybrid
USD 108,000 - 132,000
Two remote days per month
On-site Pittsburgh, PA
Data Engineer
Data Engineer

Sun Recruiting, Inc. • Pittsburgh

On-site
USD 110,000 - 150,000
Data Engineer
Data Engineer

Rare Bird Recruiting, LLC • Pittsburgh

Hybrid
USD 110,000 - 160,000
Data Infrastructure Engineer
Data Infrastructure Engineer

Sterling St James LLC • Pittsburgh

Hybrid
USD 110,000 - 140,000
Data Engineer
Data Engineer

Horan Hiring Solutions, LLC • Pittsburgh

On-site
USD 100,000 - 140,000
Data Engineer
Data Engineer

JobFormance LLC • Pittsburgh

On-site
USD 120,000 - 160,000