Senior Business Consultant

Senior Business Consultant

Banff Centre for Arts and Creativity aims to inspire everyone who attends our campus – artists, leaders, and thinkers – to unleash their creative potential.

We acknowledge, with deep respect and gratitude, our home on the side of Sacred Buffalo Guardian Mountain. In the spirit of respect and truth, we honour and acknowledge the Banff area, known as “Minhrpa” (translated in Stoney Nakoda as “the waterfalls”) and the Treaty 7 territory and oral practices of the Îyârhe Nakoda (Stoney Nakoda) – comprised of the Bearspaw, Chiniki, and Goodstoney Nations – as well as the Tsuut’ina First Nation and the Blackfoot Confederacy comprised of the Siksika, Piikani, Kainai. We acknowledge that this territory is home to the Shuswap Nations, Ktunaxa Nations, and Metis Nation of Alberta, Rockyview District 4. We acknowledge all Nations who live, work, and play, help us steward this land, and honour and celebrate this place.

The Opportunity

The Senior Business Consultant is a strategic and highly influential role that partners with stakeholders across the organization to deliver innovative technology solutions that support business objectives. Combining expertise in business analysis, systems architecture, project management, and application development, this position drives continuous improvement, leads complex initiatives, and helps shape the Banff Centre's technology future while delivering exceptional service and support.

Roles and Responsibilities

Systems Analysis:

• Develops, maintains, provides user support for specific systems and applications, and works to ensure the stability of servers that support these applications. Includes planning and supporting system and equipment upgrade requirements, security and operations. Performs research for alternative solutions where needed, and may include the design of physical and logical architectures of single or multi-farm server topologies.
• Performs after-hours support as needed / typically but not limited to maintenance and upgrades of existing business systems.
• Oversees quality, completeness and maintainability of third-party remote support while ensuring security and best practices.
• Works with client departments and vendors on new version releases and upgrade implementation.
  

Senior Business Analysis:

• Develops relationships at all organization levels, with vendors, internal and external business experts. Is a key, high profile client department contact that analyzes and seeks to understand client needs, clarifies expectations and keeps the client / department informed of progress and project statuses.
• Through solution discovery and analysis, requirements gathering, information modelling, business needs gap identification, evaluating and re-engineering existing business processes, conceptual system design contributions and technical and functional specifications; the SBC translates business issues into technical solutions that ensure value and reliability from the application environments. Creativity and innovative analysis techniques are used to leverage core TBC systems across multiple departments to drive increased business value from these solutions.
• On larger projects the SBC project work scope includes assisting or leading facilitated client discovery sessions, development or interpretation of system specifications, design and document integration solutions based on applications and database architectures, business processes, data models and data transformations, ensuring that the information systems, applications and database architectures support current needs, while providing a foundation for the future.
• Develops documentation as appropriate and assists with the training of new IT/S staff members.
  

Data Analysis:

• Elevated data access, security management, expert knowledge of business areas / expertise in specific legislative requirements and responsibilities. Manages application and database security and access as appropriate. Performs database transaction and security audits and sets up new database instances.
• Responds to and resolves database, system and reporting performance issues. Informs management decisions regarding application service restoration for high severity incidents. Performs database roll-backs or high-risk emergency changes as required, monitors performance, and recommends allocation of server resources to achieve optimum performance. Disaster recovery – recommends courses of action to management; rebuilds applications as required.
• Provides oversight responsibilities for both the business (logical) and IT (physical) data models and ensures linkage with business data architectures and communicates data models to project teams. Supports project teams in the management and delivery of databases coordinates the development of business data and ensures integration of business data with IT/S databases.
• Gathers requirements and builds custom reports, data extracts and interfaces to support custom reporting, data interchange between systems, and data mining (business intelligence).
  Systems Development:
• Builds and codes data access components (SQL and others), web application components, client/server components and system scripts.
• Builds interfaces between various line of business applications, custom applications and SaaS apps.
• Applies SDLC methodologies to build, test, integrate, and deploy custom components across a wide variety of technologies.

Project Management:

• Knowledge of PMBOK, BABOK and SDLC methodologies to develop the PM practices, standards and services at TBC. Applies knowledge and analytical skills to business/ user requests and problems. Uses problem management escalation procedures, tools and competencies to mitigate business impacts, improve system quality and efficiencies. Drives the adoption of project management best practices across the organization.
• Provides project statements, plans and status reports to management and/ or steering committees.
• Consulted in department hiring decisions.
• Purchasing authority for server certificate authority re-/purchase and installation of site/security certificates. Provides advice to management on which Enterprise system certificate(s) should be purchased. Purchasing authority for server maintenance, support and licensing.

Qualification and Educational Requirements

• Computer Technology diploma or degree from a recognized educational institution or equivalent experience combined with Microsoft and PC certification
• Minimum 5-7 years’ experience
• Experience with Microsoft software (Office365, Windows 10/11, Azure/Entra ID, Teams etc) is required
• Certification in Office 365 and Entra ID are an asset
• Knowledge of physical and logical architecture design for server topologies.
• Experience in coordinating and delivering technology solutions, including hardware, systems software, and network integration.
• Experience in analyzing business needs, gathering requirements, and creating technical solutions.
• Ability to facilitate client discovery sessions, interpret system specifications, and design integration solutions.
• Advanced knowledge in managing data access, security, and compliance with legislative requirements.
• Ability to manage business and IT data models and ensure alignment with business data architectures.
• Experience in building custom reports, data extracts, and interfaces for reporting and data mining.
• Proficiency in building and coding data access components, web applications, client/server components, and system scripts.
• Experience in integrating various business applications, custom applications, and SaaS solutions.
• Knowledge of PMBOK, BABOK, and SDLC methodologies.
• Strong verbal and written communication skills for interacting with various stakeholders and creating documentation.
• Excellent organizational skills for managing multiple projects and priorities simultaneously.

Employment Terms & Benefits

• In accordance with CUPE 4318, this is a unionized, salaried support staff position, subject to a 6 month probation period.
• The annual salary for this position is between $72,654 - $85,196 depending on experience, based on working 40 hours per week.
• Hybrid work environment (3 days in the office, 2 days remote)
• The successful candidate will have access to a range of benefits through Alberta Blue Cross and will be eligible to participate in our defined benefit pension plan.
• Benefits of working at Banff Centre are:
  • Professional development
  • Employee Assistance Program
  • Health care spending account
  • Staff cafeteria and restaurant discounts
  • Onsite fitness facility at a discounted rate – first month free for new staff!

Application Process

• We are accepting applications for the Senior Business Consultant position until a suitable candidate is found.
• Candidates offered a position with Banff Centre, in this capacity, will be required to obtain a criminal record check verifying a clear record before a final job offer can be finalized.
• Visa Requirements: Candidates must be legally eligible to work in Canada. Banff Centre is unable to assist candidates in obtaining Canadian work authorization.