IT Data Engineer

At ADS, no idea is off limits, and we celebrate creativity and bold moves. For more than 50 years ADS has been manufacturing a variety of innovative and environmentally friendly alternatives to traditional materials. Headquartered in Hilliard, Ohio, we are a multi-billion dollar stormwater management company, manufacturing pipe and ancillary products. What does that mean? When it storms, we capture rain with our drain basins, convey it with pipe, store it using chambers and finally treat it with our water quality products, before safely returning water back to the environment. We handle, what we call, the entire lifecycle of a raindrop. Our products help prevent flooding, which increases quality of life for people living in large cities, suburbs, and rural towns. We also believe in creating a circular economy and are the largest plastic recycling company in North America. We use plastic shampoo and detergent bottles to create pipe, diverting over 500 million pounds of plastic from landfills every year. ADS operates a global network of over 60 manufacturing plants and 30 distribution centers.

We have amazing stories to tell, and we need your help getting our story out there. To learn more about ADS, please visit our website at www.adspipe.com.

This job can be performed remotely and out of state candidates will be considered.

Job Summary:

As a Data Engineer, you will be instrumental in designing, building, and maintaining our data infrastructure and pipelines that support the organization's supply chain analytics and decision-making processes. Your expertise in data modeling, ETL (Extract, Transform, Load) and ELT (Extract, Load, Transform) processes, and data integration will be crucial in transforming raw supply chain data into actionable insights. Working closely with cross-functional teams, you will play a pivotal role in optimizing our supply chain operations and enhancing our overall business performance.

Primary Job Responsibilities:

The responsibilities of this position include, but are not limited to:

+ Data Pipeline Development: Design, implement, and manage efficient data pipelines to extract, transform, and load data from various supply chain data sources into our data warehouse. Ensure data pipelines are scalable, reliable, and maintain high data quality standards.

+ Data Modeling and Optimization: Develop and maintain data models that align with supply chain processes, ensuring data structures support efficient querying and analytics. Continuously optimize data models and database performance to enable real-time and near-real-time data processing.

+ Supply Chain Data Integration: Integrate data from diverse supply chain systems, such as ERP (Enterprise Resource Planning), WMS (Warehouse Management Systems), TMS (Transportation Management Systems), and other relevant sources. Identify opportunities to streamline data integration processes and improve data accessibility.

+ Data Quality and Governance: Implement data quality checks and validation processes to ensure the accuracy and integrity of supply chain data. Adhere to data governance standards and best practices to maintain data security and compliance.

+ Data Analytics and Reporting: Collaborate with data analysts and business stakeholders to understand their data requirements and deliver meaningful insights through data visualizations and reports. Assist in the development of supply chain performance dashboards and KPI tracking tools.

+ Technology Evaluation and Adoption: Stay abreast of the latest data engineering technologies and trends in the supply chain domain. Evaluate and recommend data tools and solutions that enhance data processing and analytics capabilities.

+ Collaboration and Communication: Work closely with supply chain management, data science, and other cross-functional teams to understand their data needs and provide data engineering support. Communicate complex technical concepts to non-technical stakeholders effectively.

Requirements:

+ Bachelor's or Master's degree in Computer Science, Information Systems, Engineering, or a related field.

+ Proven experience (3+ years) as a Data Engineer, Data Integration Specialist, or similar roles in the supply chain domain.

+ In-depth knowledge of supply chain processes, data flow, and data requirements in a business context.

+ Strong proficiency in data modeling, ETL development, and data warehouse concepts.

+ Proficiency in programming languages such as Python, Java, or SQL for data processing and manipulation.

+ Familiarity with big data technologies and cloud-based data platforms (e.g., Hadoop, Spark, AWS, Azure, or Google Cloud).

+ Experience with data visualization tools and techniques.

+ Excellent problem-solving skills and ability to work in a fast-paced, collaborative environment.

ADS supports an inclusive workplace that values diversity of thought, experience, and background. We celebrate the power of our differences to create better solutions for our customers by ensuring employees can be their authentic selves each day. ADS is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, ancestry, age, physical or mental disability, sex, sexual orientation, gender identity/expression, pregnancy, veteran status, marital status, creed, status with regard to public assistance, genetic status or any other status protected by federal, state or local law.

Requisition ID: 2023-15411

External Company Name: Advanced Drainage Systems

External Company URL: http://www.ads-pipe.com/en/

Street: 3455 Mill Run Drive