Business Systems Analyst

St. John's is a progressive city with a strong connection to the past and a positive outlook on the future. As one of the oldest cities in North America we have a unique history, but we are also a growing city with the needs and opportunities of a modern urban population. The City of St. John’s is committed to recruiting world-class talent and expertise to join our City staff, more than 1200 strong, who provide a vast array of valued services to the residents of St. John's and the metropolitan area. If you are an innovative thinker with a positive attitude and a commitment to quality, we want you to help us make St. John’s a city where people want to live and feel they belong.

The Business Systems Analyst is responsible for analysis and definition of business requirements, and the development, implementation, maintenance, and support of business applications, systems and software.

• Define business systems requirements for City divisions and recommend applications / systems / software to meet their needs. • Implement Commercial Off the Shelf (COTS)/ Software as a Service (SaaS) applications, and develop and deploy custom applications, including user requirements definition, solution design, programming/coding, testing, debugging, training, data conversion, documentation, and deployment, in accordance with Information Technology (IT) Best Practice and established Information Services (IS) departmental procedures. • Manage application-level user access and security, ensuring appropriate access is maintained for user groups within each application, using varying security administration tools specific to each COTS, SaaS, and custom application. • Provide primary application support and advisory services to users of the City’s applications and software, including application enhancements, configuration changes, management of software patches / service packs / upgrades, troubleshooting problems and errors, liaising with vendor support resources to identify and report problems and bugs, and determining appropriate resolution to problems. • Manage the City’s enterprise MS SQL Server environment by creating and maintaining SQL Server Maintenance Plans for backups and other standard database maintenance procedures, managing database security according to vendor and internal requirements, and monitoring and tuning of SQL Server performance, metrics, and alerts. • Support and maintain the City’s Enterprise Resource Planning (ERP) Applications, including development and maintenance of integrations & interfaces. • Manage the administration of the City’s enterprise E-mail environment, MS Office 365 productivity suite, SharePoint environment and deployment/troubleshooting of same on mobile devices. • Manage the City’s corporate Intranet, and the City’s public websites, including website and server maintenance, web application development, user training and advisory services, installation of software upgrades, and design and administration of website security. • Develop and maintain custom reports and queries for the City’s business systems, including report requirements definition, creation of SQL views and Stored procedures. • Provide training, guidance, and direction to the SQL / Reports Developer position as required.