Business Analyst

Idi-Distributor; Chanhassen (MN); Hybrid; USD 85,000 - 110,000; Full time

Benefits offered by this job

Health coverage

401(k) with company match

Paid time off

Life insurance

Disability insurance

Employee assistance program

Job summary

Idi-Distributor is seeking a Business Analyst to develop and maintain data models, BI solutions, and analytics processes supporting financial and operational decision-making. You will report to the Director of FP&A and work with Finance and IT to deliver scalable reporting, data and AI-enabled solutions.

The role emphasizes BI development, data governance, and collaboration with stakeholders to define KPIs, ensure data quality, and provide analytics to FP&A and other departments.

Qualifications

• 4+ years of experience in data analytics and financial modelling.

Responsibilities

• Develop and maintain Power BI semantic models, dashboards, and reports.

Skills

Power BI

Data modeling

DAX

Excel

Generative AI

Forecasting

Education

Bachelor's degree in Finance

Business Analytics degree

Tools

SQL

ETL

Excel VBA

Power BI

Job description

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.

Responsibilities/Duties:

• 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.
• 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, or related field
• 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.

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.