IT Data Engineer

Advanced Drainage Systems, Inc.
Hilliard, OH, United States
5 days ago
Apply on careers-adspipe.icims.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience required
1 year minimum
Working hours
Regular working hours

Tech stack

Application Programming Interfaces (APIs) Artificial Intelligence Amazon Web Services Data Analysis Microsoft Azure Business Intelligence Development Information Systems Data Cleansing Information Engineering Data Governance Data Infrastructure Data Integration
+25 more
Extract Transform Load (ETL) Data Transformation Data Warehousing Software Design Patterns Digital Assets Dimensional Modeling Python (Programming Language) Machine Learning Meta-Data Management Microsoft SQL Server Power BI Cloud Services SQL Databases SQL Server Analysis Services Feature Engineering Snowflake Containerization Information Technology Apache Kafka Data Management Machine Learning Operations Video Streaming Data Pipelines Legacy Systems Databricks

Job description

Advanced Drainage Systems (ADS) is seeking a Data Engineer to build and support modern data pipelines and AI-ready data platforms that improve operational visibility, manufacturing insights, and enterprise analytics.

This role will contribute to ADS’s data modernization initiative by developing reliable, scalable data assets in partnership with senior engineers, analytics teams, and business stakeholders. The ideal candidate has strong data engineering fundamentals, hands-on experience with SQL and Python, and an interest in supporting AI/ML, IoT data integration, and enterprise reporting use cases., Data Engineering & Platform Development

  • Build and enhance scalable ELT/ETL pipelines using cloud-native technologies such as Snowflake, Azure, or Databricks
  • Develop and maintain bronze/silver/gold data layers (medallion architecture) under established design patterns for analytics and AI consumption
  • Integrate data from ERP, manufacturing systems, IoT sensors, and third-party platforms into a unified data environment
  • Ensure high data quality, reliability, and performance across pipelines

AI & Advanced Analytics Enablement

  • Engineer datasets optimized for machine learning and AI models
  • Partner with data scientists and analytics teams to support predictive maintenance, demand forecasting, and anomaly detection use cases
  • Implement data pipelines that support real-time or near-real-time analytics where applicable
  • Enable feature engineering and model-ready datasets

Data Integration & Modernization

  • Support migration from legacy platforms (e.g., SQL Server/SSAS) to modern cloud data platforms
  • Build and maintain integrations using tools such as Informatica, APIs, and streaming frameworks
  • Follow established architecture patterns that enable scalable and reusable data products

Data Governance, Security & Quality

  • Apply data governance standards, lineage, and metadata management within assigned work
  • Ensure compliance with data security and privacy policies
  • Monitor and improve data quality and pipeline performance metrics

Collaboration & Business Alignment

  • Partner with business stakeholders (Manufacturing, Supply Chain, Sales) to understand data needs
  • Work closely with analytics engineers, BI developers, and SMEs to deliver trusted data assets
  • Translate business requirements into scalable data solutions

Requirements

  • Bachelor’s degree in Computer Science, Engineering, Data Science, Information Systems, or related field
  • 1-4 years of experience in data engineering, data integration, analytics engineering, or data platform development
  • Strong proficiency in SQL and Python
  • Experience or working knowledge of cloud data platforms (Snowflake, Azure, Databricks, or AWS)
  • Experience building ETL/ELT pipelines and data models
  • Familiarity with data warehousing concepts, dimensional modeling, and modern data architecture patterns, * Exposure to AI/ML workflows or data science teams
  • Knowledge of manufacturing, supply chain, or IoT data environments
  • Exposure to Informatica, Databricks, or streaming technologies (Kafka/Event Hub)
  • Understanding of data governance frameworks and data quality tools
  • Exposure to Power BI or modern BI tools

Key Competencies

  • Strong problem-solving, curiosity, and analytical thinking
  • Ability to deliver quality work while learning scalable engineering practices
  • Excellent communication skills across technical and business audiences
  • Ownership mindset with focus on continuous improvement and reliable delivery

Benefits & conditions

Health & Welfare Benefits: Medical and prescription drug plans, telemedicine (with medical plan), High-Deductible Health Plan (HDHP) and Health Savings Account (HSA), dental and vision plans, virtual physical therapy, an employee assistance program (EAP), and voluntary accident, critical illness, and hospital indemnification programs.

Financial Benefits: Retirement 401k program with company match, an employee stock purchase plan (voluntary), financial wellness planning, paid parental leave, flexible spending accounts (FSA) for child care and health care, short-term and long-term disability, basic life insurance, accidental death and dismemberment (AD&D), adoption financial reimbursement, tuition reimbursement, voluntary life insurance (for employees, spouses, and children), and voluntary identity theft and fraud protection.

*100% paid by ADS.

About the company

Advanced Drainage Systems is a leading manufacturer of stormwater and onsite septic wastewater solutions, committed to sustainability and innovation. With a vast manufacturing and distribution network, we deliver high-quality products across multiple industries while recycling over half a billion pounds of plastic annually. At ADS, we foster a culture where diverse perspectives drive better ideas, ensuring every employee feels valued, heard, and empowered to make an impact., Growth Opportunities & Global Presence: With a global network of approximately 70 manufacturing plants and 40 distribution centers, ADS offers extensive opportunities for career growth and development in various locations around the world.

Inclusive and Creative Work Culture: ADS fosters a culture of passion, innovation, and continuous improvement, empowering employees to shape industry-leading solutions. We value diverse perspectives, recognizing that they drive better ideas, processes, and performance. Our workplace is built on respect, inclusivity, and shared responsibility, ensuring every team member feels valued and contributes to our collective success.

Innovative & Sustainability Focused: Advanced Drainage Systems is one of the largest plastic recyclers in North America, ensuring over half a billion pounds of plastic is kept out of landfills every year.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on careers-adspipe.icims.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

1:24 min

Moving the semantic layer upstream to avoid vendor lock-in

Piotr Menclewicz Piotr Menclewicz · Europe 2026 Virtual

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

1:33 min

Integrating internal APIs and maintaining data sovereignty

Mahran Meißner Mahran Meißner · World Congress 2026 Europe

2:27 min

Managing traffic and tracking costs with Databricks Unity Catalog

Viktoria Semaan Viktoria Semaan · World Congress 2026 Europe

3:48 min

Standardizing data access schemas with OData

Florian Bader Florian Bader · World Congress 2026 Europe

2:46 min

Transforming data architecture from on-premise to cloud

Sandhya Menon Sandhya Menon · World Congress 2026 Europe

Videos

See all

Related articles

See all