Business Analyst

IDI Distributors Inc.; Chanhassen (MN); Hybride; USD 90 000 - 120 000; Plein temps

Avantages offerts par ce poste

Health coverage

401(k) with company match

Paid time off for vacation and hols

Life and disability insurance

Employee assistance program

Résumé du poste

IDI Distributors Inc. is seeking a Business Analyst to develop and maintain data models, BI solutions, and analytics processes that support financial and operational decision-making.

You will work with Finance and IT to deliver scalable reporting, data, and AI-enabled solutions under the FP&A director. Responsibilities include BI reporting development, data warehouse collaboration, AI enablement, stakeholder KPI definition, data governance, and thorough documentation.

Qualifications

• Advanced Power BI data modeling, DAX, dashboards and report administration.
• Experience with enterprise data warehouses, SQL databases, ETL processes.
• Strong knowledge of accounting, financial reporting, budgeting, forecasting.
• Expert Excel, VBA and 365 suite skills.
• Experience with AI-enabled solutions or process automation tools is preferred.

Responsabilités

• 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.
• Collaborate on development, maintenance, and administration of the enterprise data warehouse.
• Monitor reporting platform performance, data quality, and system reliability.
• Provide guidance on AI-enabled tools and identify AI opportunities.
• Define requirements, KPIs, and analytical solutions with stakeholders.
• Provide data analytics to FP&A and other departments to drive decisions.
• Administer reporting security, data governance, and access controls.
• Create and maintain documentation, training materials, and SOPs.
• Communicate effectively, drive results, and take initiative.

Connaissances

Power BI data modeling

DAX

Dashboard design

Data visualization

Formation

Bachelor's degree in Finance, Accounting, Business Analytics, Data Analytics, or related field

Outils

Power BI

SQL

ETL tools

Excel/VBA

Description du poste

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.