Rising Project Portfolio Analyst - Finance & Analytics

AltaGas Ltd.; Calgary; On-site; CAD 42,000 - 65,000; Full time

Job summary

AltaGas is seeking a Junior Project Portfolio Analyst to join the Project Excellence team. You will support budgeting, forecasting, data management, and reporting for the capital portfolio across finance, engineering, supply chain, project management, and business development.

You will build insights from project data, develop dashboards, and help optimize data quality and reporting automation. This is an early-career opportunity to grow skills in BI, analytics, and workforce planning within a

Qualifications

• Bachelor’s degree or diploma in finance, accounting, economics, business, data analytics, engineering, or related discipline.
• 0–3 years in financial analysis, project controls, business analysis, reporting, data analytics, or related field.
• Experience using Microsoft Excel for data analysis and reporting.
• Exposure to Power BI, Power Query, Microsoft Fabric, or similar tools.
• Familiarity with AI and automation tools such as Microsoft Copilot, Power BI Copilot, or Power Automate is an asset.
• Strong analytical, organizational, and problem-solving skills with attention to detail.
• Ability to work with large datasets from multiple sources.
• Exposure to enterprise systems like JDE, Oracle, SAP, or PeopleSoft beneficial.

Responsibilities

• Support portfolio budgeting, forecasting, and long-range planning, including tracking project budgets, CAPEX, OPEX, expenditures, cash flow, and financial variances.
• Maintain and validate project portfolio data, including financials, milestones, and resource information.
• Prepare portfolio reports, dashboards, scorecards, KPIs, and management reporting packages.
• Analyze project and portfolio data to identify trends and provide insights that support decision-making.
• Support resource and workforce planning, including tracking employee, contractor, and consultant requirements.
• Develop and maintain reporting and analytics using Excel, Power BI, Power Query, and other BI tools.
• Support data quality and validation to ensure accurate and consistent portfolio reporting.
• Participate in automation and digital reporting initiatives that improve efficiency and reduce manual effort.
• Help identify opportunities to improve portfolio processes, reporting, and data accessibility.
• Explore and leverage emerging analytics and AI-enabled technologies to support continuous improvement.

Skills

Analytical skills

Organizational skills

Problem-solving

Attention to detail

Communication

Collaboration

Education

Bachelor's degree or diploma

Tools

Excel

Power BI

Power Query

Microsoft Fabric

Microsoft Copilot

Power BI Copilot

Power Automate

JDE

Oracle

SAP

PeopleSoft

Job description

AltaGas is seeking a Junior Project Portfolio Analyst to join the Project Excellence team. You will support budgeting, forecasting, data management, and reporting for the capital portfolio across finance, engineering, supply chain, project management, and business development.

You will build insights from project data, develop dashboards, and help optimize data quality and reporting automation. This is an early-career opportunity to grow skills in BI, analytics, and workforce planning within a