Financial Data Analyst

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

Job Title: Financial Data Analyst

Location: Allen Park, Michigan

Job Type: W2 Contract

Expected hours per week: 40 hours

Schedule: Hybrid

Pay Range: $50-55 an hour

Job Description

This role supports the Supply Chain IT Planning and Integration team by managing purchase order forecasts, actual spending, financial reporting, and headcount planning. The analyst will use Excel, Power BI, PowerPoint, and AI tools such as Microsoft Copilot to analyze finance data, create dashboards and visualizations, and communicate clear, leadership-ready insights.

Key Responsibilities

• Manage purchase order forecasts, actual spending, and monthly financial reporting.
• Gather and consolidate supervisor headcount plans for senior leadership.
• Analyze financial and operational data using Excel and Power BI.
• Develop dashboards, graphs, and executive-level PowerPoint presentations.
• Use AI tools, including Microsoft Copilot, to enhance analysis and data storytelling.
• Present trends, conclusions, and performance insights in a clear, visually engaging format.
• Provide backup support for monthly purchase order forecasting and actual-payment tracking.
• Partner with Finance, the IT Business Office, and Integration leadership on ad hoc requests.

Benefits

Medical, Dental, Vision, PTO & 401K