Data Engineer Build ETL Pipelines for Smart Manufacturing

Clear Concepts, Inc.; Pittsburgh (Allegheny County); Hybrid; USD 110,000 - 140,000; Full time

Job summary

Clear Concepts, Inc. is seeking a hands-on Data Engineer to build pipelines and a robust data foundation for smarter decisions. The role focuses on pipelines, data warehouse foundations, and reliable reporting to power business insights.

You will work with a BI team on high-impact initiatives, leveraging Oracle and SQL expertise in a manufacturing-oriented environment to deliver trusted data and analytics-ready datasets.

Qualifications

• 5+ years in data engineering, ETL development, or a closely related role.
• Strong hands-on SQL development and performance-tuning skills.
• Experience with Oracle databases and sound ETL/ELT fundamentals.
• Ability to troubleshoot pipeline failures and data accuracy issues with minimal direction.

Responsibilities

• Design, build, and optimize ETL/ELT pipelines feeding an enterprise data warehouse.
• Integrate data from Oracle, Ross ERP, Microsoft Dynamics 365 Finance & Operations, and other systems.
• Write and tune complex SQL queries, stored procedures, and scripts for performance and reliability.
• Monitor data loads, diagnose failures, and resolve discrepancies independently.
• Strengthen data quality through validation, logging, and error handling.
• Partner with BI developers, analysts, and business stakeholders to deliver trusted reporting data.
• Document data flows and transformation logic; contribute to warehouse architecture and code reviews.

Skills

SQL development

ETL/ELT

Oracle databases

Data warehousing

Pipeline troubleshooting

Education

Bachelor's degree

Tools

WhereScape RED

TimeXtender

Power BI

Informatica

D365 (MS Dynamics)

Job description

Clear Concepts, Inc. is seeking a hands-on Data Engineer to build pipelines and a robust data foundation for smarter decisions. The role focuses on pipelines, data warehouse foundations, and reliable reporting to power business insights.

You will work with a BI team on high-impact initiatives, leveraging Oracle and SQL expertise in a manufacturing-oriented environment to deliver trusted data and analytics-ready datasets.