Job Description – Application Analyst (Intermediate)
Client: Government of Alberta (GoA)
Project: Bitumen Royalty in Kind (BRIK)
Department: Technology and Innovation
Location: Edmonton, Alberta, Canada
Work Arrangement: Hybrid – 3 days onsite per week
Duration: Contract – Long Term
Work Hours: Monday–Friday, 8:15 AM–4:30 PM Alberta Time
Important: Candidates must work from within Alberta. Relocation and commuting expenses will not be reimbursed.
Job Summary
The Government of Alberta is seeking an experienced Application Analyst – Intermediate with strong hands-on experience in C#, Visual Studio, Microsoft SQL Server, application development, and enterprise system integration.
The successful candidate will support the Bitumen Royalty in Kind (BRIK) program by designing, developing, enhancing, testing, and maintaining enterprise applications.
This role requires close collaboration with business stakeholders, technical teams, and subject matter experts to translate business requirements into reliable, secure, and scalable software solutions.
Experience with oil sands regulations or royalty-related systems would be an advantage.
Key Responsibilities
Design, develop, enhance, and maintain enterprise applications using C# and Visual Studio.
Design, implement, and optimize Microsoft SQL Server databases, including stored procedures, data models, and reporting solutions.
Gather, analyze, and document business and technical requirements from end users and stakeholders.
Develop functional specifications, technical designs, database structures, and application architecture documentation.
Work closely with application development and maintenance teams to ensure solutions meet business requirements.
Perform unit testing, system testing, integration testing, and application troubleshooting.
Investigate production issues, identify root causes, and recommend corrective solutions.
Review technical designs and recommend improvements in performance, scalability, maintainability, and security.
Define non-functional requirements, including performance, availability, portability, and disaster recovery.
Support application integration with existing enterprise systems.
Coordinate application releases, deployments, change management, and production support activities.
Maintain technical manuals, system design documents, and business process documentation.
Participate in Agile development activities and collaborate with cross-functional teams.
Ensure application changes follow established development, testing, and release management standards.
Mandatory Qualifications
Candidates must meet the applicable education and experience requirements and demonstrate the following:
5+ years of application development experience in a large enterprise IT environment.
5+ years of software development experience across the required development technologies and environments.
5+ years of experience with Microsoft SQL Server, including stored procedures, data modeling, and reporting services.
5+ years of hands-on development experience using C# and Visual Studio.
5+ years of direct experience working with end users to gather, confirm, and validate business requirements.
Strong knowledge of application design, development, testing, integration, troubleshooting, and maintenance.
Ability to produce technical documentation and communicate effectively with business and technical stakeholders.
Ability to work from within Alberta, Canada, and attend the Edmonton office three days per week.
Preferred Qualifications
3+ years of experience analyzing, developing, and integrating complex enterprise IT systems.
3+ years of experience working in an Agile development environment.
3+ years of experience using GitHub for source code management and collaboration.
3+ years of experience with unit testing and test-driven development (TDD) tools.
Experience with oil sands regulations, energy-sector applications, or royalty management systems.
Experience supporting government or other large enterprise applications.
Key Technical Skills
Primary Skills: C#, Visual Studio, MS SQL Server, T-SQL, Stored Procedures, Database Design, Data Modeling, Reporting Services, Enterprise Application Development.
Additional Skills: Application Architecture, System Integration, Requirements Gathering, Agile, GitHub, Unit Testing, TDD, Application Support, Troubleshooting, SDLC, Technical Documentation, Release Management.
Work Location & Conditions
Hybrid work arrangement: 3 days onsite per week in Edmonton, Alberta.
All work must be performed from within Alberta due to security requirements.
Candidates must be available for onsite technical discussions and meetings.
A standard background check is required.
Mandatory security awareness and privacy training must be completed after onboarding.
Contractors are generally expected to provide equipment suitable for remote work, although government equipment may be provided if necessary.
Candidate Submission Requirements
The submission must include:
Updated resume clearly demonstrating all mandatory experience.
Employment and project dates in MMM/YYYY to MMM/YYYY format.
Relevant technologies and responsibilities listed under the actual projects where the experience was gained.
Three professional references from similar work, with the most recent reference first.
Conflict of Interest (COI) attestation.
Confirmation of Alberta work location and hybrid availability.
Selection Process
Interviews are expected approximately two weeks after the posting closes.
Ideal Candidate: An experienced C#/.NET Application Analyst or Developer with strong Visual Studio, MS SQL Server, enterprise application development, business requirements gathering, and production support experience who is available for hybrid work in Edmonton, Alberta.
