AI-Enabled BI & Financial Analytics Analyst

IDI Distributors Inc.; Chanhassen (MN); Hybrid; USD 90,000 - 120,000; Full time

Benefits offered by this job

Health coverage

401(k) with company match

Paid time off for vacation and hols

Life and disability insurance

Employee assistance program

Job summary

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.

Responsibilities

• 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.

Skills

Power BI data modeling

DAX

Dashboard design

Data visualization

Education

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

Tools

Power BI

SQL

ETL tools

Excel/VBA

Job description

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.