- Company Name
- Mastech Digital
- Job Title
- Project Coordinator- Data Analyst
- Job Description
-
**Job Title**
Project Coordinator – Data Analyst
**Role Summary**
Coordinate and execute the migration of third‑party vendors to a new remote connectivity process. Manage vendor outreach, track progress in Excel/Smartsheet, maintain risk logs, produce executive‑ready status reports, and ensure all changes meet security/compliance standards.
**Expectations**
- Team player with a customer‑focused mindset.
- Highly organized, capable of juggling multiple vendors and deadlines.
- Proactive communicator; able to draft clear vendor communications and present updates to managers and directors.
- Self‑directed, able to work remotely within US Eastern Standard Time.
**Key Responsibilities**
1. **Vendor Engagement & Communication** – Build & maintain vendor contact roster, create and send communications (emails, FAQs, timelines), schedule and host briefings, capture Q&A, decisions, and follow‑ups.
2. **Project Coordination & Tracking** – Own migration tracker (Excel or Smartsheet); record status, milestones, dependencies, risks; maintain RAID logs and action item lists; coordinate internal meetings, agendas, and notes.
3. **Reporting & Executive Deliverables** – Produce weekly RAG status reports with metrics and narratives; craft concise PowerPoint decks for directors and leadership; maintain a centralized source of truth (SharePoint/Teams).
4. **Quality, Compliance & Change Management** – Verify vendor changes align with security requirements (MFA, certificates, ZTNA/VPN); coordinate tickets/changes in ITSM tools (ServiceNow/Jira); document process updates and contribute to runbooks.
**Required Skills**
- 3+ years in project coordination or migration‑related vendor programs.
- Advanced Excel: trackers, pivot tables, filters, conditional formatting, dashboards, VLOOKUPs.
- PowerPoint: executive‑level storytelling and slide design.
- Strong verbal & written communication, presentation skills.
- Multitasking, prioritization, and follow‑through across many vendors and deadlines.
- Proficiency with Microsoft 365 (Excel, PowerPoint, Outlook, Teams, SharePoint).
- Experience with ServiceNow, Jira, Smartsheet, Planner, or MS Project is a plus.
- Technical familiarity with VDI, VPN, ZTNA, MFA, certificates, and network/security change processes.
**Required Education & Certifications**
- Bachelor’s degree or equivalent practical experience.
- CAPM, ITIL, or similar certifications preferred.