Job Description

Job Title:- Application Developer – Intermediate

Location: - 7000 - 113 ST, Edmonton, Alberta (Remote)

Duration- 12+ Months Contract (Possible Extension)

Job ID- GOAPRDJP00000645

Project Name:

The goal of the project is to evolve availability, governance, and reporting of court data by implementing a more efficient, user-friendly, faster, and cost-effective reporting architecture.

Project Benefits:

• Integrated and dynamic architecture
• Interactive reporting
• Reduced reporting lag
• Preservation of historical data
• Improved data governance

Role Overview

This role will assist in the planning, design, development, and testing of the Extract, Transform and Load (ETL) phases for the data warehousing activities within the JIMS 3.0 project. Additionally, the role is expected to help make sense of the large amount of legacy data through analysis and insight to ensure new data model correctly reflects business requirements.

Main Responsibilities:

• Reviewing existing data marts
• Performing detailed data profiling
• Analyzing and creating mapping specifications
• Developing and testing ETL processes
• Developing test queries for several Dimensions and Facts
• Testing of Dimensions and Facts for QA
• Developing objects such as views, tables, stored procedures
• Staging the required data
• Addressing defects in new dimension and fact tables
• Communicating results with data architects and stakeholders
• Providing feedback at project close out

Duties

• Deliver applications programming and analysis tasks as part of system development
• Provide application support, maintenance, and enhancements
• Liaise with business units and program areas
• Write quality code and pass code reviews
• Apply configuration on dev environments
• Support production implementation
• Analyze impacts of functional design
• Deliver technical design and DB structure
• Maintain technical documentation
• Conduct focused testing and ensure adequate unit testing
• Handle and fix production defects
• Track/report time and status
• Contribute to Application Lifecycle Planning
• Identify and coordinate release schedules
• Identify service requests and priorities
• Ensure release schedules stay on track

Must Have

College or Bachelor degree in Computer Science or related field

Eligibility for Enhanced Security Clearance

Experience

• Microsoft SQL Server
• Creating user training materials & technical docs
• Working as App Developer in enterprise IT
• Data warehouse/BI development/support
• ETL tools/pipelines

Nice to Have

• Agile methodology
• Smoke/unit/system/integration testing
• UAT in large complex environments
• Public sector experience

Job Tags

Similar Jobs