Randstad Project Coordinator (MS Project, Excel, SharePoint) in Minneapolis, Minnesota

Project Coordinator (MS Project, Excel, SharePoint)


Minneapolis, MN

Date Posted:

Friday, October 14, 2016

Job Type:


Reference #:



Randstad Technologies

apply now


Project Coordinator (MS Project, Excel, SharePoint)

Business Overview:

Project Description:

Support the PCM, IT Project /Program Manager and other team members (as needed) with day-to-day project/program activities.

Key responsibilities include:

Financials Management (50%)

  • Manage the program financials process including program forecasting and analysis, as well as monthly/weekly financial tracking.

  • Weekly follow up with PM s and/or team members to ensure time is entered into the correct ACE/PPM project, and escalate to Program Management when needed.

  • Create weekly financial reports for Shared Services teams: utilizing pivot tables

  • Consolidating and organizing resource plans within excel

  • Monthly forecasting for Shared Services teams

  • Shared Services estimate creation and tracking

Resource Management (15%)

  • Manage program on-boarding process and controls.

  • Coordinate 1st Day start info for new resources

  • Order/update other hardware needs

  • Update distribution lists with added/deleted resources

  • Update Seating and Org Charts with added/deleted resources

  • Weekly time approval

  • ServiceNow ticket management and reports

Manage Project Repository via SharePoint (15%)

  • Create/maintain sub-sites for assigned projects

  • Organize project documents & keep up to date

  • Archive outdated documents

  • Manage access and permissions for assigned project sites

Project Plan Management (5%)

  • Use of MS Project to update Project Plans for assigned projects, managing tasks

  • Manage ACE/PPM Tasks for Project: Add new resources, allocate hours, update program milestone dates, open/close out program level tasks - milestones, new projects, etc., follow up with task owners to ensure the item is updated/completed

  • Establish high level milestones for project

  • Escalation of at risk tasks to program leadershi

  • Update program level decks as iterations/scope changes

  • Create weekly project status reports

Meetings (5%)

  • Update meeting invitations with added/deleted attendees

  • Assign conference call numbers and meeting rooms

  • Attend and/or facilitate meetings for assigned projects

  • Take notes in meetings and publish to attendees

  • Follow up with Action Item owners

  • Facilitate stand up, retrospectives, and planning sessions as needed

Ad Hoc Reporting (10%)

  • Weekly status report for assigned projects and CDC summary report

  • Maintain CDC Release Calendar and accompanying reports

Skills Overview:

What are the MUST have skills that you are looking for in a candidate?

  • Must have PPM knowledge/MS project experience

  • Must have strong Project Financials/Project Finance/Financial Analyst Skills, with scenario based forecasting and analysis

  • 2 or more years of Project Coordinator experience

  • 2 or more years of experience with MS Project, SharePoint, PowerPoint, Excel

  • Knowledge of Project Development Life cycle

  • IT Knowledge

Preferred requirements:

  • Experience in project environment either with Agile or Waterfall methodology- preferred

  • SharePoint admin experience

  • 1+ Experience with Excel- Pivot tables for Financial tracking- preferred

  • Exposure to/knowledge of IT Infrastructure basics is a plus

  • Bachelor s Degree in Finance or Mathematics

  • Experience with accounts payable or accounts receivable

What are the technologies and the depth of the technologies that a candidate must have in order to be successful in this role?

Microsoft Office:

  • Excel - Must have strong proficiency in this.

  • Project

  • PowerPoint

  • SharePoint

What are the soft skills that you feel candidates must-have in order to be successful in this role?

  • Candidate must have a strong personality, be able to take initiative and ask questions

  • Strong organizational skills managing multiple task

  • Great written and verbal communication skills

  • Ability to work independently with little to no direction

  • Culture fit is Critical

  • Adaptable- fast pace environment

  • Ability to change work direction easily

  • Collaborative

Please provide three industries that would produce fitting candidates:

  • Retail is ideal, but open to any industry with this type of skillset.

Interview Process Overview ( Ideally would like to interview 10/20 ):

  • 30 min phone screening

  • 60 minute in person

    apply now