Job title: IT Project Coordinator / Project Manager Excel & PMO
Location: Kohler, WI (Onsite/Locals)
Employment Type: Contract
Experience: 10+ Years
Position Overview
We are seeking a highly organized and proactive IT Project Coordinator / Project Manager with 3 5 years of experience supporting project coordination, PMO activities, reporting, stakeholder communication, and project delivery.
The ideal candidate will have strong Microsoft Excel and reporting skills, excellent communication abilities, and the ability to coordinate multiple activities across business and technical teams. This role will be responsible for maintaining project trackers, coordinating meetings, documenting action items, monitoring project milestones, and preparing accurate status reports for leadership.
Key Responsibilities
- Coordinate project meetings, workshops, working sessions, and stakeholder discussions.
- Prepare meeting agendas, capture meeting minutes, and maintain detailed action-item trackers.
- Follow up with stakeholders to ensure action items and deliverables are completed on time.
- Maintain project plans, trackers, dashboards, schedules, and status reports using Microsoft Excel.
- Consolidate project updates from multiple business and technical teams.
- Prepare weekly, monthly, executive, and ad-hoc project status reports.
- Track project timelines, milestones, deliverables, dependencies, and key activities.
- Monitor project progress and proactively identify risks, issues, delays, and dependencies.
- Escalate project risks and issues to the Project Manager or Project Lead when appropriate.
- Maintain accurate project documentation, meeting records, project artifacts, and status reports.
- Support project planning, resource tracking, budget/forecast tracking, and project communications.
- Coordinate with cross-functional teams to ensure project objectives and deadlines are achieved.
- Assist Project Managers with project governance, PMO processes, and administrative activities.
- Develop and maintain Excel-based dashboards and reports for project leadership.
- Analyze project data and provide meaningful insights to support decision-making.
- Ensure project information is accurate, current, and easily accessible to stakeholders.
- Support Agile, Waterfall, or hybrid project delivery environments.
- Assist with project closeout activities, lessons learned, and documentation.
Required Skills & Qualifications
4-5 years of experience in Project Coordination, PMO Support, Project Management, or a related role.
- Bachelor's degree in Business Administration, Information Technology, Management, or a related field preferred.
- Strong hands-on expertise with Microsoft Excel.
- Advanced Excel capabilities including:
- Pivot Tables
- VLOOKUP / XLOOKUP
- Formulas and data analysis
- Data reconciliation
- Reporting
- Dashboard preparation
- Strong proficiency with Microsoft Office Suite, including:
- Excel
- PowerPoint
- Word
- Outlook
- Microsoft Teams
- Experience coordinating meetings, documenting minutes, and tracking action items.
- Experience preparing project status reports and management-level reporting.
- Strong stakeholder communication and follow-up skills.
- Excellent organizational and multitasking abilities.
- Strong attention to detail and ability to manage competing priorities.
- Ability to work effectively with both business and technical teams.
Preferred Skills
- Experience with Jira, Smartsheet, ServiceNow, Microsoft Project, or similar project management tools.
- Knowledge of Agile, Scrum, Waterfall, or hybrid project methodologies.
- Experience supporting PMO governance and project reporting.
- Experience preparing executive-level presentations and dashboards.
- Experience working in enterprise IT environments.
- Exposure to project risk, issue, dependency, and change management processes.
Key Competencies
- Project Coordination
- PMO Support
- Project Tracking
- Microsoft Excel
- Reporting & Data Analysis
- Dashboard Preparation
- Meeting Coordination
- Stakeholder Management
- Risk & Issue Tracking
- Documentation Management
- Communication
- Organization & Planning
- Time Management
- Problem Solving
- Attention to Detail