Systems Analyst

This position is responsible for support, design, development, implementation, integrity, security, and administration of all corporate business solutions and databases. Specializing in coordinating the integration of corporate business systems, troubleshooting advanced database issues, and providing technical support to the Information Services department team.

KEY DUTIES AND RESPONSIBILITIES

Corporate Business Solutions Planning and Development (25%)

Establishes business solutions roadmaps to suit the overall strategy of Information Services (IS) and corporate needs.

Corporate Database Administration & Support (15%)

Completes database administration includes backups, restores, data availability and accessibility using standard Open Database Connectivity (ODBC), and security on Microsoft SQL Server platform.

Ensures database servers work within the network infrastructure.

Integration of Corporate Business Systems Support (20%)

Manages and monitors all system integrations and works with vendors to ensure optimal performance and reliability.

Creates scripts and programs to convert, extract, and integrate Microsoft SQL server database data from multiple servers in a complex network environment.

Software Maintenance & Updates (35%)

Evaluates and develops system workflows, and processes to design solutions to automate manual tasks.

Other Related Duties (5%)

Completes other related duties/special projects as assigned by Manager, Information Services.

Adheres to applicable responsibilities and accountabilities as outlined in the Sturgeon County Health and Safety Management System.

KNOWLEDGE, EDUCATION, QUALIFICATIONS, SKILLS, ABILITIES, AND EXPERIENCE

**Required**:
Post-secondary degree from a recognized institution in computing science or information technology or computer programming.

Ability to work in a team environment and independently.

Strong organizational and time management skills, with the ability to set and manage among conflicting priorities while meeting deadlines.

Ability to communicate clearly and professionally verbally and in writing, including being adaptable, receptive, and timely when communicating with others, and possessing tact and discretion.

Attention to detail and accuracy when completing work.

Proficiency with Microsoft Office products, including Microsoft PowerPlatform.

A minimum of 5 years of experience with the following are required (preference given to those with more experience):
Microsoft SQL Server

ASP.NET

Microsoft Power Platform

C#,

Microsoft IIS and

Microsoft Visual Studio

**Assets/Preferences**:
Knowledge of some or all of the following are beneficial to this position:
Microsoft SQL Server integration

Microsoft Great Plains 2018

PostGRE

MSSQL

Additional experience with some or all of the following are considered assets:
Diamond Municipal

Work Tech

Avanti

FMW

ESRI ArcGIS software

Gemini GPS software

HPTRIM software