2018 Summer Internship - Budget and Finance

Responsibilities

The Global Managed Services Group (GMS) of Canon Solutions America (CSA) is looking for qualified interns to join our Business Controlling team. Our department handles a variety of functions including P&L Analysis, Operational Reporting, Budget Development, and Expense Management across multiple Business Units.

Intern should be prepared to work in a fast-paced environment, and will finish the internship having gained broad experience in various aspects of corporate business.

Develop a method or tool in Excel, Access, or Power BI that simplifies the audit of monthly financial expenses
Utilize tool to audit YTD expenses incurred by the Enterprise Managed Services Division of GMS
Coordinate with EMSD Operations, GMS Account Services, CSA Billing, CSA Accounting, and other impacted departments to research and correct errors, driving P&L accuracy
Present results and process recommendations to GMS Management team
Become familiar with existing financial reporting and make recommendations to improve structure and content
Work within Power BI to develop consolidated reporting templates and Dashboards for use in improving delivery and financial management capabilities. May include partnerships with both internal and external resources.

Qualifications

Majors: Finance, Data Analytics, Business Administration or related subject
Written and verbal communication skills
Microsoft Excel, PowerPoint
Experience with Access and/or Power BI is a strong plus

Candidates must have proficiency in Microsoft Excel, including pivot tables, vlookup, sumifs, index/match. The ideal candidate has excellent analytical and research capabilities, strong verbal and written skills, and be equally motivated to work both with a team and on independent projects.