Project Analyst

Job Description

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.