IT Financial Analyst

• The client is looking for an IT Financial Analyst to join a client remotely in Mexico.
• The IT Accountant will be focused within financial planning/forecasting within the Chief Technology Office organization.
• You will need to be comfortable collaborating with program delivery leads/program managers/project managers/IT leaders to maintain an understanding of project deliverables as estimated and planned.
• You will create POs and process reoccurring inbound and outbound invoices.
• You will partner with the client and various internal sector finance groups to release budgets in a timely manner after project investment approvals are made.
• You will also present financial reviews with leadership each period and prepare and present forecast details.
• Presentation to a include period and year to date actuals vs plan, period variance explanation, remainder of year period forecast.

• 2+ years of experience working as an Financial Analyst
• Expert level excel skills (formulas, pivot tables, VLOOKUPs, raw data analysis)
• Experience in accounting, financial planning, forecasting, and budgeting
• Excellent written and verbal communication skills.
• Strong ability to present and speak to period forecasts
• Strong ability to partner with multiple PepsiCo internal teams and external partners so to effectively manage and deliver period forecasts within plan.

NICE TO HAVE SKILLS AND EXPERIENCE:

• Ability to create Macros in Excel
• Experience managing IT project finances
• Experience managing $10 million+ budgets
• Experience managing SAP Hyperion dashboards
• Proven ability to track and create POs, reoccurring inbound and outbound invoices, reconciliations
• Strong ability to consolidate and repo