AltaGas - Junior Project Portfolio Analyst

WGL Holdings, Inc.; Calgary; Hybrid; CAD 50.000 - 70.000; Vollzeit

Zusammenfassung

AltaGas is seeking a Junior Project Portfolio Analyst to join the Project Excellence team. You will support financial analysis, reporting, resource planning, and data management of the capital project portfolio to turn data into meaningful insights for decision-making.

You will collaborate with Finance, Engineering, Supply Chain, Project Management, and Business Development to enhance reporting using Excel, Power BI, Power Query, and related BI tools, while exploring automation and AI-enabled

Qualifikationen

• Bachelor's degree or diploma in Finance, Accounting, Economics, Business Administration, Data Analytics, Engineering, or related discipline.
• 0–3 years of experience in financial analysis, project controls, business analysis, reporting, data analytics, or related field.
• Experience using Microsoft Excel for data analysis and reporting.

Aufgaben

• Support portfolio budgeting, forecasting, and long-range planning, including tracking budgets, CAPEX, OPEX, expenditures, cash flow, and variances.
• Maintain and validate project portfolio data, including financials, milestones, and resource information.
• Prepare portfolio reports, dashboards, KPIs, and management reporting packages.
• Analyze project and portfolio data to identify trends and provide insights for decision-making.
• Support resource and workforce planning, including tracking employees and contractors.

Kenntnisse

Excel

Data analysis

Power BI

Ausbildung

Finance degree

Data analytics degree

Tools

Power BI

Power Query

Microsoft Fabric

Excel

Jobbeschreibung

Job DescriptionAltaGas - Junior Project Portfolio AnalystThe 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.