PMO Analytics & Reporting Specialist

Photonic Inc. • Canada
Relocation
Apply
AI Summary

We are seeking a PMO Analytics & Reporting Specialist to support our Program Management Office (PMO) with accurate, consistent, and actionable reporting across the portfolio. The ideal candidate will build and maintain dashboards, standardize metrics and definitions, automate recurring reporting, and partner with Program/Project Managers to turn data into insights that improve planning and execution. This role requires strong proficiency with BI tools, experience working with project/portfolio data, and solid understanding of data concepts.

Key Highlights
Partner with PMO leadership and Program/Project Managers to define a reporting strategy
Build and maintain dashboards and scorecards
Develop automated and repeatable data pipelines/refresh routines
Key Responsibilities
Partner with PMO leadership and Program/Project Managers to define a reporting strategy
Build and maintain dashboards and scorecards
Develop automated and repeatable data pipelines/refresh routines
Technical Skills Required
Power BI SQL ETL Jira Smartsheet SharePoint/Excel
Benefits & Perks
Competitive compensation package
Stock options
Relocation assistance for global talent
Comprehensive benefits including extended health, dental, life, long term disability, an employee assistance program, parental leave top-ups, and a flexible spending account
Nice to Have
AI/LLM-assisted analytics features

Job Description


Department: Project Management

Location: British Columbia, Canada

Compensation: The base annual salary range for this full-time role is between $105,900 to $145,600. This range reflects the minimum and maximum target range for new hire base salary across all Canadian locations. Actual compensation may vary outside of this range and is dependent on various factors including but not limited to a candidate's qualifications including relevant education and training, competencies, experience, geographic location, and business needs. Base pay is only one part of the total compensation package. Full time roles are eligible for equity and benefits. Base pay is subject to change and may be modified in the future.

Description

We are seeking a PMO Analytics & Reporting Specialist to support our Program Management Office (PMO) with accurate, consistent, and actionable reporting across the portfolio. You will build and maintain dashboards, standardize metrics and definitions, automate recurring reporting, and partner with Program/Project Managers to turn data into insights that improve planning and execution.

In this role, you will be the PMO’s go-to expert for BI tooling (e.g., Power BI) and reporting workflows, connecting to data sources such as Jira, Smartsheet, SharePoint/Excel, and other operational systems. You will also apply AI-assisted analysis to speed up insight generation (e.g., variance explanations, trend summaries, draft executive narratives) while ensuring outputs are accurate, traceable, and appropriate for the audience.

You will ensure reporting is reliable, governed, and easy for stakeholders to consume - from team-level views to executive readouts.

Please include a cover letter with your resume (in one file) describing how you would be a great fit at Photonic and what attributes you could bring to our growing team.



WHAT WE NEED YOU TO DO

  • Partner with PMO leadership and Program/Project Managers to define a reporting strategy (core KPIs, cadence, audiences, templates) across the portfolio.
  • Build and maintain dashboards and scorecards (e.g., schedule health, milestone delivery, capacity/throughput, risk/issue trends, dependency tracking, resource allocation/management, budget burn where applicable).
  • Own metric definitions and data governance: establish clear calculations, ensure consistent use across teams, and document data lineage and assumptions.
  • Develop automated and repeatable data pipelines/refresh routines; reduce manual reporting through standardization and automation.
  • Integrate data from common PM tools (e.g., Jira, Smartsheet, SharePoint/Excel) and validate data quality through checks, reconciliation, and exception reporting.
  • Leverage AI tools to accelerate reporting workflows (e.g., automated narrative generation, anomaly detection, and first-draft insights), and validate results with source data before sharing.
  • Apply responsible AI practices in reporting (data privacy, access control, prompt hygiene, and clear human accountability) and help define lightweight standards for AI use within the PMO.

WHAT YOU BRING TO OUR TEAM

  • Bachelor’s degree in analytics, business, engineering, computer science, or a related field (or equivalent experience).
  • 3–6+ years of experience in analytics, reporting, business intelligence, or PMO/operations analytics.
  • Strong proficiency with BI tools - especially Power BI (data modelling, DAX, visuals, publishing, access management) and/or similar tools.
  • Experience working with project/portfolio data and tools (e.g., Jira, Smartsheet, MS Project, SharePoint/Confluence, Excel).
  • Solid understanding of data concepts (data quality, governance, KPI definition, dimensional modelling); SQL and basic ETL experience are strong assets.
  • Ability to translate ambiguous stakeholder questions into clear analyses and simple, repeatable reporting solutions.
  • Experience using AI/LLM-assisted analytics features (e.g., Copilot, natural-language querying, AI-supported narrative summaries) with an understanding of limitations, validation steps, and data governance.
  • Strong written and verbal communication skills; comfortable presenting insights to both technical teams and executives.
  • Highly organized, detail-oriented, and able to manage multiple requests with competing deadlines.

WHY YOU SHOULD WORK WITH US

  • Work closely with some of the brightest innovators in quantum technologies to drive breakthroughs that redefine computing
  • Enjoy a fast-paced and fun environment where you can try new things while solving innovative challenges every day
  • Inclusive company culture that values collaboration
  • Regular social events and fun activities keep our global team connected
  • Competitive compensation package including base salary, stock options, and relocation assistance for global talent
  • Comprehensive benefits including extended health, dental, life, long term disability, an employee assistance program, parental leave top-ups, and a flexible spending account

The description above is what we think an ideal candidate would look like for this role. At Photonic, we understand that everyone has a different work and life journey. If you feel your experience is close to what we've described, but you might not meet all the requirements, please still apply! All roles listed are for current vacancies. While artificial intelligence (AI) tools may be used to assist in reviewing applicant profiles, they do not determine candidate outcomes. Our hiring decisions are made by people, not algorithms. We are committed to fostering, cultivating, and preserving a culture of equity, diversity, and inclusion. We embrace and encourage our employees’ differences, knowing that these very differences inspire innovation and build better teams. If there are any accommodations our team can make throughout our hiring process, please let us know.


Similar Jobs

Explore other opportunities that match your interests

Senior Data Analyst

Data Science
•
1w ago
Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Mid-Senior level

Export Development Canada | Ex...

Canada

AI Data Business Analyst

Data Science
•
2w ago
Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Mid-Senior level

Export Development Canada | Ex...

Canada

Junior Data Analyst Intern

Data Science
•
3w ago

Premium Job

Sign up is free! Login or Sign up to view full details.

•••••• •••••• ••••••
Job Type ••••••
Experience Level ••••••

td securities

Canada

Subscribe our newsletter

New Things Will Always Update Regularly