Job Title: Automation Engineer/ Data Integration

Location: Edmonton AB, T6H 5T6" Resource will work Remote.

3-4 Days onsite in a year

Working Hours: Standard Hours of work are 08:15 - 16:30 Alberta time, Monday through Friday excluding holidays observed by the province.

Hybrid: 3 Day onsite per week.

Job Summary: 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.

Technical Requirements:

• 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.
• Review 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, testing 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.

Responsibilities

• A Quality Assurance Automation Developer designs and implements test automation to ensure service quality with a focus on iterative, continuous development, where requirements and solutions evolve through collaboration between Agile Teams and users.
• Works collaboratively in Agile Teams to improve services.
• Participates in project activities, including field work and user research.
• Works with Agile Teams and stakeholders to understand problems and leads the quality delivery piece of the solution.
• Participates in creating and prioritizing a backlog of work, estimates effort, and commits to scope of work for predictable delivery of features.
• Identify opportunities for process improvement within the data integration and quality assurance lifecycle, recommending and implementing solutions to enhance efficiency and effectiveness.
• Identifies quality related tasks for a backlog of work such as test case creation, system testing, and performance testing.
• Works with product owners to design test plans and strategies with a focus on automation to facilitate a continuous delivery approach.
• Develops automated tests and frameworks to support integration testing, system testing, acceptance testing, and performance testing.
• Works closely with Full Stack Developers to establish a high standard of quality across the Agile Team through quality metrics and best practices.
• Seeks out defects, investigates root causes, and supports informed categorization and triage of defects.
• Proactively identify opportunities for process improvement within the data integration and quality assurance lifecycle, recommending and implementing solutions to enhance efficiency and effectiveness.