Analyst, Business Intelligence

The Calgary Airport Authority; Calgary; Hybrid; CAD 75,000 - 105,000; Full time

Job summary

The Calgary Airport Authority is seeking a Finance professional to join our Financial Planning & Analysis team in Calgary. This hybrid role focuses on data collection, reporting, and analytics to support operational and financial decision making.

You will develop dashboards and standard reports using OTBI, SQL, Alteryx, Excel, and Power BI, driving KPIs across Supply Chain and Accounting stakeholders. The position requires 4–6 years in FP&A with strong MS Office skills and data analysis

Qualifications

• Bachelor’s degree in Finance, Accounting, Information Systems, or a related field.
• 4 to 6 years of FP&A, financial systems, or business analysis experience.
• Hands-on exposure to collecting, preparing, and analyzing data from multiple enterprise systems to support operational, financial, and performance reporting.
• Demonstrated background in developing, updating, and maintaining dashboards, standard reports, and visualizations to communicate KPIs and performance metrics to business users.
• Practical application of reporting and analytics tools such as Oracle OTBI, SQL, Alteryx, Excel, and Power BI, following established data models, templates, and standards.
• Advanced MS Office proficiency to document system processes and model logic in Word, analyze and organize data in Excel, prepare stakeholder presentations in PowerPoint, and manage communication and workflow coordination through Outlook.
• Superior data analysis and interpretation to analyze financial and operational datasets from ERP/EPM/CAIS systems, identify trends and correlations, and translate insights into meaningful recommendations for FP&A, Supply Chain, and Accounting stakeholders.
• Advanced problem solving to diagnose recurring system issues, evaluate alternative solutions, and apply fixes that reduce business disruption and limit dependency on external support.

Responsibilities

• Execute hands on data collection, preparation, and analysis from multiple systems to support operational, financial, and performance reporting.
• Deliver recurring and ad hoc reporting needs for teams such as Supply Chain and Finance, ensuring outputs are accurate and delivered on time.
• Develop and update interactive dashboards, standard reports, and visualizations to communicate KPIs and performance metrics to business users.
• Build, modify and maintain reusable reporting assets using Oracle OTBI, SQL, Alteryx, Excel, and Power BI by following established data models, templates, and standards.
• Identify data quality issues through regular checks and reconciliations, identifying discrepancies and flagging issues to data owners.
• Apply established controls, documentation, and access governance to ensure reporting accuracy, consistency, and data security.
• Work closely with the central Data Analytics team to apply existing best practices and methodologies for data extraction, analysis, and reporting.
• Troubleshoot recurring reporting issues, leveraging deep business and system knowledge to deliver effective solutions.

Skills

Bilingual in English and French

Education

Bachelor’s degree in Finance, Accounting, Information Systems, or a related field

Tools

Oracle OTBI

SQL

Alteryx

Excel

Power BI

Job description

Work environment: Hybrid (3 days in office, 2 days WFH)

Number of positions available: 1

Closing Date: 21 August 2026

WHY CALGARY AIRPORTS

Powered by heart and dedicated to excellence, we’re the team that keeps Calgary connected – and you could be our newest member.

We’re in the business of uplifting people, and every day, we create runways to new places and possibilities, building a better airport experience for everyone.

WHAT’S THE TEAM LIKE

Financial Planning & Analysis team is the trusted partner for each business unit and provides financial advice, expertise, and insights to support operational and strategic decision-making. The team comprises energetic finance professionals who strive for financial and operational excellence and exceptional customer service, challenge the status quo, and focus on continuous improvement.

WHAT ARE SOME OF THE RESPONSIBILITIES

• Execute hands on data collection, preparation, and analysis from multiple systems to support operational, financial, and performance reporting.
• Deliver recurring and ad hoc reporting needs for teams such as Supply Chain and Finance, ensuring outputs are accurate and delivered on time.
• Develop and update interactive dashboards, standard reports, and visualizations to communicate KPIs and performance metrics to business users.
• Build, modify and maintain reusable reporting assets using Oracle OTBI, SQL, Alteryx, Excel, and Power BI by following established data models, templates, and standards.
• Identify data quality issues through regular checks and reconciliations, identifying discrepancies and flagging issues to data owners.
• Apply established controls, documentation, and access governance to ensure reporting accuracy, consistency, and data security.
• Work closely with the central Data Analytics team to apply existing best practices and methodologies for data extraction, analysis, and reporting.
• Troubleshoot recurring reporting issues, leveraging deep business and system knowledge to deliver effective solutions.
• Bachelor’s degree in Finance, Accounting, Information Systems, or a related field. Relevant professional experience may be considered in lieu of formal education.
• 4 to 6 years of experience in FP&A, financial systems, or business analysis.
• Hands-on exposure to collecting, preparing, and analyzing data from multiple enterprise systems to support operational, financial, and performance reporting.
• Demonstrated background in developing, updating, and maintaining dashboards, standard reports, and visualizations to communicate KPIs and performance metrics to business users.
• Practical application of reporting and analytics tools such as Oracle OTBI, SQL, Alteryx, Excel, and Power BI, following established data models, templates, and standards.
• Advanced MS Office proficiency to document system processes and model logic in Word, analyze and organize data in Excel, prepare stakeholder presentations in PowerPoint, and manage communication and workflow coordination through Outlook.
• Superior data analysis and interpretation to analyze financial and operational datasets from ERP/EPM/CAIS systems, identify trends and correlations, and translate insights into meaningful recommendations for FP&A, Supply Chain, and Accounting stakeholders.
• Advanced problem solving to diagnose recurring system issues, evaluate alternative solutions, and apply fixes that reduce business disruption and limit dependency on external support.

WHAT ADDITIONAL SKILLS ARE AN ASSET

• Bilingual in English and French

WHAT DOES DIVERSITY MEAN TO US

We are committed to building a team where exceptional leadership shines and our crew thrives both at work and at home. We believe that deliberate steps such as creating a workplace that is physically and psychologically safe, equitable to all, and actively and diligently taking steps along the path to reconciliation are the keys to making this a reality.

OUR VALUES

We prioritize genuine concern and compassion for everyone we engage with, from our team members to our partners and guests, always striving to help and support one another.

We actively seek diverse perspectives in our decision-making and collaboratively tackle challenges.

We work together with trust and transparency, supporting one another to achieve the collective goals of our organization.

We grow, evolve, and adapt with purpose, continually aligning our actions with our vision.

We embrace curiosity and boldly challenge the status quo, exploring new opportunities and taking thoughtful, responsible risks that drive purposeful innovation.