Data-Driven Business Analyst: BI Insights & Dashboards

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

Job summary

Infiltrator Water Technologies LLC in Old Saybrook, CT is seeking a Business Analyst to join our corporate Finance and Sales analytics team. You will design, develop, and modernize reporting and performance insights across multiple data sources to enable better decision-making.

You will build Power BI dashboards, automate reports, support budgeting and forecasting, and partner with IT on data quality and governance while communicating findings to leadership.

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

Power BI

Power Query

SQL

Excel

Education

Bachelor's degree in Business/Finance/Accounting/Economics/IS/Data Analytics

Tools

Power BI

Power Query

SQL

ERP systems

Job description

Infiltrator Water Technologies LLC in Old Saybrook, CT is seeking a Business Analyst to join our corporate Finance and Sales analytics team. You will design, develop, and modernize reporting and performance insights across multiple data sources to enable better decision-making.

You will build Power BI dashboards, automate reports, support budgeting and forecasting, and partner with IT on data quality and governance while communicating findings to leadership.