About the Role
Our public sector client is seeking a Senior Application Developer, for a 12-month, full time contract, with the possibility of up to a 12-month extension. The Application Developer will be required on a full-time basis (7.25 hour work day, 36.25 hours/week), 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 (internal and/or external).
Responsibilities will include:
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.
Working Hours
Standard Hours of work are 08:15 – 16:30 Alberta time, Monday through Friday excluding holidays observed by the client.
Work must be done from within Canada, due to network and data security issues.
The Application Developer shall be responsible for providing all 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.
It is anticipated the role will be primarily remote, however in the event of an onsite meeting, the client/Handis Consulting Inc. does not pay for travel to attend on-site meetings, nor any expenses.
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; potentially up to 3-4 times per month.
Requirements
Education
The proposed resource must meet or exceed one of the following:
University graduation in computer science, IT or a related discipline and 4-yr related experience; OR
2-yr diploma in computer science, IT or a related discipline and 6-yr related experience; OR
1-yr certificate in computer science, IT or a related discipline and 7-yr related experience; OR
a currently active professional certification or accreditation and 8-yr relevant experience
Work Experience
8 years experience in designing, building, testing, deploying, and supporting applications in an enterprise IT environment equivalent in size and complexity to an enterprise client
3 years experience using Microsoft SQL
3 years experience with Python development
8 years experience with software development processes, and all associated best practices, methods, standards, tools, and policies
8 years experience working with various software development methodologies (i.e. agile, waterfall, scrum, Kanban, etc.)
8 years experience working in a data warehouse / datalake / business intelligence or relevant data environment in a development role
8 years knowledge of ETL processes and tools, with hands-on experience designing and implementing data pipelines for transforming and loading data from multiple sources into data warehouses
5 years experience assisting in overall project planning and providing advice on system development opportunities
5 years experience making decisions and recommendations on highly technical or complex issues without formal guidelines or precedents and exercises resourcefulness and ingenuity
5 years experience translating data from multiple sources to a single solution, including planning for historical, current, and future data needs
5 years experience with cloud computing or big data platforms and infrastructure
2 years experience working in the public sector
Standard Background Check AND Enhanced Security Clearance
The contractor shall, prior to commencement of the Services, provide the client, on its request and at no cost to the client, with criminal record checks.
An Enhanced Security Clearance will be required for this position, which will be coordinated by the client only.
Resource References
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 by the client.
SUBMISSION MUST INCLUDE:
• RESUME with requirements detailed
• ALL REQUIRED EXPERIENCE MUST BE DESCRIBED IN RESUME UNDER THE JOB/PROJECT WHERE EXPERIENCE WAS ATTAINED.
• RESOURCE REFERENCES
If this opportunity is of interest to you, please provide your resume detailing all your relevant experience and certifications, as well as 3 recent references. Candidate must have or immediately obtain Incorporated Business status.
Handis Consulting prides itself in being an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, sexual orientation or any other characteristic protected by law.
About the Company