System Analyst

Join Our Team as a Remote Systems Analyst – Long-Term Contract Opportunity!

Are you a skilled Systems Analyst with a passion for optimizing ERP systems and managing complex data environments? Sturgeon County is seeking a talented professional to join our team remotely on a long-term contract basis (18 months, with possibility of extension). In this key role, you’ll be an integral part of our Business Transformation team, providing expert support and innovative solutions for our enterprise systems.

You’ll bring your proven experience in SQL Server Database Administration, systems maintenance (including Microsoft Dynamics GP, CentralSquare Diamond ERP, CentralSquare Pearl, and PSD-Citywide Budgeting), and integration/reporting tools such as FME, SSIS, and other ETL platforms. Your contributions will help ensure the integrity, performance, and security of our corporate business systems.

This is an exciting opportunity to work with a forward-thinking municipality committed to leveraging technology to enhance service delivery—all while working remotely with a collaborative and supportive team. Although this position is primarily remote, the successful candidate must be able to work in office from time to time, located in Morinville, AB.

KEY DUTIES AND RESPONSIBILITIES

Software Maintenance & Updates (35%)

• Coordinates with application owners, manages application support plans and operates client access and permissions to various commercial and custom enterprise systems within the organization.
• Responds to user requests including resolving issues related to applications such as the (ERP) to support operational delivery such as supporting year end activities. Maintains a knowledge base which includes how to configure, install, respond to application requests. Reports applications issues and bugs to the vendor and works with the vendor to implement suggestions and recommendations to solve complex application issues, including issues that needs to be referred to development.
• Evaluates and develops system workflows, and processes to design solutions to automate manual tasks.
• Works as part of a project team to plan, install and upgrade corporate applications along with testing of new releases of software and patches in a test environment before implementing in production.

Corporate Business Solutions Planning and Development (25%)

• Establishes business solutions roadmaps to suit the overall strategy of Information Services (IS) and corporate needs.
• Develops custom reports from Microsoft SQL Server Databases (PowerBI, Report Builder, Crystal Reports) for all corporate applications including, including the Enterprise Resource Planning software (ERP).
• Sets application, and data standards, non-functional requirements and evaluates proposals to assist in the selection of new software projects. Develops solutions that address problems and challenges faced with the use of Corporate and department level applications using Information Technology (IT) tools such as Visual Studio, SQL Server, PowerShell, Azure AD B2C and the Microsoft Power Platform including PowerAutomate, PowerApps, and PowerBI.

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.
• Works with the Manager, Information Services, Financial Services staff, and the Business Analyst to identify, define, and document best practices and processes to ensure consistent application of user security roles within multiple systems.
• Assists Information Services staff with provisioning and maintaining user application security.

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.

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:

• A minimum of 3-5 years of experience with the following are required: Microsoft SQL Server, ASP.NET, Microsoft Power Platform, C#,, Microsoft IIS and/or Microsoft Visual Studio.
• 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.
• Ability to exercise and apply sound judgment, solve complex problems, take initiative, and make informed decisions.
• Attention to detail and accuracy when completing work.
• Proficiency with Microsoft Office products, including Microsoft PowerPlatform.

Assets:

• Knowledge of some or all of the following are beneficial to this position: Microsoft SQL Server integration, Microsoft Great Plains 2018, PostGRE and/or MSSQL.
• Additional experience with some or all of the following are considered assets: Diamond Municipal, Work Tech, Avanti, FMW, ESRI ArcGIS software, PerfectMind, and HPTRIM software.