AltaGas - Junior Project Portfolio Analyst

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

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