Purpose of the role -
Position Purpose: Provide Portfolio, Finance and Project level reporting for the US Program Management Office, Senior Management and Group.
Deliverables:
Develop Microsoft Access queries for reporting purposes.
Analyze project and financial data in MS Excel, utilizing advanced functions such as PivotTables and lookup formulas.
Run existing weekly/monthly/adhoc queries as needed and validate the results.
Develop and update requirements/procedures for processes and reporting.
Provide testing, data entry, or other assistance as needed.
Other duties as needed.
Technical Knowledge:
7+ years experience with Microsoft Access, Excel, and Visio.
1 - 3 years experience in a Project Management or PMO environment.
Experience with Executive Report development.
Must possess excellent analytical, communication and problem solving skills.
Ability to manage multiple priorities and manage day-to-day activities within tight deadlines.
Ability to think, act, and work independently as well as in a cross-functional environment.
Ability to interact with all levels within the organization.
Knowledge of the following technologies is highly preferred: HP PPM tool (PACS), SQL, Microsoft Word, Microsoft Project, SharePoint, and Minitab.