Job Description

Senior Business Consultantaims 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 xc3x8eyxc3xa2rhe Nakoda (Stoney Nakoda) comprised of the Bearspaw, Chiniki, and Goodstoney Nation as well as the Tsuutina 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 OpportunityThe 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 ResponsibilitiesReporting 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 wen 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
• Heath care spending account
• Staff cafeteria and restaurant discounts
• Employee Assistance Plan
• Hybrid work environment (3 days in the office, 2 days remote)
• Onsite

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.

The Banff Centre