Senior Data Engineer

Responsibilities

• Design and build scalable ELT/ETL pipelines using cloud-native technologies (e.g., Snowflake, Azure, Databricks)
• Develop and maintain bronze/silver/gold data layers (medallion architecture) 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
• Enable 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
• Contribute to architecture patterns that enable scalable and reusable data products
• Data Governance, Security & Quality
• Implement and enforce data governance standards, lineage, and metadata management
• 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, or related field
• 3–7+ years of experience in data engineering or data platform development
• Strong proficiency in SQL and Python
• Hands-on experience with cloud data platforms (Snowflake, Azure, or AWS)
• Experience building ETL/ELT pipelines and data models
• Familiarity with data warehousing concepts and medallion architecture

Preferred Qualifications

• Experience supporting AI/ML workflows or data science teams
• Knowledge of manufacturing, supply chain, or IoT data environments
• Experience with 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 and analytical thinking
• Excellent communication skills across technical and business audiences
• Ownership mindset with focus on measurable outcomes and ROI

Company Benefits

• 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.
• Why ADS: 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.

EEO Statement

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.