Data Engineer

BQ INTERNATIONAL LTD.; Regina; On-site; CAD 80,000 - 110,000; Full time

Job summary

A leading company is seeking a skilled Data Engineer to design and implement data management solutions. The ideal candidate will have extensive experience in ETL, data architecture, and SQL, along with the ability to work closely with analytics teams and provide insights into data integration challenges. This role offers a supportive environment with opportunities for growth and learning, based on the evolving data landscape.

Qualifications

• 5+ years’ experience in ETL, data design, data architecture, data management and data modelling.
• Expert proficiency with SQL Server and SSIS required.
• Knowledge of data privacy regulations such as PIPEDA.

Responsibilities

• Create and maintain data pipelines and ETL processes.
• Work closely with the Enterprise Analytics team to create and maintain ELT processes.
• Consulting DT&S and Business leaders on data management practices.

Skills

ETL

data design

data architecture

data management

data modelling

SQL

Python

data privacy

Education

Degree or Diploma in Computer Science / Engineering, Data Sciences

Tools

SQL Server

SSIS

Job description

In order to be considered – the Data Engineer resource MUST have a minimum of 5 years of recent (in last 7 years) in modern data management principles such as, but not limited to ETL, practical data design, architecture, management, modelling, quality, and analytics experience. The successful candidate will demonstrate a broad and solid understanding of these principles.

Successful Data Engineer candidate will have:

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

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 in line with company policies and any external regulations that may apply;

Provide insight into the changing database integration, storage and utilization requirements for the company and offer suggestions for solutions;

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 the Data Management Body of Knowledge (DMBoK);

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 DT&S and Business leaders on data and information management practices and governance;

Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc;

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 support their data infrastructure needs.

Create data tools for analytics and data scientist team members that assist them in building and optimizing our business.

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, such as master data management (MDM), metadata management, analytics, content management, data integration, and related data management or data infrastructure;

Provide insight into the changing database integration, storage and utilization requirements for the company and offer suggestions for solutions;

Monitor and understand Information Management trends and emerging technologies.

The key skills and knowledge areas required for the Senior Resource are outlined in attached Appendix C – Supplementary Specifications. North American job experience is considered an asset for this proposal. Proponents are encouraged to provide specific and qualitative verbiage of other areas where their expertise can add value to our teams, and make our projects as successful as possible. We are looking for a well-rounded developer to fill this role.

The preference for start date is as soon as possible. The initial term for this role(s) will conclude March 31, 2023; after which Client will evaluate its’ ongoing requirements and potentially extend the term for this resource in accordance with the terms and conditions of the bidder’s Technology Master Service Agreement (TMSA).

The resource(s) will be required to work and be located on site at Client Head Office in Regina, Monday to Friday 8 am to 5 pm