Business Analyst

Infiltrator Water Technologies (Decentralized Wastewater Treatment Solutions); Old Saybrook (CT); On-site; USD 70,000 - 100,000; Full time

Job summary

Infiltrator Water Technologies in Old Saybrook, CT is seeking a Business Analyst to design and modernize reporting across Finance and Sales. You will transform data into actionable insights, build dashboards, and support forecasting by connecting multiple data sources.

You will collaborate with Sales, FP&A, Operations, and IT to deliver scalable analytics, improve data quality, and implement automated solutions that drive faster, better decision-making in a fast-paced environment.

Qualifications

• Bachelor's degree in related field.
• 2–3 years in business analysis, sales analytics, financial analysis, business intelligence, or reporting.
• Proficient in Microsoft Excel (Power Query, PivotTables, dynamic formulas).
• Hands-on experience with Power BI and Power Query; build interactive dashboards and automated reporting.
• Working knowledge of SQL for querying, validating, and analyzing data.
• Experience with relational databases, data warehouses, or data lake environments and data modeling.
• Experience with ERP systems and CRM platforms such as Microsoft Dynamics or Salesforce.
• Ability to translate complex requirements into scalable reporting, dashboards, and analytics.
• Strong analytical, problem-solving, and communication skills.

Responsibilities

• Partner with Finance, Sales, Operations, and IT to translate business requirements into scalable reporting and analytical solutions.
• Design, develop, and maintain daily, weekly, and monthly reporting from multiple data sources.
• Build analytical views that explain performance drivers such as price, volume, product mix, and customer mix.
• Develop and maintain Power BI dashboards, KPIs, and metrics for Finance, Sales, and Operations.
• Support budgeting, forecasting, and monthly close with performance analysis.
• Modernize reporting with automated dashboards and standardized reporting solutions.
• Identify opportunities to automate recurring reporting processes and improve efficiency.
• Validate and reconcile reporting across multiple systems to ensure data accuracy.
• Collaborate with IT on data architecture, integration, and governance.
• Document reporting logic and KPI definitions for governance.
• Present findings and recommendations to Finance and leadership.

Skills

Power BI

Excel

SQL

Data analysis

Stakeholder management

Education

Bachelor's degree in Business, Finance, Accounting, Economics, Information Systems, Data Analytics, or related field

Tools

Dynamics or Salesforce CRM

Power Automate

Job description

Overview

Headquartered in Old Saybrook, CT, Infiltrator Water Technologies is the leading provider of engineered plastic chambers, synthetic aggregates, tanks, advanced wastewater treatment systems, and accessories for the onsite/decentralized wastewater and storm water management industries. The majority of Infiltrator products are manufactured from recycled plastic. Founded in 1987, we operate throughout the US and Canada with 8 manufacturing plants in the US, dedicated sales, and corporate team members. Infiltrator is a pioneer in innovative plastic technologies for underground water management. Infiltrator components are used in most onsite septic systems installed in the United States and Canada. Infiltrator is a proud Corporate Partner of Habitat for Humanity and each year donates components for 50 septic systems serving Habitat homes in North America. Infiltrator is committed to advancing the state of the art in all fronts, including product design, manufacturing, materials, wastewater science, marketing, management, and employee development. In other words, we strive to be the best we can be.

Overview

Headquartered in Old Saybrook, CT, Infiltrator Water Technologies is the leading provider of engineered plastic chambers, synthetic aggregates, tanks, advanced wastewater treatment systems, and accessories for the onsite/decentralized wastewater and storm water management industries. The majority of Infiltrator products are manufactured from recycled plastic. Founded in 1987, we operate throughout the US and Canada with 8 manufacturing plants in the US, dedicated sales, and corporate team members. Infiltrator is a pioneer in innovative plastic technologies for underground water management. Infiltrator components are used in most onsite septic systems installed in the United States and Canada. Infiltrator is a proud Corporate Partner of Habitat for Humanity and each year donates components for 50 septic systems serving Habitat homes in North America. Infiltrator is committed to advancing the state of the art in all fronts, including product design, manufacturing, materials, wastewater science, marketing, management, and employee development. In other words, we strive to be the best we can be.

Responsibilities

The Business Analyst supports the Finance and Sales organizations by designing, developing, and modernizing reporting, analytics, and performance insights. This role partners closely with Sales, FP&A, Operations, and IT to transform data into actionable business intelligence that enables faster and better decision-making. The successful candidate combines strong analytical skills with financial acumen and will help to build the next generation of reporting capabilities by integrating data across multiple systems and data sources, developing automated dashboards, improving data quality, and expanding analytical capabilities.

Core Responsibilities

• Partner with Finance, Sales, Operations, and IT to translate business requirements into scalable reporting and analytical solutions.
• Design, develop, and maintain daily, weekly, and monthly sales and financial reporting using data from multiple data sources.
• Build analytical views that explain business performance through drivers such as price, volume, product mix, customer mix, new products, and new distribution channels.
• Develop and maintain Power BI dashboards, KPIs, and performance metrics that provide actionable insights for Finance, Sales, and Operations.
• Support budgeting, forecasting, and monthly close with business performance analysis.
• Modernize existing reporting by replacing manual and spreadsheet-based processes with automated dashboards and standardized reporting solutions.
• Identify opportunities to automate recurring reporting processes, reduce reporting cycle times, and improve reporting efficiency.
• Validate and reconcile reporting across multiple systems and data sources to ensure data accuracy and consistency.
• Collaborate with Business Systems and IT on data architecture, data integration, data quality, and reporting enhancements.
• Document reporting logic, KPI definitions, business rules, and reporting processes to establish consistent data governance.
• Present analytical findings and recommendations to Finance and business leadership.

Experience, Educational, And Technical Qualifications

• Bachelor's degree in Business, Finance, Accounting, Economics, Information Systems, Data Analytics, or a related field.
• 2-3 years of experience in business analysis, sales analytics, financial analysis, business intelligence, or reporting.
• Strong proficiency in Microsoft Excel, including Power Query, PivotTables, dynamic formulas, and advanced analytical functions.
• Hands-on experience with Microsoft Power BI and Power Query. Demonstrated ability to build interactive dashboards, semantic data models, and automated reporting.
• Working knowledge of SQL for querying, validating, and analyzing data.
• Experience working with relational databases, data warehouses, or data lake environments, including an understanding of data modeling, data relationships, and reporting architecture.
• Experience working with ERP systems, understanding financial and operational data structures, and CRM platforms such as Microsoft Dynamics or Salesforce.
• Demonstrated ability to translate complex business requirements into scalable reporting, dashboard, and analytical solutions.
• Strong analytical, problem-solving, and critical thinking skills.
• Excellent communication and stakeholder management abilities.
• Ability to manage multiple priorities in a fast-paced environment while maintaining high attention to detail.

Preferred Qualifications

• Experience supporting Finance, Sales Operations, or Commercial Analytics.
• Understanding of sales reporting, customer and product analytics, and KPI development.
• Experience with budgeting, forecasting, financial reporting, and driver-based variance analysis.
• Experience with Microsoft Power Automate or similar workflow automation platforms.
• Interest in AI-enabled analytics, reporting automation, and business intelligence modernization.

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.

• 100% paid by ADS.

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.