Business Analyst

IDI: Insulation Distributors Inc.; Chanhassen (MN); On-site; USD 72,000 - 102,000; Full time

Benefits offered by this job

Health, dental, vision insurance

401(k) with company match

Paid time off

Life and disability insurance

Employee assistance program

Job summary

IDI: Insulation Distributors Inc. is seeking a Business Analyst to develop data models, BI solutions, and analytics to support financial and operational decision-making. This role collaborates with Finance and IT to deliver scalable reporting and AI-enabled solutions.

The ideal candidate will design and maintain Power BI models, financial and operational data structures, and engage in governance, security, and documentation while partnering with FP&A to drive KPI-driven insights.

Qualifications

• 4+ years in data analytics and financial modelling.
• Proficiency in Power BI, SQL, and Excel.
• Experience with ERP environments and financial reporting.
• Experience in distribution/manufacturing/industrial environments preferred.

Responsibilities

• Develop and maintain data models, BI solutions, reporting platforms.
• Deliver ad hoc analysis and insights for FP&A and operations.
• Govern data security, governance, and access controls.
• Collaborate with IT and Finance on data governance and AI enablement.

Skills

Power BI

Data modeling

DAX

SQL databases

ETL processes

Excel

VBA

AI-enabled solutions

Education

Bachelor’s degree in Finance or related field

Tools

Enterprise data warehouses

Job description

Job Summary: Compensation: $72,142 - $101,500 The Business Analyst is responsible for developing and maintaining data models, business intelligence solutions, reporting platforms, and analytics processes that support financial and operational decision-making. This position reports to the Director of Financial Planning & Analysis and works closely with Finance and IT to deliver scalable reporting, data, and AI-enabled solutions.

• Business Intelligence & Reporting Development
• Develop and maintain Power BI semantic models, dashboards, and reports.
• Design, develop, and maintain financial and operational data models.
• Deliver ad hoc analysis, business insights, and special projects as needed.
• Data Warehouse & Data Management
• Collaborate on the development, maintenance, and administration of the
• enterprise data warehouse.
• Monitor and improve reporting platform performance, data quality, and system reliability.
• Design, develop, and maintain financial and operational data models.
• AI Enablement & Technical Leadership
• Provide guidance and subject matter expertise on AI-enabled tools and applications.
• Partner with stakeholders to identify opportunities for AI-driven solutions.
• Business Partnership & Analytics
• Partner with business stakeholders to define requirements, KPIs, and analytical solutions.
• Provide data analytics to FP&A and other departments to drive business decisions.
• Data Governance, Security & Administration
• Administer reporting security, data governance, and access controls.
• Documentation, Training & Process Improvement
• Create and maintain documentation, training materials, and standard operating procedures.

Leadership Competencies:

• Leads Self
• Communicates Effectively & Candidly
• Drives for Results
• Demonstrates Accountability
• Takes Initiative
• Collaborates

Qualifications/Skills:

• Advanced Power BI skills - data modeling, DAX, dashboard design, and report administration
• Experience working with enterprise data warehouses, SQL databases, ETL processes
• Strong knowledge of accounting, financial reporting, budgeting, forecasting
• Expert level skills in Microsoft Excel, VBA and 365 Software Suite
• Experience with AI-enabled solutions, generative AI, or process automation
• tools is preferred

Education and Experience:

• Four or more years of experience in data analytics and financial modelling
• Bachelor’s degree in Finance, Accounting, Business Analytics, Data Analytics,
• Experience working within an ERP environment, supporting financial reporting processes
• Experience in a distribution, manufacturing, wholesale, or industrial environment is preferred

One of the core values at IDI is Family, and it shows in our benefits! From health coverage (medical, dental, vision) to a 401(k) with a company match, we take care of our team members. Enjoy paid time off for vacation and holidays, plus perks like life and disability insurance and an employee assistance program to support you when you need it most. We know that benefits are an important part of your compensation package, so we’ll share full details on eligibility and benefits during the hiring process.