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 that deliver validated data to a data warehouse for downstream Power BI reporting.
Responsibilities
- Design, build, maintain, and optimize ETL/ELT pipelines for reporting and analytics
- Extract, transform, and load data from Ross and D365 Finance & Operations, plus other source systems
- Ensure data is accurate, timely, reliable, and structured for downstream reporting
- Write, optimize, and tune complex SQL queries, processes, and transformations
- Monitor ETL jobs and troubleshoot pipeline failures to restore reliable data delivery
- 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 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, 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
- Experience with WhereScape RED or TimeXtender
- Experience with Microsoft Fabric, Lakehouse, and Dataverse
- Experience with D365 Finance & Operations
- Preferred DBA experience
- Experience with dimensional modeling, SSIS, and Power BI
- Experience in a manufacturing or industrial environment
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
Location and schedule
- Pittsburgh, PA (onsite)
- Onsite full time at PITCORP, with two remote days per month after the initial ramp period
Similar Jobs
