Job Title

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