Data Warehouse Engineer

Position Title: Datawarehouse Engineer Work Location: Edmonton You can work remotely at times, though you will need to be available to work on-site when required as often as needed by the business. Scope: 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 the 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 (GOA-internal and/or external). Duties: 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.