Data Engineer
Design, build, and maintain ETL/ELT pipelines supporting reporting and analytics.
- Pittsburgh, Pennsylvania, United States
- Full-time
- On-site
- Posted Nov 11, 2026
INDUSTRYSoftware & InternetData & Analytics
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.
Nice to have: WhereScape RED, TimeXtender, Microsoft Fabric, Lakehouse, Dataverse, D365 Finance & Operations, DBA, dimensional modeling, SSIS, Power BI, manufacturing environment
Skills
Benefits
- medical with a standard PPO plan with deductibles as low as $1,500
- 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
More jobs nearby
Full description
Frank Calandra Jennmar ServicesCompany details are for members
Sign up for a free job alert to see Frank Calandra Jennmar Services's profile, website and LinkedIn, and the same for every employer on Referso Jobs.