Data Engineer
Analytics
Business Analytics
Business Intelligence
Data
Data Analysis
Data Analytics
Data Analytics Tools
Data Engineer
Data Integration
Data Pipeline
Data Platform
Data Processing
Data Visualization
Data Warehouse
Database
Databases
Design
Digital Marketing
ETL
Hr Technology
Informatica
Information Technology (IT)
Integration
Microsoft
Microsoft Office
Office Tools
Power BI
Power Platform
Reporting and Analytics
SQL
Visual Design
Job Description
Jennmar is hiring a Data Engineer to design, build, and maintain ETL/ELT pipelines feeding a data warehouse for downstream Power BI reporting.
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 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 similar data engineering role
- Strong hands-on experience with SQL development and tuning
- 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
Technologies
- ETL/ELT
- SQL
- Oracle
- WhereScape RED
- TimeXtender
- Microsoft Fabric
- Lakehouse
- Dataverse
- D365 Finance & Operations
- Dimensional modeling
- SSIS
- Power BI
Preferred Qualifications
- WhereScape RED or TimeXtender experience
- Microsoft Fabric, Lakehouse, and Dataverse experience
- D365 Finance & Operations experience
- DBA experience
- Dimensional modeling, SSIS, and Power BI experience
- Experience in a manufacturing or industrial environment
Location and Schedule
- Onsite in Pittsburgh, PA
- Full-time onsite at PITCORP
- Two remote days per month after the initial ramp period
Benefits
- Medical plan: standard PPO 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
Job Summary: The Data Engineer will design, build, and maintain ETL/ELT pipelines for reporting and analytics. The role works within the BI team to load data from Ross, D365 F&O, and other source systems into the data warehouse to support downstream Power BI reporting. Key work includes performance and reliability tuning, monitoring and resolving ETL job failures, enforcing data quality through validation and logging, documenting data flows and transformation logic, and supporting data warehouse architecture and dimensional modeling.
Similar Jobs
