BI Analyst - Finance & Sales Analytics

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

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.