Analyst, Business Intelligence

Calgary Airports•Calgary, AB

5d•Hybrid

About The Position

The Financial Planning & Analysis team is a trusted partner for each business unit, providing 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.

Requirements

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.

Nice To Haves

Bilingual in English and French

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.