Project Coordinator

We are offering an ongoing/part time contract employment opportunity for a Project Coordinator in San Ramon, California. The Project Coordinator will play a critical role in our team, focusing on project tracking and reporting. This role will involve managing a comprehensive Excel report that covers all aspects of our active and closed projects, including tracking engagement closeout reports, grant dollars, and consultant hours.

Responsibilities:

• Manage and update a comprehensive multi-tab Excel report, providing a snapshot of all active and closed projects.
• Track engagement closeout reports, grant dollars within each project, and consultant hours.
• Utilize Microsoft Office Suite, particularly Excel, Unanet timekeeping software, QuickBooks, and Salesforce.
• Upload contracts, agreements, and survey data to specific clients in Salesforce.
• Accurately document and track multiple projects in Excel, ranging from 80 to 120 projects per year.
• Initiate, plan, execute, and close projects following company methodologies.
• Document and maintain relevant information on projects, ensuring clear communication of project timelines, milestones, and dependencies.
• Foster positive relationships with internal and external stakeholders.
• Track and document funding sources by project for easy report out to the source of funds.
• Provide the business development team and client services director with hours assigned by contractor to ensure a balanced and deliverable backlog.
• Prepare and maintain client account tracking inputs and documentation.
• Handle client onboarding and ensure all required paperwork is completed accurately.
• Resolve any issues related to information accuracy, changes, updates on each project.
• Proficient in Excel Formulas and Excel VBA
• Demonstrated experience in Project Coordination
• Solid understanding of Project Management principles and best practices
• Ability to track and report Project Progress effectively
• Experience in developing and analyzing Project Metrics
• Advanced user of Microsoft Excel
• Strong problem-solving skills and the ability to make decisions based on accurate and timely analysis
• Excellent written and verbal communication skills
• Ability to manage multiple projects simultaneously and meet deadlines
• Strong interpersonal skills and the ability to work effectively in a team environment
• Bachelor's degree in business or related field, or equivalent experience.