Financial Analyst
Location: Dearborn, MI
Schedule: Hybrid – 4 days onsite
Pay Rate: Between $30-40/hour, will be discussed
Contract: 3-4 months
Position Description
The Planning & Integration Analyst will support the Director’s Planning & Integration team within a Tier 1 Automotive’s Supply Chain IT, focusing on Purchase Orders for operational expenses and investment, financial tracking, and cross-functional coordination. This role involves purchase order forecasting and actual payment tracking, consolidating organizational data, and presenting insights to senior leadership using clear storytelling and creative visualization.
You will partner closely with supervisors, Finance, and the IT Business Office to support monthly financial processes, forecasting, purchase order management, and other operational needs. This position also includes learning and applying SharePoint administration skills to maintain departmental sites, permission groups, and content governance.
Key Responsibilities
- Collect monthly Purchase Orders (POs) forecasting from supervisors and consolidate data for leadership reviews.
- Develop clear, compelling data stories using charts, graphics, and visual summaries (Excel, PowerPoint, AI-generated visuals when appropriate).
- Track monthly actual financial spending, enter future financial forecasts, and provide supporting analysis.
- Collaborate with the Integration Team Supervisor to fulfill diverse requests from Finance and the IT Business Office.
- Utilize Excel as a primary data source and apply AI tools to enhance clarity and creativity in executive-level presentations.
- Learn and administer SharePoint department sites, including permissions, content organization, and best-practice governance.
Skills Required
Required Skills & Experience
- Strong capability to manage resource/headcount data and understand associated financial impacts.
- Ability to collect and consolidate data monthly from cross-functional supervisors.
- Strong communication skills and the ability to visualize, storytell, and explain data clearly for leadership audiences.
- Experience supporting financial processes, including monthly spend tracking and forecasting.
- Ability to collaborate with Finance and other IT business functions to support requests and analysis needs.
- Proficiency with Excel, PowerPoint, and AI-driven presentation or visualization tools.
- Interest in learning SharePoint administration and applying best practices.
Experience Required
- 3+ years in Accounting or IT Analysis.
- 3+ years using Excel for data analysis (financial or operational).
- 3+ years with Microsoft Office (PowerPoint, Outlook, SharePoint, etc.).
Preferred Skills & Experience
(Not required, but a plus)
- SharePoint administration experience
- Agile experience
- Organizational Change Management exposure
- Financial analysis experience
Education
- Required: Bachelor’s degree
- Preferred: Bachelor’s degree in IT, Finance, or a related analytical discipline
#LI-NL1