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.

Banff Centre for Arts and Creativity acknowledges, 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 Nation – 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 here, help us steward this land, and honour and celebrate this place.

The Opportunity

The Senior Business Consultant is a composite role that combines the broad scope of responsibilities typically assigned to Systems Analyst, Systems Architect, Business Analyst, Applications Architect, Senior Database Administrator, Senior Developer, and Project Manager. The Senior Business Consultant handles technical and business analysis, leads client meetings, designs systems and architecture, develops applications, and manages project delivery. They apply project management methodologies to deliver solutions that meet business and enterprise goals. The Senior Business Consultant provides support for applications, manages database and system operations, and ensures ongoing maintenance and optimization.

Roles and Responsibilities

Reporting to the Director, ITS, below are some key accountabilities:

• Writing SQL queries, developing stored procedures and creating SQL reports.
• Report development using SSRS and other reporting tools.
• Preparing for, performing and supporting data conversion and data migration.
• Hands-on support of client-server applications in an enterprise environment, including managing and implementing enhancements and upgrades. Supported applications include SaaS, custom-built web, and third-party client-server.
• Develop and support applications in an enterprise environment, learning new technologies as required. Applications may be SaaS, custom-built web, or purchased third-party client/server.
• Systems analysis, application development, application support, project coordination, database analysis.
• Support users on systems and applications developing end-user documentation as appropriate.
• Design, build, document, and maintain interfaces between various applications and databases.
• Gather requirements and build custom reports, data extracts and interfaces to support custom reporting.
• Respond to, diagnose, and resolve database, application, system, and reporting issues.
• Develop excellent working relationships at all organizational levels, with vendors, and internal and external contractors.
• Take part in the after-hours and on-call support as needed, within the IT/S team and with external partners.
• Apply SDLC methodologies to build, test, integrate and deploy custom components across a variety of technologies.
• Work collaboratively on projects with varying roles as developer, technical lead, business analyst or project coordinator.
• Oversee quality, completeness, and maintainability of third-party remote support while ensuring security and best practices.
• Assess physical and technical security risks to data, software and hardware.

Qualifications and Educational Requirements

• A university degree in computer science, information systems, or related discipline.
• A minimum of 5 years’ experience with business and systems analysis, design, and development methodologies.
• Must have a strong technical background to be able to translate business requirements into a functional technical implementation.
• Application development experience is required.
• Strong technical knowledge and proficiency in a variety of systems and technologies including Microsoft SQL, .NET, SQL SSRS, CSS, REST, SOAP, XML.
• Experience with SharePoint Online, Azure, Office 365, Microsoft Graph, Power BI, is an asset.
• Experience using project management best practices and working within a structured PM environment.
• Demonstrated ability to formulate specifications for and to perform coding, testing, and debugging of computer programs, interfaces, and reports.
• Excellent communication skills along with a proven ability to collaborate and work well within a team environment.

Employment Terms and 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 $69,201.60 to $72,654.40 depending on experience, based on working 40 hours per week.
• 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:
• Transitional staff housing options (based on availability)
• Professional development
• Health care spending account
• Staff cafeteria and restaurant discounts
• Employee Assistance Plan
• Hybrid work environment (3 days in the office, 2 days remote)
• 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 has been 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.