AltaGas - Junior Project Portfolio Analyst

wgl; Calgary; On-site; CAD 60,000 - 90,000; Full time

Job summary

AltaGas is seeking a Junior Project Portfolio Analyst to join our Project Excellence team in Calgary. You will support financial analysis, reporting, resource planning, and data management across our capital project portfolio, collaborating with Finance, Engineering, Supply Chain, Project Management, and Business Development to translate project data into actionable insights.

This early-career role focuses on building experience in project portfolio management, financial analysis, BI, and

Qualifications

• Bachelor's degree or diploma in Finance, Accounting, Economics, Business Administration, Data Analytics, Engineering.
• 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.

Responsibilities

• Support portfolio budgeting, forecasting, and long-range planning with tracking of budgets and cash flow.
• Maintain and validate project portfolio data including financials and milestones.
• Prepare portfolio reports, dashboards, KPIs, and management reporting packages.
• Analyze project data to identify trends and support decision-making.
• Support resource and workforce planning including contractor requirements.
• Develop reporting using Excel and Power BI, including Power Query.
• Assist automation and digital reporting initiatives to improve efficiency.
• Identify opportunities to improve portfolio processes and data accessibility.

Skills

Financial analysis

Data analysis

Excel

Power BI

Power Query

Business intelligence

Communication

Education

Bachelor's degree or diploma in Finance, Accounting, Economics, Business Administration, Data Analytics, Engineering

Tools

JDE

Oracle

SAP

PeopleSoft

Job description

Job Description

AltaGas - Junior Project Portfolio Analyst

The Junior Project Portfolio Analyst will join our Project Excellence team and support the financial analysis, reporting, resource planning, and data management of our capital project portfolio.

This is a great opportunity for an early-career professional looking to build experience in project portfolio management, financial analysis, business intelligence, and workforce planning. You'll work with teams across Finance, Engineering, Supply Chain, Project Management, and Business Development to turn project data into meaningful insights that support business decisions.

You Will:

• 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 business intelligence 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.

You Have:

• A 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. Recent graduates with relevant internship, co-op, or project experience are encouraged to apply.


• 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.


• Strong analytical, organizational, and problem-solving skills with excellent attention to detail.


• The ability to work with large datasets and information from multiple sources.


• Strong communication and collaboration skills.


• Exposure to enterprise systems such as JDE, Oracle, SAP, or PeopleSoft is beneficial but not required.

Why AltaGas?

At AltaGas, you'll have the opportunity to build your career while gaining hands‑on exposure to the financial, operational, and analytical side of major capital projects. You'll collaborate with teams across the business, develop your skills with modern reporting and analytics tools, and help transform project data into insights that support better decisions.

For Canadian hires :

AltaGas hires personnel on the basis of job‑related qualifications. All qualified applicants will receive consideration without regard to a person's ancestry, place of origin, colour, ethnic origin, citizenship, creed, sex, sexual orientation, gender identity or expression, age, record of offences, marital status, family status or disability or any other characteristic protected by applicable law.

For U.S. hires :

WGL/SEMCO/AltaGas offers a total rewards package that includes competitive pay, incentive bonus plans, holiday pay, 401K matching and a wide array of benefits. These benefits including medical, dental and vision coverage are designed to help you and your family stay healthy. We also have paid time off (PTO) to balance the demands of your work and personal life. Available benefits vary depending on the specifics of the role.

U.S. affiliates of AltaGas are committed to equal employment opportunity and providing reasonable accommodations to applicants with physical and/or mental disabilities. We value and encourage diversity and solicit applications from all qualified applicants without regard to race, ethnicity, religion, gender, age, national origin, marital status, sexual orientation, gender identity, family responsibilities, matriculation, physical or mental disabilities, political affiliation, genetic information, status as a protected veteran or any other characteristic protected by federal, state, or local law.