Senior Data Engineer — ETL/ELT & Analytics Pipelines

Jennmar Automation, LLC; Pittsburgh, Northern (Allegheny County, KY); Hybrid; USD 110,000 - 140,000; Full time

Benefits offered by this job

Medical PPO, low deductibles

Wellness credit

Free concierge primary care

Voluntary 401k (12% match)

Dental and vision plans

Telemedicine

Life and disability insurance

Job summary

Jennmar Automation, LLC is seeking a Data Engineer to design, build, and maintain ETL/ELT pipelines supporting reporting and analytics. You will extract data from Ross, D365 F&O, and other sources into the data warehouse, ensuring accuracy and timely delivery for Power BI reporting.

The role requires strong SQL development skills, data warehousing knowledge, and experience with ETL tools such as WhereScape RED or TimeXtender. Onsite at PITCORP with two remote days per month after ramp.

Qualifications

• Bachelor’s degree or equivalent experience in CS/IS or related field.
• 5+ years as Data Engineer/ETL Developer or similar role.
• Strong hands-on SQL development and tuning.
• Understand ETL/ELT, data warehousing, and data integration best practices.
• Prefer WhereScape RED or TimeXtender experience; Microsoft Fabric, Lakehouse, Dataverse.

Responsibilities

• Design, build, and optimize ETL/ELT pipelines for reporting/analytics.
• Load data from Ross, D365 F&O, and other sources into the data warehouse.
• Ensure data is accurate, timely and well-structured for downstream reporting.
• Write and tune complex SQL queries and processes.
• Monitor ETL jobs; troubleshoot and resolve failures.
• Implement data validation, error handling, and logging.
• Document data flows, transformations, and integration processes.
• Support data warehouse architecture and dimensional modeling.
• Collaborate with BI team to support Power BI reporting needs.
• Build data pipelines for performance, scalability, and reliability.

Skills

ETL/ELT

SQL tuning

Data warehousing

Power BI

Data validation

WhereScape RED

TimeXtender

D365 F&O

Dimensional modeling

Manufacturing exp.

Education

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

Tools

WhereScape RED

TimeXtender

Power BI

SSIS

D365 F&O

Job description

Jennmar Automation, LLC is seeking a Data Engineer to design, build, and maintain ETL/ELT pipelines supporting reporting and analytics. You will extract data from Ross, D365 F&O, and other sources into the data warehouse, ensuring accuracy and timely delivery for Power BI reporting.

The role requires strong SQL development skills, data warehousing knowledge, and experience with ETL tools such as WhereScape RED or TimeXtender. Onsite at PITCORP with two remote days per month after ramp.