Job Description : Project Analyst
Position Title : Project Analyst
Department : Project Management Office (PMO)
Reports To : PMO Head.
Location : North York
Employment Type : [Full-time / Contract / Hybrid]
Position Summary
The Project Analyst supports the planning, execution, monitoring, and reporting of projects within the organization. This role requires strong analytical capability, advanced data visualization expertise, and in-depth knowledge of project management tools and methodologies. The ideal candidate is proficient in Power BI, MS Excel, MS Project, OpenPlan, and digital collaboration platforms, enabling data-driven decision-making and streamlined project operations.
Key Responsibilities
Project Analysis & Reporting
- Develop and maintain interactive dashboards and reports in Power BI to track project KPIs, performance metrics, schedules, and resource usage.
- Perform data analysis and trend forecasting to support project planning and decision-making.
- Build complex Excel models , including pivot tables, Power Query, advanced formulas, and data automation.
- Prepare regular project status reports, executive summaries, and analytics presentations.
Project Planning & Monitoring
Support project scheduling using MS Project and OpenPlan , ensuring accurate critical paths, dependencies, and resource allocations.Assist in monitoring project timelines, scope, risks, and issues, ensuring alignment with PMO standards.Validate project data quality and maintain project documentation using PM methodologies (e.g., PMBOK , Waterfall, Agile).PMO Process & Governance
Ensure adherence to project management processes, methodologies, and governance frameworks .Participate in project audits, compliance checks, and continuous improvement initiatives.Contribute to PMO templates, standards, and knowledge repositories.Digital Collaboration & Automation
Manage project artifacts on MS SharePoint , ensuring structured storage and version control.Create and manage project intake forms and surveys using MS Forms .Build workflow automations using Power Automate to streamline repetitive PMO tasks.Leverage AI tools for data insights, reporting efficiency, document generation, and project forecasting.Stakeholder Communication
Coordinate with cross-functional teams, vendors, and business stakeholders to gather requirements and track deliverables.Support meeting facilitation, including agenda preparation, minutes, and action item tracking.Maintain clear communication channels and escalate issues proactively.Required Qualifications
Bachelor’s degree in Business Administration, Project Management, Information Technology, or related field.2–5+ years of experience in project coordination, project analysis, or PMO support roles.Strong understanding of project management processes and lifecycle .Advanced skills in :Power BI (data modeling, DAX, visualizations)MS Excel (advanced formulas, Power Query, pivot tables, macro-level automation)MS Project & OpenPlan (scheduling, resource allocation, dependencies, critical path)Experience with Microsoft 365 tools : SharePoint, Power Automate, Forms.Knowledge of AI tools for reporting, insights, and automation (e.g., Copilot, AI-driven analytics).Excellent analytical, organizational, and problem-solving skills.Strong communication and stakeholder management abilities.