Data Engineer

Elevate decision-making with robust data solutions in a dynamic industrial setting. Our client invites applications from innovative professionals excited to transform disparate data into strategic insights. As a pivotal contributor, your work will directly enhance an organization's analytical capabilities and drive informed business strategies.

Unique Benefits of Joining:

Craft and control sophisticated data channels ensuring seamless transition from raw inputs to insightful analytics.
Collaborate intensively with a team of analytics experts to spearhead impactful reporting projects.
Utilize your deep knowledge of SQL and Oracle to solve real, complex challenges in a manufacturing-centric setting.

Key Responsibilities:

Architect and refine ETL/ELT channels to bolster an expansive data warehouse infrastructure.
Seamlessly unite data sourced from Oracle, Ross ERP, Microsoft Dynamics 365 Finance & Operations, and various platforms.
Construct and refine advanced SQL queries, stored procedures, and performance-driven scripts.
Independently oversee and diagnose data loading processes, addressing issues promptly.
Enhance data integrity through diligent verification, comprehensive logging, and effective error management.
Collaborate with BI developers, analysts, and business experts to furnish reliable reporting data.
Document intricate data processes and transformation logic, actively contributing to warehouse architecture, dimensional modeling, and critical code assessments.

Your Qualifications:

A minimum of 5 years of experience in data engineering, ETL development, or related fields.
Proficiency in hands-on SQL development with keen performance optimization skills.
Proven experience with Oracle databases, along with solid foundations in ETL/ELT processes and data warehousing.
Ability to diagnose and resolve pipeline issues and data accuracy concerns with minimal guidance.
Bachelor’s degree in a related field or equivalent professional experience.

Valuable Additional Experience:

Familiarity with WhereScape RED, TimeXtender, Microsoft Fabric, Lakehouse, or Dataverse.
Acquainted with D365 Finance & Operations, SSIS, Informatica, Power BI, or possess DBA experience.
Background in dimensional modeling and data environments within manufacturing, mining, or industrial sectors.

Working Conditions:

Positioned on-site in Pittsburgh, with two flexible remote days monthly after an initial adjustment period.

Eager to contribute significantly? Connect with us today to explore this exciting career path with our esteemed client.