Sr. Application Developer - GOAPRDJP00000731

Source Code; Edmonton; On-site; CAD 90,000 - 130,000; Full time

Job summary

Source Code in Edmonton is seeking a Sr. Application Developer to lead ETL, data migration, and analysis for the TrustConnect modernization project.

The role focuses on extracting, transforming, and loading legacy data, with emphasis on turning unstructured data into actionable insights for executive decisions. Applicants should have BI experience in agile environments, strong SQL and .NET/C# skills, and familiarity with legacy systems valued in financial contexts.

Qualifications

• Experience in BI solutions in agile development environments.
• Strong SQL, data modeling, and ETL capabilities.
• Proficiency in .NET/C# and object-oriented design.
• Knowledge of Dynamics 365 CRM/Finance is a plus.
• Experience with legacy data migration and data quality issues.

Responsibilities

• Lead design, development, testing and ETL for data migration in TrustConnect.
• Collaborate with stakeholders to align solutions with ministry needs.
• Create technical design, DB structure, and architecture for complex apps.
• Assess technical impacts and propose optimized designs.
• Coordinate release schedules and tracking of work progress.
• Support performance testing and troubleshoot system issues.
• Evaluate product quality and drive improvements with the team.

Skills

SQL

Data modeling

C#

OO programming

Agile development

Microsoft Dynamics 365

ETL

BI solutions

NoSQL / MultiValue

Education

Computer science degree

Tools

Rocket Universe

Pick database

CI/CD

Job description

About the job Sr. Application Developer - GOAPRDJP00000731

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 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.
• 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-Have's:

• 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-Have's:

• 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