Financial Data Analyst: AI-Driven Forecasts & Dashboards

EPITEC; Allen Park (MI); Hybrid; USD 69,000 - 76,000; Full time

Benefits offered by this job

Medical

Dental

Vision

PTO & 401K

Job summary

EPITEC in Allen Park, MI is seeking a Financial Data Analyst to support the Supply Chain IT Planning and Integration team. The role will manage purchase order forecasts, actual spending, financial reporting, and headcount planning.

You will analyze data using Excel and Power BI, create dashboards, and use AI tools to tell clear, leadership-ready stories. The position requires strong Excel and Power BI skills, plus the ability to present complex data in executive-ready formats.

Qualifications

• Experience using Excel for forecasting and monthly reporting.
• Proficiency in building dashboards in Power BI.
• Strong data storytelling and presentation skills, with clear communication.
• Experience with AI-enabled analytics tools is a plus.

Responsibilities

• Manage purchase order forecasts and monthly financial reporting.
• Gather and consolidate supervisor headcount plans for leadership.
• Analyze financial and operational data using Excel and Power BI.
• Develop dashboards, charts, and executive PowerPoint presentations.
• Use AI tools (e.g., Copilot) to enhance analysis and data storytelling.
• Present trends, conclusions and performance insights clearly and visually.
• Provide backup support for monthly PO forecasting and actual-payment tracking.
• Collaborate with Finance, IT Business Office and Integration leadership on ad hoc requests.

Skills

Excel

Power BI

PowerPoint

AI Copilot

Data analysis

Job description

EPITEC in Allen Park, MI is seeking a Financial Data Analyst to support the Supply Chain IT Planning and Integration team. The role will manage purchase order forecasts, actual spending, financial reporting, and headcount planning.

You will analyze data using Excel and Power BI, create dashboards, and use AI tools to tell clear, leadership-ready stories. The position requires strong Excel and Power BI skills, plus the ability to present complex data in executive-ready formats.