Analyst, Oracle Systems

Number of positions available: 1

Salary: Band 10 ($104,481.00 $108,654.00 $112,983.00 $117,526.50)

Status: Full-Time

Closing Date: April 3 2024

OUR TEAM

We are more than just planes and tarmacs. Our purpose travels beyond our runway into the communities we serve. We are about connections, stories, and life-defining adventures. We are committed to fostering an environment where our people are rewarded through meaningful work experiences.

The Calgary Airport Authority manages and operates YYC Calgary International Airport and YBW Springbank Airport and collaborates with the many partners who make up YYC - from airlines to government agencies and retail outlets. This is an exciting time to join our #YYCCrew and drive YYC forward as one of Canada"s best airports!

Reporting to the General Manager, Corporate Services, the Oracle System Specialist is responsible for the management, configuration and testing of our Oracle Fusion ERP and EPM environments as well as providing training on its use.

WHAT YOU WILL DO

The Oracle System Specialist will be the subject matter expert for the Oracle Fusion ERP and EPM applications providing technical expertise to enhance, modify, support, and maintain these systems as well as the interfaces between it and downstream/upstream systems; additionally, they are expected to maintain a strict level of security on all supported applications and data. As part of becoming a subject matter expert, the Specialist must understand the business, its processes, and the back-end data involved.

Security Management

• Manage and enforce security policies and access controls for Oracle Fusion (ERP and EPM) applications.
• Conduct regular security audits and implement necessary measures to ensure data integrity and confidentiality.
• Ensure there are no segregation of duties issues in Oracle Fusion
• Manage any segment level security built in the system.
• Manage profile settings in the system at a system and user level.
• Maintain “role-based security” in YYC’s Fusion system.

User Support and Training

• Provide technical support to all users (admin users, business users and end-users) on all aspects of the system and troubleshoot issues related to Oracle Fusion ERP and EPM.
• Make configuration changes to the system and reports as requested by users.
• Where the Oracle System Analyst can’t resolve a user’s issue, they will work collaboratively with our Tier 2 support partner and/or the vendor (Oracle) to provide the solution.
• The Oracle System Analyst will maintain a knowledge base of solutions for future reference.
• Develop and deliver training sessions and materials to educate users on how to use the system and on new features. A library of system training materials, which will include user guides, will be developed, and maintained by the Oracle System Analyst

Configuration Management

• Maintain a configuration workbook for YYC’s Oracle Fusion system.
• Ensure at any given time, our configuration in the system is up to date.
• As changes and enhancements are made ensure our configuration workbook is appropriately updated

Ad Hoc Reporting

• Build and test Ad Hoc reports as required.
• Become YYC’s primary expert on Oracle Fusion reporting tools such as Oracle Transactional Business Intelligence (OTBI) and SmartView
• Organize and manage YYC’s central repository for Fusion reports.
• Support other users that are building their own ad hoc Fusion reports.
• Ensure security associated with reporting is appropriate for YYC’s userbase.

Enhancement Projects

• This role will be a primary resource for all Oracle Fusion enhancement projects.
• The Oracle Systems Analyst will be responsible for the full development lifecycle of enhancement projects. Duties include:
  • Requirements gathering
  • Configuration changes as required by the project.
  • Quality Assurance Testing
  • Conducting User Acceptance Testing sessions
  • Change Management
  • Training and documentation of all project deliverables.

WHAT YOU BRING

• A minimum of 5 years in a system specialist role with deep knowledge of Oracle ERP and EPM.
• Knowledge of security principles for an ERP system.
• Skilled at working with end-users and a Tier 2 support partner to resolve system issues and problems.
• Experience with requirements gathering and translating these into system configurations.
• Prior experience training end-users on how best to use a system.
• Experience in testing of system changes and the process of migrating changes from a test environment to a production environment.
• Knowledge of Microsoft office tools, especially Excel. Prior experience building Oracle reports with OTBI.
• Strong technical writing proficiency for documentation of applications and creation of Standard Operating Procedures
• Good ability to read, interpret and understand IT technical specifications.
• Excellent organizational skills as there are many competing priorities in this position.
• Excellent communication skills. This position liaises with a large number of co-workers, contractors and other partners and excellent communication skills are vital.
• Ability to make accurate and timely decisions within their area of influence for services under their direction while keeping others that need to know informed of what is going on.
• Excellent relationship building skills. An ability to cultivate and maintain strong relationships with business stakeholders, contractors and vendors are key to being successful in this role.

WHAT ELSE?

• Must be able to obtain and maintain a restricted area identification card (RAIC)
• This role is eligible for our hybrid work model with a combination of in-office and remote work.

Our Values:

We are ACCOUNTABLE. We take ownership and step up to get the job done.

We are CUSTOMER-FOCUSED. We consider the customer in all that we do.

We are COLLABORATIVE. We are stronger when we reach out and work as a team.

We are RESILIENT. We are able to withstand or recover quickly from difficult conditions.

We are CREATIVE. We strive to find new and better ways of doing things.

Are you looking for the journey of a lifetime? One that’s focused on creating effortless and memorable experiences for millions of guests and travelers each year.

The Calgary Airport Authority is an equal opportunity employer committed to diversity, equity, and inclusion. We encourage all qualified applicants to apply including women, Indigenous people, persons with disabilities, members of visible minorities, members of the 2SLGBTQ+ community, and others who may contribute to organizational diversification of ideas.