Intermediate Application Analyst

Johnson Service Group; Edmonton; On-site; CAD 90,000 - 130,000; Full time

Job summary

Johnson Service Group, Inc. is seeking a skilled System Analyst with strong C#, Visual Studio and MS-SQL experience to support Oil Sands regulations-related applications. You will gather requirements, work with development and testing teams, and implement BRIK program-related projects.

The role involves analyzing business needs, producing technical designs, and ensuring code meets specifications. Collaboration with ministry clients and stakeholders is essential.

Qualifications

• University degree or equivalent in CS/CE/IT with related experience.
• 5+ years as an Application Developer in enterprise IT with .NET/VS and source control.
• 5+ years in full software development lifecycle.
• 5+ years with MS SQL Server, stored procedures and reporting services.
• 5+ years with C# and Visual Studio.
• 5+ years working with end-users to confirm requirements and support testing.

Responsibilities

• Deliver programming and analysis tasks within a system development process.
• Ensure solutions meet ministry needs and align with architecture.
• Write code for complex designs with minimal defects.
• Define non-functional requirements (Performance, Availability, Recovery).
• Prepare design docs and database structure for new applications.
• Coordinate releases and track time/status of work.

Skills

C#

Visual Studio

MS-SQL

Application Development

Testing coordination

Education

CS/CE/IT degree

2-year CS/CE/IT diploma

1-year CS/CE/IT certificate

Professional certification

Tools

GitHub

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. 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

• 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.

#LI-TF1