Business Systems Analyst

Verafin; San Juan de Terranova; On-site; CAD 70,000 - 110,000; Full time

Job summary

Verafin is seeking a Business Systems Analyst to lead analysis and definition of business requirements and oversee the development, implementation, maintenance, and support of business applications, systems, and software.

The successful candidate will define requirements for City divisions, implement COTS/SaaS and custom apps, manage SQL Server environments, ERP integrations, and administer Office 365/SharePoint with user training and advisory services.

Qualifications

• Minimum 3 years in programming and systems analysis.
• Understanding of networking concepts.
• Experience with enterprise IT applications and environments.

Responsibilities

• Define business systems requirements for City divisions and recommend applications/systems to meet needs.
• Implement COTS/SaaS and develop custom applications, including requirements, design, coding, testing, and deployment.
• Manage application access and security for multiple COTS, SaaS and custom apps.
• Provide primary application support and advisory services, including patches, upgrades, and bug resolution.
• Manage SQL Server environment: maintenance plans, security, performance, and alerts.
• Support ERP applications, including integrations and interfaces.
• Administer MS Office 365, SharePoint, and mobile deployment/troubleshooting.
• Maintain corporate intranet and public websites; security and training.
• Develop and maintain custom reports/queries using SQL views and stored procedures.
• Provide training and guidance to the SQL/Reports Developer role.

Skills

Business analysis

Requirements gathering

Communication

Training

Education

High School Diploma + 3-year post-secondary Diploma in IT

Tools

MS SQL Server

SQL Server Maintenance Plans

SharePoint

Office 365

Crystal Reports

SSRS

IIS

Drupal CMS

Apache/Tomcat

Visual Studio

Visual SVN

Job description

The Opportunity

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.

Accountabilities

• 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.

The successful applicant will be required to participate in all training programs applicable to this position and other related work. The above statements reflect the general duties considered necessary to describe the principal functions of the job identified and shall not be considered a detailed description of all work requirements that may be inherent in the job.

Qualifications

Education: High School Diploma supplemented by a 3-year post-secondary Diploma in Information Technology.

Experience

A minimum of three (3) years’ experience in a programming and systems analysis position with similar responsibility, complexity, and technical platforms. A general understanding of networking concepts is also required.

Preference will be given to individuals with recent experience (within the last 5 years) in the following areas:

• Technical support of enterprise systems using Microsoft SQL Server as the database management system.
• Technical systems support of enterprise business applications such as Financial Management, Human Resources / Payroll, Land Management, Mass Appraisal, Public Safety & Computer Aided Dispatch (CAD), Customer Relationship Management (CRM), or Office Productivity / MS Office 365.

Recent experience (within the last 5 years) in these areas would be considered an asset:

• Application development / programming using C#, .Net, PHP, XML, html, CSS, Web Design, and Web Services.
• Application development tools including Microsoft Visual Studio, and Visual SVN.
• Application web server software including Microsoft IIS, Microsoft SharePoint, Drupal CMS, and Apache/Tomcat.
• Report Development using Crystal Reports and Microsoft SQL Server Reporting Services (SSRS).