Data Engineer

Successful Data Engineer candidate will have:

• Degree or Diploma in Computer Science / Engineering, Data Sciences or other quantitative

• 5+ years’ experience in ETL, data design, data architecture, data management and data modelling;

• Expert proficiency with SQL Server and SSIS is required;

• Create and maintain data pipelines and ETL processes;

• Experience with Python, big data tools and cloud services considered an asset;

• Be responsible for monitoring and addressing database issues and problems and ensuring they are

• Provide insight into the changing database integration, storage and utilization requirements for the

• Oversee the integration of data from legacy and on-premises systems to new solutions;

• Working knowledge of data management as laid out by Data Management Association (DAMA) and

• Ability to communicate technical information effectively in an easy to understand language;

• Educate staff members through training and individual support;

• Knowledge and exposure to data privacy and confidentiality regulations such as Personal

• Information Protection and Electronic Documents Act (PIPEDA);

Typical activities in the Data Engineer role include:

• Work closely with the Enterprise Analytics team to create and maintain ELT processes;

• Assemble large, complex datasets that meet functional / non-functional business requirements;

• Consulting Business leaders on data and information management practices and

• Identify, design, and implement internal process improvements: automating manual processes,

• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and other technologies;

• Work with stakeholders including the Executive, to assist with data-related technical issues and

• Create data tools for analytics and data scientist team members that assist them in building and

• Work with data and analytics experts to strive for greater functionality in our data systems.

• Championing efforts to improve business performance through enterprise information capabilities,

• Provide insight into the changing database integration, storage and utilization requirements for the

• Monitor and understand Information Management trends and emerging technologies.