BI Analyst – Power BI & Financial Analytics

Infiltrator Water Technologies; Old Saybrook (CT); On-site; USD 70,000 - 95,000; Full time

Benefits offered by this job

Health benefits

401k with company match

Employee stock purchase plan

Tuition reimbursement

Parental leave

Job summary

Infiltrator Water Technologies seeks a Business Analyst to design and modernize reporting and analytics across Finance, Sales, Operations, and IT. You will translate requirements into scalable dashboards, KPIs, and automated reports using Power BI, Power Query, and SQL, supporting budgeting and monthly close with data-driven insights.

The role emphasizes data quality, cross-functional partnerships, and driving efficiency by automating recurring reporting processes while delivering actionable

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.

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.

Skills

Excel

Power BI

Power Query

SQL

Data analysis

Communication

Stakeholder management

Attention to detail

Education

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

Tools

Power BI

Power Query

ERP systems

CRM platforms (Salesforce, Dynamics)

Job description

Infiltrator Water Technologies seeks a Business Analyst to design and modernize reporting and analytics across Finance, Sales, Operations, and IT. You will translate requirements into scalable dashboards, KPIs, and automated reports using Power BI, Power Query, and SQL, supporting budgeting and monthly close with data-driven insights.

The role emphasizes data quality, cross-functional partnerships, and driving efficiency by automating recurring reporting processes while delivering actionable