Application Developer - Senior
Apply NowCompany: Della Infotech, Inc.
Location: Edmonton, AB T5A 0A1
Description:
Description:
Project Name:
JIMS 3.0 (Justice Information Management System)
Scope:
The Data Unit requires the support of contingent labour to support a data integration project aimed to re-design and implement several reporting data marts, with conformed dimensions, containing court data into an Enterprise Data Warehouse (EDW) and a set of dependent views.
The position will be responsible for performing technical strategic functions, ensuring the architecture supports Justice data analytics and reporting needs.
Additionally, this role may support application of the Data Fabric architecture, data quality, data standards, and best practices to development as needed.
The successful candidate is expected to have a broad skill set and be capable of performing diverse functions and activities, including but not limited to:
Understanding of data warehouse design principles, including dimensional modeling, star schemas, snowflake schemas, and the use of conformed dimensions to ensure consistency across data marts.
Create both logical and physical data models that efficiently store data and support business processes.
Support the development and adoption of best practices for data management, integration and common data management, and standardized methodologies.
Contribute to development of individual data architectures and data quality practices, as needed, to support business objectives.
Work with datasets using ETL (Extract, Transform, Load) tools and techniques for integrating data from various sources into the EDW.
Interact with clients/partners (GOA-internal and/or external).
Duties:
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 and Data Architecture.
Write code for the most complex Functional and Technical Designs with minimal defects.
Hands - on experience with building and managing data solutions using SQL and/or Python.
Experience in data modelling (star or snowflake schema), including designing and developing data models to support business requirements.
Develop and implement data warehouse solutions to support business intelligence and analytical needs.
Demonstrate strong commitment to Data Security and Compliance to protect sensitive information and enforce data governance in enterprise platforms (access control, security policies across platforms etc.).
Conduct data profiling to identify data trends, patterns and data quality issues.
Experience with software development best practices including code reviews, unit testing and documentation.
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.
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 Canada, 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:
Resource will work remotely, though must be available for onsite meetings when required.
Onsite meetings include but are not limited to strategic, architectural, and technical discussions, meeting with team members, senior managers, directors, executive directors and business clients. Frequency of meeting could be up to 3-4 monthly.
Incumbency:
This is a net new role.
Enhanced Background check required
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.
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 (Feb19-Feb21)
Refer to the Job Posting attachments for the proposed form of contract applicable to this Contingent Resource Request
Scoring Methodology:
Financial/Pricing: 10%
Resource Qualifications: 20%
Interview Process: 70%
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.
Qualification
Additional Details
University graduation in computer science or a related discipline and 4-yr relevant experience;
OR
2-yr diploma in computer science or a related discipline and 6-yr relevant experience;
OR
1-yr certificate in computer science or a related discipline and 7-yr relevant experience;
OR
a currently active professional certification or accreditation and 8-yr relevant experience" class="overflowAuto">Yes/No - The proposed resource must meet or exceed one of the following combinations of...
Yes Work Experience
Duration - Experience in designing, building, testing, deploying, and supporting...
8 years
Duration - Experience using Microsoft SQL.
3 years
Duration- Experience with Python development
3 years
Duration - Experience with software development processes, and all associated best practices...
8 years
Duration - Experience working with various software development methodologies (i.e. agile...
8 years
Duration - Exp working in a relevant data environment such as...
8 years
Duration - Knowledge of ETL processes and tools, with hands-on experience designing and implement...
8 years
Nice to Have Work Experience
Duration - Experience assisting in overall project planning and providing advice on system...
5 years
Duration - Experience making decisions and recommendations on highly technical or complex issues...
5 years
Duration - Experience translating data from multiple sources to a single solution, including...
5 years
Duration - Experience with cloud computing or big data platforms and infrastructure
5 years
Duration - Experience working in the public sector
2 years
Project Name:
JIMS 3.0 (Justice Information Management System)
Scope:
The Data Unit requires the support of contingent labour to support a data integration project aimed to re-design and implement several reporting data marts, with conformed dimensions, containing court data into an Enterprise Data Warehouse (EDW) and a set of dependent views.
The position will be responsible for performing technical strategic functions, ensuring the architecture supports Justice data analytics and reporting needs.
Additionally, this role may support application of the Data Fabric architecture, data quality, data standards, and best practices to development as needed.
The successful candidate is expected to have a broad skill set and be capable of performing diverse functions and activities, including but not limited to:
Understanding of data warehouse design principles, including dimensional modeling, star schemas, snowflake schemas, and the use of conformed dimensions to ensure consistency across data marts.
Create both logical and physical data models that efficiently store data and support business processes.
Support the development and adoption of best practices for data management, integration and common data management, and standardized methodologies.
Contribute to development of individual data architectures and data quality practices, as needed, to support business objectives.
Work with datasets using ETL (Extract, Transform, Load) tools and techniques for integrating data from various sources into the EDW.
Interact with clients/partners (GOA-internal and/or external).
Duties:
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 and Data Architecture.
Write code for the most complex Functional and Technical Designs with minimal defects.
Hands - on experience with building and managing data solutions using SQL and/or Python.
Experience in data modelling (star or snowflake schema), including designing and developing data models to support business requirements.
Develop and implement data warehouse solutions to support business intelligence and analytical needs.
Demonstrate strong commitment to Data Security and Compliance to protect sensitive information and enforce data governance in enterprise platforms (access control, security policies across platforms etc.).
Conduct data profiling to identify data trends, patterns and data quality issues.
Experience with software development best practices including code reviews, unit testing and documentation.
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.
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 Canada, 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:
Resource will work remotely, though must be available for onsite meetings when required.
Onsite meetings include but are not limited to strategic, architectural, and technical discussions, meeting with team members, senior managers, directors, executive directors and business clients. Frequency of meeting could be up to 3-4 monthly.
Incumbency:
This is a net new role.
Enhanced Background check required
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.
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 (Feb19-Feb21)
Refer to the Job Posting attachments for the proposed form of contract applicable to this Contingent Resource Request
Scoring Methodology:
Financial/Pricing: 10%
Resource Qualifications: 20%
Interview Process: 70%
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.
Qualification
Additional Details
- Payment Terms : Y030 - within 30 days Due net|Y015
- Maximum Extension Term (Months) : 12
University graduation in computer science or a related discipline and 4-yr relevant experience;
OR
2-yr diploma in computer science or a related discipline and 6-yr relevant experience;
OR
1-yr certificate in computer science or a related discipline and 7-yr relevant experience;
OR
a currently active professional certification or accreditation and 8-yr relevant experience" class="overflowAuto">Yes/No - The proposed resource must meet or exceed one of the following combinations of...
Yes Work Experience
Duration - Experience in designing, building, testing, deploying, and supporting...
8 years
Duration - Experience using Microsoft SQL.
3 years
Duration- Experience with Python development
3 years
Duration - Experience with software development processes, and all associated best practices...
8 years
Duration - Experience working with various software development methodologies (i.e. agile...
8 years
Duration - Exp working in a relevant data environment such as...
8 years
Duration - Knowledge of ETL processes and tools, with hands-on experience designing and implement...
8 years
Nice to Have Work Experience
Duration - Experience assisting in overall project planning and providing advice on system...
5 years
Duration - Experience making decisions and recommendations on highly technical or complex issues...
5 years
Duration - Experience translating data from multiple sources to a single solution, including...
5 years
Duration - Experience with cloud computing or big data platforms and infrastructure
5 years
Duration - Experience working in the public sector
2 years