Job ID :
5810
Company :
Commonwealth of Pennsylvania
Location :
HARRISBURG, PA
Type :
Contract
Duration :
6 Months
Status :
Active
Openings :
1
Posted :
22 Sep 2014
Job Seekers, Please send resumes to resumes@hireitpeople.com

Short Description:

Resource will perform data collection, analysis, and dashboard creation using Excel 2012.

 

Complete Description:

The PTC has developed a Commission Wide Strategic Plan containing specific goals, objectives, measures and tactical initiatives.  In addition, each department within the PTC has developed a Business Plan to complement the Commission Wide Strategic Plan.  An important part of the  strategy for implementing the plans is the monitoring and reporting on progress of the plans and associated performance metrics.   The plans were all developed in Microsoft Excel workbooks.  The PTC has created a Strategic Planning Monitoring Team that has been tasked with the monitoring and reporting initiative and they are looking for assistance in developing a methodology for monitoring and creating Excel-based dashboards for the reporting.

        

The PTC anticipates this initiative will take approximately 3 months to complete.  Work must be performed in close coordination with the team so the resource must perform all work related activities on-site at the PTC’s Central Administration Building in Highspire, PA.

 

Skills:

Skill

Required / Desired

Amount

of Experience

MS Excel experience

Required

10

Years

MS Excel 2012

Required

2

Years

Experience with data collection and analysis

Required

8

Years

Experience with Excel based dashboard creation

Required

8

Years

Experience with securing spreadsheets, version control and change management

Required

8

Years

Working knowledge of strategic planning concepts

Required

8

Years

Excellent documentation skills

Required

 

 

Excellent verbal and wring skills

Required