Analyst, Business Intelligence

Socket.dev; Calgary; On-site; CAD 130,000 - 158,000; Full time

Job summary

CALGARY AIRPORTS is seeking a Finance analyst in the Financial Planning & Analysis team. You will execute hands-on data collection, prepare reports, and develop dashboards to communicate KPIs to business users.

This is a full-time permanent, unionized role with a hybrid schedule (3 days in office, 2 days WFH) in Calgary. The ideal candidate has 4–6 years FP&A experience, strong Oracle OTBI, SQL, Alteryx, Excel, and Power BI skills, and the ability to translate data into actionable insights for

Qualifications

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

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

Data analysis

Dashboard development

Financial reporting

SQL

Power BI

Excel

Oracle OTBI

Bilingual (English/French)

Education

Bachelor’s degree in Finance/Accounting/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.