Sr. Application Developer

11+ months contract

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 19,000 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

• 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

• 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