Data Engineer

Back to All Jobs
[social_share]

Our client requires a data engineer 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. Resource will have strong 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. Responsibilities include creating logical/physical data models, development This role may also support application of the Data Fabric architecture, data quality, data standards and best practices to development.

Resource will work remotely but must be available to be on-site when requested for meetings. Frequency of meeting COULD BE up to 3-4 times per month. Standard Hours of work are 08:15 – 16:30 Alberta time. Work must be done from within Canada, due to network and data security issues. Resource is responsible to pay for travel to on-site meetings.

Edmonton, Alberta (Remote)

Responsibilities

Duties Include: 

Liaise with business areas and 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 Mandatory Requirements Must meet or exceed one of the following: University graduation in computer science or a related discipline and 4-yr relevant experience; OR 2-yr diploma in computer science or a related discipline and 6-yr relevant experience; OR 1-yr certificate in computer science or a related discipline and 7-yr relevant experience; OR a currently active professional certification or accreditation and 8-yr relevant experience 8 years’ experience in designing, building, testing, deploying, and supporting applications within a large and complex enterprise public sector environment. 3 years’ experience using Microsoft SQL. 3 years’ experience with Python development 8 years’ experience with software development processes, and all associated best practices, methods, standards, tools, and policies. 8 years’ experience working with various software development methodologies (i.e. agile, waterfall, scrum, Kanban, etc.). 8 years’ experience working in a data warehouse / datalake / business intelligence or relevant data environment in a development role 8 years’ knowledge of ETL processes and tools, with hands-on experience designing and implementing data pipelines for transforming and loading data from multiple sources into data warehouses. Desirable Requirements 5 years’ experience assisting in overall project planning and providing advice on system development opportunities. 5 years’ experience making decisions and recommendations on highly technical or complex issues without formal guidelines or precedents and exercises resourcefulness and ingenuity 5 years’ experience translating data from multiple sources to a single solution, including planning for historical, current, and future data needs 5 years’ experience with cloud computing or big data platforms and infrastructure 2 years’ experience working in the public sector

Job Posting ID: 56059

Location: Edmonton, Alberta (Remote)

Estimated Starting Date: Mar 4, 2025

Estimated End Date: till Mar 31, 2026 + 1 pos. 12-months extension

Posting Closing Date: February 10, 2025

Back to All Jobs

Apply for this Job Posting

Fill in the form below to submit your application for this position.

Name* First Last Email* Phone*Cover Letter or IntroductionUpload Resume*Accepted file types: doc, pdf, docx, Max. file size: 512 MB.CommentsThis field is for validation purposes and should be left unchanged.