Application Analyst

Job Title: Application Analyst - Intermediate

Location: Edmonton, Alberta (T6H 5T6)

Work Model: Hybrid – 3 days/week onsite

Duration: 8 months

Project Overview

Technology and Innovation supports Oil Sand Operations of Energy and Minerals and requires an experienced C#, Visual Studio, and MS-SQL application system analyst for the Bitumen Royalty in Kind (BRIK) program and related maintenance projects. The role involves requirements gathering, programming, application support, maintenance, and enhancements across application projects. The resource will work closely with application development and maintenance teams, subject matter experts, and business users to ensure code functions according to specification. Responsibilities include business liaison, technical analysis, application architecture alignment, technical design, database structure design, system optimization, testing support, troubleshooting, release coordination, and tracking project status. The role also includes supporting implementation, remediation, system testing, integration testing, and controlled software releases while ensuring solutions align with ministry needs, budget, and timelines.

Must-Have Skills

1. 5+ years of experience working as an Application Developer in a large enterprise IT environment utilizing .NET, Microsoft Visual Studio, and source control tools.
2. 5+ years of experience working across the full software development lifecycle.
3. 5+ years of experience with MS SQL Server, Management Studio, stored procedures, data modelling, and reporting services.
4. 5+ years of hands-on experience using C# and Visual Studio.
5. 5+ years of experience working with end-users for confirming requirements, supporting testing, and maintaining documentation.
6. Experience writing application code using C# and Visual Studio.
7. Experience designing and implementing MS-SQL databases.
8. Experience liaising with business users to collect and analyze business and user requirements.
9. Experience producing systems design manuals, technical manuals, and reference manuals.
10. Experience conducting unit testing, system testing, and integration testing.
11. Experience ensuring application changes are developed, tested, and implemented in a well-controlled manner using software release strategy.
12. Education meeting one of the required combinations in Computer Science, Computer Engineering, Information Technology, or related discipline, or equivalent certification with related experience.

Nice-to-Have Skills

1. 3+ years of experience in the analysis, development, and integration of complex IT systems with focus on multiple data sources, web services, and legacy IT solutions.
2. 3+ years of experience with Agile methodology.
3. 3+ years of experience with GitHub.
4. 3+ years of experience with unit testing and test-driven development tools.
5. Experience with application architecture, technical design, and database structure for average to high complexity applications.
6. Experience with performance testing, penetration testing, and system-level troubleshooting.
7. Experience identifying root cause of issues and providing solution recommendations.
8. Experience coordinating release schedules, service requests, and customer priorities.
9. Preferred experience with Oil Sands Regulations.
10. Ability to work in a hybrid onsite environment within Alberta and attend onsite meetings for strategic, architectural, and technical discussions.