Job Title: Project Systems & Automation Specialist (Microsoft Project + Power Automate + Excel Integration)
contract or Freelancing- for this project - wfh-remote
Job Summary
Terra Cost Controls is looking for a Project Systems & Automation Specialist to develop, automate, and maintain an integrated project management system connecting Microsoft Project, Excel (SharePoint), and Power Automate. This role will be responsible for creating automated workflows, task notifications, dashboard data flows, and system integration between scheduling, reporting, and resource tracking tools.
This role is a combination of Project Controls, Systems Automation, and Data Management.
Key Responsibilities
Microsoft Project (MSP):
\u2022 Build and maintain project schedules in Microsoft Project
\u2022 Import and export schedules from Excel to MSP
\u2022 Manage task relationships, durations, resources, and baselines
\u2022 Publish and maintain Project Online schedules
\u2022 Maintain resource pool and task assignments
\u2022 Create and manage custom fields and views
\u2022 Maintain schedule updates and progress tracking
Excel + SharePoint Integration:
\u2022 Develop and maintain Excel templates for schedule data input
\u2022 Link Excel files stored on SharePoint with Microsoft Project
\u2022 Maintain data structure for:
\u2022 Task Name
\u2022 Duration
\u2022 Start / Finish
\u2022 Predecessors
\u2022 Resources
\u2022 % Complete
\u2022 Ensure data sync between Excel and MSP
\u2022 Support dashboard reporting using Excel data sources
Power Automate (Critical Requirement):
\u2022 Build automated workflows between Microsoft Project, SharePoint, and Outlook
\u2022 Create automatic email alerts for:
\u2022 Upcoming tasks
\u2022 Late tasks
\u2022 Task assignments
\u2022 Weekly lookahead schedules
\u2022 Status reminders
\u2022 Create approval workflows for project processes
\u2022 Automate data updates between Excel and MSP
\u2022 Automate report distribution
Reporting & Dashboards:
\u2022 Create automated progress reports
\u2022 Create weekly and monthly dashboards
\u2022 Support Power BI dashboard data flows (optional but preferred)
\u2022 Develop reporting templates for project managers
Required Skills
Mandatory:
\u2022 Microsoft Project (Advanced)
\u2022 Power Automate (Workflow Automation)
\u2022 Excel (Advanced - formulas, lookups, pivot tables)
\u2022 SharePoint (File management and integration)
\u2022 Understanding of project scheduling logic (predecessors, critical path, baselines)
\u2022 Experience with automated email workflows
\u2022 Experience integrating Microsoft Project with Excel
Preferred:
\u2022 Project Online / Project Server
\u2022 Power BI
\u2022 VBA / Excel Macros
\u2022 Understanding of Project Controls
\u2022 Experience with construction or data center projects
\u2022 Knowledge of Earned Value Management (EVM)
Example Tasks This Role Will Perform
\u2022 When a task start date is 3 days away \u2192 automatic email sent to assigned person
\u2022 When task is late \u2192 automatic escalation email sent
\u2022 When Excel schedule is updated \u2192 MSP schedule updates
\u2022 Weekly Lookahead automatically generated and emailed
\u2022 Dashboard automatically updated from schedule data
\u2022 Resource assignment notifications sent automatically
Experience Required
\u2022 3-7 years experience in:
\u2022 Project Scheduling
\u2022 Project Controls
\u2022 Project Systems Automation
\u2022 PMO Systems Support
