Application Analyst – Intermediate

We are seeking an experienced Application Analyst – Intermediate to support the Government of Alberta's Technology and Innovation team on the Bitumen Royalty in Kind (BRIK) project.

The successful candidate will be responsible for application development, systems analysis, database design, application maintenance and enhancements. This role requires strong hands-on experience with C#, Visual Studio and Microsoft SQL Server, along with the ability to collaborate with business stakeholders, technical teams and end-users.

The ideal candidate will have experience developing and maintaining enterprise-level applications and translating business requirements into effective technical solutions.

Requirements

- Develop, enhance and maintain enterprise applications using C# and Visual Studio.
- Design, develop and implement Microsoft SQL Server databases.
- Develop and optimize SQL queries, stored procedures and database structures.
- Gather, analyze and document business and technical requirements.
- Prepare technical designs, database structures, application architecture and system documentation.
- Collaborate with business users, analysts, developers and technical teams.
- Conduct unit testing, system testing and integration testing.
- Troubleshoot application issues, identify root causes and recommend solutions.
- Review technical designs and application code to ensure quality and performance.
- Support application releases, maintenance activities and enhancements.
- Coordinate testing activities and provide operational support.
- Ensure application changes are developed, tested and implemented through controlled release processes.

Mandatory Technical Skills & Experience

- Minimum 5 years of hands-on experience in C# development.
- Minimum 5 years of experience using Visual Studio.
- Minimum 5 years of experience with Microsoft SQL Server.
- Strong experience with SQL stored procedures and data modelling.
- Experience with SQL Server Reporting Services (SSRS).
- Minimum 5 years of experience in enterprise application development.
- Strong understanding of software development processes and application maintenance.
- Minimum 5 years of experience working directly with end-users to gather, validate and confirm requirements.