Analyst, Business Intelligence

Calgary Airports; Calgary; Hybrid; CAD 125,000 - 164,000; Full time

Job summary

Calgary Airports is seeking a Financial Planning & Analysis professional to join our team. You will execute data collection, preparation, and analysis to support operational, financial, and performance reporting, delivering recurring and ad hoc insights across Supply Chain and Accounting stakeholders.

You’ll build and maintain dashboards and reports using Oracle OTBI, SQL, Alteryx, Excel, and Power BI, working with established data models and governance in a hybrid work environment.

Qualifications

• Bachelor’s degree in Finance, Accounting, IS or related field.
• 4 to 6 years FP&A, financial systems, or business analysis experience.
• Hands-on data collection from multiple systems for reporting.
• Experience building dashboards and standard reports for KPIs.
• Proficiency with Oracle OTBI, SQL, Alteryx, Excel and Power BI.

Responsibilities

• Execute data collection, preparation, and analysis from multiple systems to support operational, financial, and performance reporting.
• Deliver recurring and ad hoc reporting for Supply Chain and Finance with accuracy and timeliness.
• Develop and update interactive dashboards, standard reports, and visuals to communicate KPIs.
• Build, modify and maintain reporting assets using Oracle OTBI, SQL, Alteryx, Excel, and Power BI.
• Identify data quality issues and flag discrepancies to data owners.
• Apply controls and governance to ensure reporting accuracy and data security.
• Collaborate with Data Analytics to apply best practices for data extraction and reporting.
• Troubleshoot recurring reporting issues and provide effective solutions.

Skills

Bilingual English French

Advanced MS Office

Dashboards & visuals

Communication & reporting

Data analysis & interpretation

Education

Bachelor’s degree in Finance or Accounting or IS

Tools

Oracle OTBI

SQL

Alteryx

Excel

Power BI

Job description

Salary: Band 9 ($103,701.00)
Status: Full-time permanent, Unionized

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

Number of positions available: 1

Closing Date: End date for posting

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.

What Do You Need To Bring

• You’ll need to be eligible to obtain and maintain a RAIC, don’t worry – we’ll help you through this! For more details, check out: RAIC Program and Application Information
• 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.