Analyst, Business Intelligence

The Calgary Airport Authority

$103K *
Finance & Insurance
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree in Finance, Accounting, Information Systems, or a related field
  • 4 to 6 years of experience in FP&A, financial systems, or business analysis
  • Hands-on experience in data collection, preparation, and analysis
  • Demonstrated expertise in developing and maintaining dashboards and reports
  • Familiarity with reporting tools such as Oracle OTBI, SQL, Alteryx, Excel, and Power BI
  • Advanced proficiency in MS Office applications
  • Strong data analysis skills for interpreting financial and operational datasets

Responsibilities

  • Execute data collection, preparation, and analysis for reporting
  • Deliver accurate and timely recurring and ad hoc financial reporting
  • Develop and update dashboards and visualizations for KPIs
  • Maintain reusable reporting assets using established tools and templates
  • Identify and resolve data quality issues
  • Ensure compliance with reporting accuracy and governance
  • Collaborate with the Data Analytics team to implement best practices
  • Troubleshoot reporting issues with a deep understanding of business and systems

Benefits

  • Work in a hybrid environment (3 days in office, 2 days WFH)
  • Unionized position with potential job security
  • Support for obtaining and maintaining a RAIC
  • Opportunity to work with a collaborative team focused on continuous improvement
  • Engagement in operational and strategic financial advisory processes
Full 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

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

Similar Jobs

More Jobs at The Calgary Airport Authority

More Finance & Insurance Jobs

Find similar Analyst, Business Intelligence jobs: