Senior Application Developer

Summary

Join the Government of Alberta as a Senior Application Developer in Edmonton, AB, working remotely with occasional on-site meetings. This role focuses on a data integration project for the Justice Information Management System (JIMS 3.0), involving data warehouse design, ETL processes, and data modeling. You will be responsible for developing and implementing data warehouse solutions, ensuring data quality and security, and collaborating with various stakeholders. The position requires extensive experience in data warehousing, ETL tools, SQL/Python, and software development best practices. The contract is estimated to last from April 3, 2025, to March 31, 2026, with a possible 12-month extension.

Requirements

• Provide Updated Resume in word format
• Provide Skills Matrix
• Provide References
• Provide Expected hourly rate
• Provide Visa Status
• Provide LinkedIn ID
• 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
• Experience with software development best practices including code reviews, unit testing and documentation

Responsibilities

• Perform technical strategic functions, ensuring the architecture supports Justice data analytics and reporting needs
• Support application of the Data Fabric architecture, data quality, data standards, and best practices to development as needed
• Understand 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)
• Deliver applications programming and analysis tasks as part of a system development process as well as provide application support, maintenance and enhancements
• 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
• 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
• 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