IT Data Engineer

Advanced Drainage Systems • Hilliard, OH

3d

About The Position

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.

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

Nice To Haves

• 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

Responsibilities

• 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
• 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
• 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
• 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
• 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

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
• Employee assistance program (EAP)
• Voluntary accident, critical illness, and hospital indemnification programs
• Retirement 401k program with company match
• 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)
• Voluntary identity theft and fraud protection

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level