Application Developer - Senior

Description : 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 BR 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

Equipment Requirements :

Resource will require own equipment

Resource must provide their own computer and related equipment. The computer's operating system must be a modern version of Windows or MacOS that is compatible with Azure Virtual Desktop (AVD) and related software for remote access. Windows is preferred due to better compatibility. AVD / remote-related software will be installed on the resource's computer.

In the event that the Contractor s resources are directed to work remotely, the Contractor shall be responsible for providing all of its equipment, including computers, software, printers, supplies, desks and chairs. However, the Province shall ensure that the Contractor s resources have the necessary access and credentials to the Government of Alberta s system.

The fixed rate quoted must be inclusive of all overhead, office space and equipment, including supplies, administrative burden, mark-up and all other costs to perform the Services for the duration of the Contract.

Working Hours :

Standard Hours of work are 08 : 15 16 : 30 Alberta time, Monday through Friday excluding holidays observed by the Province

Work must be done from within Alberta, due to network and data security issues.

The role will be primarily remote, however in the event of an onsite meeting, the GoA does not pay for travel to attend on-site meetings, nor any expenses related to relocation, commuting, housing / accommodation, food / drink.

Notes on Location :

This resource will primarily work remotely; however, the resource may be required to attend meetings or work sessions in office on reasonable notice from the Province.

At the time of providing such notice, the Province will advise of the expected duration of any such meetings or work sessions. However, time to travel and any associated expenses to and from Edmonton and / or travel within Alberta will be at no cost to the Province.

Incumbency :

Previously this role was filled by a contractor, however, for this and all other opportunities, the Ministry seeks the best person to fill the role.

Enhanced Background Check :

A standard criminal record check will be required before we start the Enhanced Security Clearance process.

An Enhanced Security Clearance will be required for this position, which will be coordinated by GoA only for this position. Enhanced Security Clearance includes a standard Criminal Records Check and enhanced security including a Credit Check.

Mandatory Training Courses :

Once hired the resource will be required to complete all mandatory training which includes but not limited to Freedom of Information and Protection of Privacy Act and Security awareness training. There may also be some optional courses as well.

Anticipated Interviews Dates

will be held between (Nov 26-Nov 27)

Refer to the Job Posting attachments for the proposed form of contract applicable to this Contingent Resource Request

Scoring Methodology :

Financial / Pricing : 20%

Resource Qualifications : 20%

Interview Process : 60%

SUBMISSION MUST INCLUDE :

RESUME

ALL REQUIRED EXPERIENCE MUST BE DESCRIBED IN RESUME UNDER THE JOB / PROJECT WHERE EXPERIENCE WAS ATTAINED.

EACH JOB / PROJECT MUST CONTAIN THE TERM OF THE JOB / PROJECT IN THE FORMAT MMM / YYYY to MMM / YYYY.

RESOURCE REFERENCES

o Three references, for whom similar work has been performed, must be provided. The most recent reference should be listed first. Reference checks may or may not be completed to assist with scoring of the proposed resource.

Enable Skills-Based Hiring

No

• $(function(){ $(".qualPlaceHolder").each(function(){ if($(this).parents('#jsLegend').length != 1 || $(this).find('ul').length == 0) { var requested = $(this).attr("requested"); var presented = $(this).attr("presented"); var dynamicId = $(this).attr("id"); var text = $(this).attr("text"); var readOnly = ($(this).attr("edit") === 'true'); var flexibleScaleLevels = $(this).attr("flexibleScaleLevels"); var flexibleScaleLevelNames = $(this).attr("flexibleScaleLevelNames"); new FG.Qual({ element : $(this), readOnly : readOnly, requested : requested, presented : presented, dynamicId : dynamicId, text : text, flexibleScaleLevels : flexibleScaleLevels, flexibleScaleLevelNames : flexibleScaleLevelNames, }).initialize(); } }) });

Qualification

Additional Details

Qualification

Assessment

Must Have

Education

Yes / No - The proposed resource must meet or exceed one of the following : a. University graduat...

Yes

Other

Other - Eligibility for Enhanced Security Clearance Yes / No

Yes

Work Experience

Duration - Experience building Business Intelligence solutions in a collaborative, agile develop...

5 years

Duration - Experience delivering Extract, Transform and Load (ETL) solutions utilizing Microsoft...

5 years

Duration - Experience in facilitating meetings and communicating with senior management and...

5 years

Duration - Experience with data modeling, SQL programming, stored procedures, triggers and user...

5 years

Duration - Experience with written and verbal communications including specific experience in...

5 years

Duration - Experience working with a Public Trustee Office and trust accounting.

3 years

Duration - Experience working with or testing Microsoft Dynamics 365 solutions (CRM, Finance)

5 years

Duration - Experience working with Rocket Universe software and multi-valued databases.

3 years

Duration -Exp with .Net frameworks and C# application development using ...

5 years

Nice to Have

Work Experience

Duration-Exp doing SQL Server development including...

5 years

Duration - Experience developing and maintaining positive relationships across the organization...

3 years

Duration-Experience integrating DevOps practices to the development workflow using CI / CD...

3 years

Duration - Experience in the design, development and implementation of complex IT solutions.

5 years

Duration - Experience with User Acceptance Testing processes on large, complex...

5 years

Duration - Experience with various software development methodologies (i.e. agile, waterfall...

5 years

Duration - Experience working in or for the public sector.

5 years