Senior Application Developer (Information Technology Support D)

Sr. Application Developer - GOAPRDJP

11 months contract

10044 - 108 ST NW

Edmonton

1 Position - 3 submissions

Standard Background Check/Enhanced Security Clearance

Project Name:

TrustConnect

The Application Developer is responsible to lead and assist in the design development testing and planning of the Extract Transform and Load (ETL) phases for the data migration activities within the TrustConnect modernization project. Additionally the role is expected to make sense of the large amount of legacy data through analysis and insight to tell a cohesive story necessary for key executive strategic decision-making. The success of this part of the project is critical to the overall project success for the OPGT business and the GOA.

The current legacy system contains data that includes the finances of 19000 client accounts and manages over $600 million dollars. Due to the antiquated design and excessive system age (30 years) the existing data is unstructured fragmented duplicated and contains special characters that will result in data loss or corruption during migration. This data needs to be extracted from its current source(s) and transformed prior to loading it to its target destination in the new solution.

Deliver applications programming and analysis tasks as part of a system development process as well as provide application support maintenance and enhancements. An Application Developer 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 application to ease the development.

Produce Technical Design Database structure and Application Architecture for a new average to high complex application.

Seek for 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 application.

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

Must-Haves:

The proposed resource must meet or exceed one of the following: a. University graduation in computer science or a related discipline and 5-yr Application Developer (AD) experience; OR b. 2-yr diploma in computer science or a related discipline and 7-yr AD experience; OR c. 1-yr certificate in computer science or a related discipline and 8-yr AD experience; OR d. 9-yr AD experience.

Experience building Business Intelligence solutions in a collaborative agile development environment. 5 years

Experience building Business Intelligence solutions in a collaborative agile development environment. 5 years

Experience in facilitating meetings and communicating with senior management and project stakeholders. 5 years

Experience with data modeling SQL programming stored procedures triggers and user defined functions. 5 years

Experience with written and verbal communications including specific experience in drafting strategic business and technical documentation. 5 years

Experience working with a Public Trustee Office and trust accounting with the following: case management records management finance trust accounting taxes disbursements receipts vendors batch processing / frequencies etc. 3 years

Experience working with or testing Microsoft Dynamics 365 solutions (CRM Finance) or similar platforms. 5 years

Experience working with Rocket Universe software and multi-valued databases. Experience with MultiValue database is a type of NoSQL and multidimensional database that support the use of attributes having a list of values rather than a single value. Often referred to as a Pick database . 3 years

Experience with .Net frameworks and C# application development using object oriented techniques. 5 years

Nice-to-Haves:

Experience doing SQL Server development including procedures indexes foreign key relationships table creation and entity model diagrams. 5 years

Experience developing and maintaining positive relationships across the organization from front line staff to executives. 3 years

Experience integrating DevOps practices to the development workflow using CI/CD best practices. 3 years

Experience in the design development and implementation of complex IT solutions. 5 years

Experience with User Acceptance Testing processes on large complex multi-stakeholder environment. 5 years

Experience with various software development methodologies (i.e. agile waterfall scrum Kanban etc.). 5 years

Experience working in or for the public sector. 5 years