Application Developer - Senior
Buzzclan
- USA
- Permanent
- Full-time
Seniors, Community & Social Services - TrustConnectScope:
This role 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 - 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.Duties:
1. Design, build and deploy effective data migration packages utilizing SQL Server Integration Services (SSIS).
2. Write stored procedures, triggers and user defined functions using Microsoft SQL Server/T-SQL to extract, transform and load legacy data.
3. Build Business Intelligence solutions in a collaborative, agile development environment.
4. Write application code using .NET C# and Microsoft SQL with the ability to create both desktop and web based interfaces.
5. Integrate SSIS packages with D365 CRM (Customer Service) or D365 Finance (formerly AX) to load the transformed data into the new application.
6. Create automated release packages and ensure data migration solutions are added to the department s source control system as per ministry standards.
7. Use discretion and make sound decisions while working with a minimal amount of direction while being pro-active in keeping their management informed of project related issues.
8. Communicate project status and issues to the program and client management.
9. Respectfully question ideas and share a point of view with others in support of the business requirements and needs.
10. Utilize an agile methodology such as Kanban, Scrum, or SAFe to organize workload and to short iterations with rapid feedback loops.
11. Lead troubleshooting and root cause analysis activities when transforming the legacy data.
12. Produce technical documentation and reference materials.
13. Produce database ERD diagrams and systems design manuals.
14. Perform unit and integration testing.
15. Participate in release and iteration plans.
16. Perform additional responsibilities as required by the Project Manager.Equipment Requirements:
Resource will require own equipmentResource 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 within Alberta due to network and data security issues.
The role will be 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:
The resource will work remotely but must be available for on-site meetings when required. On-site meetings may include, but are not limited to, strategic, analytical, and technical discussions, as well as meetings with team members, senior managers, directors, executive directors, and business clients. The frequency of these meetings could be up to 3-4 times per fiscal year.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.Background Check Required:Standard Background Check:
The Supplier shall, prior to commencement of the Services, provide the Province, on its request and at no cost to the Province, with criminal record checks.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 (Sept 16-Sept 18)
Refer to the Job Posting attachments for the proposed form of contract applicable to this Contingent Resource RequestScoring 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(); } }) }); QualificationAdditional Details
- Payment Terms : Y030 - within 30 days Due net|Y015
- Maximum Extension Term (Months) : 6
Must Have
EducationYes/No - The proposed resource must meet or exceed one of the following: a. University graduat... Yes
Work ExperienceDuration - Experience in creating and implementing business intelligence requirements.5 yearsDuration - Experience in facilitating meetings and communicating with senior management and...5 yearsDuration-Experience with programming language .NET Core5 yearsDuration-Experience with SQL Server Integration Services5 yearsDuration - Experience with written and verbal communications including specific experience in...5 yearsDuration - Experience working with a Public Trustee Office and trust accounting.2 yearsDuration - Experience working with Rocket Universe software and multi-valued databases.2 yearsDuration -Exp with .Net frameworks and C# application development using ...5 yearsDuration-Exp with stored procedures, data modelling, and reporting services using...5 yearsDuration - Knowledge of ETL processes and tools, with hands-on experience designing and implement...5 years
Nice to Have
Work ExperienceDuration-Exp doing SQL Server development including...3 yearsDuration - Experience developing and maintaining positive relationships across the organization...3 yearsDuration-Experience integrating DevOps practices to the development workflow using CI/CD...3 yearsDuration - Experience in the design, development and implementation of complex IT solutions.3 yearsDuration - Experience with User Acceptance Testing processes on large, complex...3 yearsDuration - Experience working in or for the public sector.1 yearsDuration - Experience working with various software development methodologies (i.e. agile...3 years