Intermediate Application Analyst

JSG (Johnson Service Group, Inc.); Edmonton; On-site; CAD 90,000 - 120,000; Full time

Job summary

JSG (Johnson Service Group, Inc.) in Edmonton seeks an experienced System Analyst to deliver C#, Visual Studio, and MS-SQL applications for Oil Sands Operations. The role includes requirements gathering, coding, and collaboration with development teams to meet ministry needs.

Work with SMEs and testing teams on BRIK program deliverables, ensuring performance and documentation align with specifications. Strong .NET/SQL Server experience required.

Qualifications

• Must have 5 years experience as an Application Developer in a large enterprise IT environment using .NET, Visual Studio, and source control tools.
• Must have 5 years experience in software development across the full SDLC.
• Must have 5 years experience with MS SQL Server, SSMS, stored procedures, data modelling, and reporting services.
• Must have 5 years experience using C# and Visual Studio.
• Must have 5 years experience working with end-users—confirming requirements, supporting testing and maintaining documentation.

Responsibilities

• Deliver applications programming and analysis tasks as part of a system development process including support, maintenance and enhancements.
• Liaise with business units to ensure solutions meet current and strategic ministry needs.
• Align development team to follow Application Architecture.
• Write code for complex designs with minimal defects.
• Define non-functional requirements (Performance, Availability, Portability, Recovery).
• Produce Technical Design and Database structure for new applications.

Skills

C#

Visual Studio

MS-SQL

Application development

Requirements gathering

Code debugging

Education

University graduation: CS/CE/IT or related & 4yr exp

2yr diploma: CS/CE/IT & 6yr exp

1yr certificate: CS/CE/IT & 7yr exp

Active professional certification in related field

Tools

GitHub

Source control tools

Job description

Project Overview

Technology and Innovation (TI) now supports Oil sand Operations of Energy and Minerals. Technology and Innovations Ministry requires the services of an experienced C#, Visual Studio and MS-SQL application system analyst, that preferably has experience with Oil Sands Regulations.

Technology and Innovation (TI) now supports Oil sand Operations of Energy and Minerals. Technology and Innovations Ministry requires the services of an experienced C#, Visual Studio and MS-SQL application system analyst, that preferably has experience with Oil Sands Regulations.

The System Analyst will be assigned requirements gathering & programming duties for application projects and enhancement tasks. The individual will also work closely with application development and maintenance teams. In addition, the system analyst will work directly with subject matter experts in the business areas for application testing and remediation to ensure code functions as per specification. This system analyst will be assigned to work on implementation of the Bitumen Royalty in Kind (BRIK) program and maintenance projects.

Duties

Deliver applications programming and analysis tasks as part of a system development process as well as provide application support, maintenance and enhancements. A System Analyst applies a broad knowledge of various technical areas to foresee and rectify certain problem areas within technology or with a mix of technologies, but the focus is to ensure a certain business/functional use case is solved with the help of technology.

• Liaise with business units and program areas to ensure solutions meet current and strategic ministry needs.
• Align development team to follow Application Architecture.
• Write code for the most complex Functional and Technical Designs with minimal defects.
• Define non-functional requirements (Performance, Availability, Portability, Recovery / Recoverability etc.).
• Assess technical impacts up front and recommend better ways of designing applications to ease the development.
• Produce Technical Design, Database structure and Application Architecture for a new average to high complex application.
• Seek the best technical design solution that respects budget and timeline. Advocate the re-use of existing components/frameworks.
• Innovate in providing better efficient ways to design applications.
• Review Technical Designs from other developers and recommend optimization if necessary.
• Evaluate, with assistance, the quality of the product being delivered, and take action to improve situations.
• Assist/Execute performance/penetration tests and troubleshoot issues at the system level.
• Isolate root cause of issues and provide solution options/recommendations.
• Provide tracking and reporting of time and status on all work, as required.
• Contribute to the creation of the Application Lifecycle Planning.
• Identify and coordinate release schedules.
• Identify service requests and priorities with customers.
• Ensure planned releases remain on schedule.

Deliverable Details

Projects: Bitumen Royalty in Kind (BRIK)

Scope Of Services

• Write application code using C#, Visual Studio
• Coordinate with the Ministry of Energy and Minerals clients, analysts and/or interfaced systems clients and team members during testing, providing systems support and operational assistance.
• Design and implement MS-SQL databases.
• Liaise with business users to collect and analyze business and user requirements.
• Document business processes and applications.
• Produce systems design manuals.
• Produce technical and reference manuals.
• Conduct unit testing, system testing and integration testing.
• Ensure all application changes are developed, tested and implemented in a well-controlled manner using software release strategy

Must Haves

• Proposed resource must meet or exceed one of the following:
  • University graduation: Computer Science(CS), Computer Engineering (CE), Information Technology (IT) or related discipline & 4yr related experience;
  • 2yr diploma: CS, CE, IT or related discipline & 6yr related experience;
  • 1yr certificate: CS, CE, IT or related discipline & 7yr related experience;
  • current active professional certification or accreditation in related discipline from a recognized issuing body & 7yr related experience.
• 5 years’ Experience working as an Application Developer in a large enterprise IT environment utilizing .net, Microsoft Visual Studio, and source control tools.
• 5 years Experience working in software development across the full software development lifecycle
• 5 years Experience with MS SQL Server, Management Studio, stored procedures, data modelling, and reporting services
• 5 years Experience using C# and Visual Studio.
• 5 years Experience working with end-users - confirming requirements, supporting testing and maintain documentation.

Nice To Haves

• 3 years Experience in the analysis, development, and integration of complex IT systems with a specific focus on the management of multiple data sources , web services, and legacy IT solutions.
• 3 years Experience with Agile methodology.
• 3 years Experience with GitHub.
• 3 years Experience with unit testing and test-driven development tools.