Junior Project Portfolio Analyst – Data Insight Focus

Oil Authority; Calgary; On-site; CAD 52,000 - 70,000; Full time

Job summary

AltaGas in Calgary is seeking a Junior Project Portfolio Analyst to support financial analysis, budgeting, reporting, and data management for the capital project portfolio. You’ll work with Finance, Engineering, Supply Chain, Project Management, and Business Development to turn project data into meaningful insights for business decisions.

This early-career role offers exposure to Excel, Power BI, Power Query, and AI-enabled analytics, with opportunities to grow in workforce planning and

Qualifications

• Bachelor’s degree or diploma in Finance, Accounting, Economics, Business Administration, Data Analytics, Engineering, or a related discipline.
• 0–3 years of experience in financial analysis, project controls, business analysis, reporting, data analytics, or a related field.
• Experience using Microsoft Excel for data analysis and reporting.
• Exposure to Power BI, Power Query, Microsoft Fabric, or similar reporting and visualization tools is an asset.
• Familiarity with AI and automation tools such as Microsoft Copilot, Power BI Copilot, or Power Automate is an asset.

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

Excel

Power BI

Power Query

Data analytics

BI tools

Education

Bachelor’s degree or diploma in Finance/Accounting/Economics/Business Administration/Data Analytics/Engineering

Tools

Excel

Power BI

Power Query

Microsoft Fabric

Power Automate

Copilot/AI tools

Job description

AltaGas in Calgary is seeking a Junior Project Portfolio Analyst to support financial analysis, budgeting, reporting, and data management for the capital project portfolio. You’ll work with Finance, Engineering, Supply Chain, Project Management, and Business Development to turn project data into meaningful insights for business decisions.

This early-career role offers exposure to Excel, Power BI, Power Query, and AI-enabled analytics, with opportunities to grow in workforce planning and