FP&A Analyst: AI-Driven Dashboards & Power BI

Evolution Motion Solutions; Auburn Hills (MI); On-site; USD 70,000 - 100,000; Full time

Job summary

Evolution Motion Solutions in Auburn Hills, MI seeks an FP&A Financial Analyst to drive planning, budgeting, and reporting processes. You will build models, dashboards, and analyses that convert financial data into actionable insights for leadership, with emphasis on automation and AI tools for faster decision support.

The role collaborates with sales, operations, and finance teams, delivering timely analyses and recommendations to improve profitability and strategic initiatives.

Qualifications

• Two to three years of related experience in financial planning and analysis, accounting, or business analytics.
• Hands-on experience building and maintaining reports and dashboards in Power BI.
• Experience with Epicor Prophet 21 (P21) or a comparable distribution ERP is a plus.
• Coursework, certification, or demonstrated self-study in business intelligence, data analytics, or AI tools preferred.

Responsibilities

• Prepares daily, weekly, monthly, quarterly, and annual financial reports and delivers them to business leaders on schedule.
• Conducts variance analysis of actual results to budget and prior year and clearly explains the key drivers.
• Performs profitability analysis by product category, end market, business unit, vendor, and individual customer.
• Builds, publishes, and maintains Power BI dashboards and reports that give leaders self-service access to key metrics.
• Performs ad hoc analysis as needed.

Skills

Power BI

Advanced Excel

AI tools usage

ERP data extraction

Analytical thinking

Communication skills

Problem solving

Time management

Data modeling

Education

Bachelor’s degree in finance, accounting, economics, data analytics or a related field

Tools

Epicor Prophet 21 (P21)

Job description

Evolution Motion Solutions in Auburn Hills, MI seeks an FP&A Financial Analyst to drive planning, budgeting, and reporting processes. You will build models, dashboards, and analyses that convert financial data into actionable insights for leadership, with emphasis on automation and AI tools for faster decision support.

The role collaborates with sales, operations, and finance teams, delivering timely analyses and recommendations to improve profitability and strategic initiatives.