Job Code 24-63

YVR is made up of a team of diverse people who are working collaboratively to Connect BC Proudly to the World. Safety is at the core of everything we do; we’re innovative, fun, and we invest in our people. We’re a BC Top Employer for 14 years standing, with high engagement scores, an abundance of learning and development opportunities, and a holistic approach to wellness.

Position overview

We have a full-time opportunity for a Senior Business Analyst – Reporting in the IT Department. Reporting to the Manager, Enterprise Transformation, the successful candidate is the subject matter expert for collecting, analyzing, and transforming data into actionable insights, communicating the information, and providing guidance to diverse audiences and business teams across the project. You will work cross-functionally to identify needs and opportunities, design, and create accurate and creative requirements for dashboards, reports, and presentations. The position will require senior analytical skills, in current state analysis, map/gap analysis, inventories, usage, future state analysis.   The ability to use professional judgement in interpreting policy, finance processes, and legislation to establish precedents or solutions to complex issues is essential. Extensive knowledge of finance, asset management and business structures.

Key responsibilities include: 

  • Lead and/or support requirements gathering and implementation of enterprise reporting and dashboard requirements, work with business users to gather and translate requirements into working reports, and test, debug, and refine solutions by actively working with user feedback.
  • Facilitate the definition of project scope, goals, and deliverables, while following defined YVR IT PMO processes and creating required documentation.
  • Define, guide, evaluate, recommend, and deliver business intelligence requirements from beginning to end, implementing streamlined reporting and processes to maximize business efficiency, in alignment with Oracle Fusion suite of reporting tools (Smart View, OTBI, BIP, and FAW).
  • Write requirements that collect data to build and maintain dashboard and reporting solutions for assigned business groups, document future state dashboards and required data pipelines, review existing dashboards and review requirements for redesign with business users and document future state.
  • Develop and build new reports and dashboards from business requirements and review with business users. This includes providing documentation and training on newly developed reports and dashboards.
  • Test business intelligence solutions, including creating and executing test plans, cases, and scripts, and plan and conduct testing of Oracle quarterly patch updates and system modifications related to the business intelligence and reporting tools and dashboards.

Key qualifications include: 

  • Minimum Bachelor’s Degree in Computer Science, Business Administration or equivalent, or comparable education with sufficient relevant work experience.
  • Minimum 10 years of business analysis and report creation experience (senior level), 10 years of implementing and supporting enterprise-class applications in medium to large sized organizations with minimum 5 years of business analysis and project management experience (senior level).
  • Demonstrated in-depth knowledge and experience with Oracle EBS, Oracle Fusion ERP, or other large ERP systems is essential, including understanding of technical system architecture.
  • Experience with building reports and dashboards through Oracle Fusion Smart View, Oracle Business Intelligence Publisher (BIP), Oracle Transactional Business Intelligence (OTBI), Oracle Fusion Analytics Warehouse (FAW), and other reporting tools including experience with Data warehouses such as Oracle Fusion Analytics Warehouse (FAW), snowflake and databricks or similar as well as experience with test automation solutions, Selenium preferred.
  • Ability to oversee and plan all activities around the management of IT systems/programs with a focus on service delivery and a pro-active outlook as well as proven relationship building skills, both with internal stakeholders/users and external vendors/consultants/system user community groups.
  • Recent full-cycle accounting experience would be an asset.

This position is open to both Vancouver Airport Authority employees and external applicants. Previous job performance will be taken into consideration for all internal candidates that apply for this position.

As part of our recruitment process, short-listed candidates may be required to participate in an assessment process.

Salary Range : $97,599 to $127,555 per annum, based on 37.5 hours per week. This is individually tailored to reflect your unique experience, qualifications, and internal equity.

Apply online at https://careers.yvr.ca/job/vancouver/senior-business-analyst-reporting/38253/63172307664