Data Engineer — Scalable DBs, ETL & Big Data

AIT Global, Inc.; Montreal; On-site; CAD 80,000 - 100,000; Full time

Job summary

A technology company is seeking a Data Engineer in Montreal to translate business requirements into queries, design databases, and develop ETL processes. The ideal candidate should have strong skills in relational databases, Python, and experience with tools like DB2, SQL Server, and Kafka. This role offers a chance to work in a skilled global team focused on database design and big data solutions.

Qualifications

• Strong relational database skills especially with DB2/Sybase/SQL Server or/and Postgres/Greenplum.
• Experience with Power Designer or some similar modeling tool.
• Strong knowledge base of relational database performance and tuning.

Responsibilities

• Translate business requirement into queries and produce reports.
• Design and build scalable and performant databases.
• Build efficient automation scripts.
• Develop databases and ETL, including stored procedures and performance tuning.

Skills

Relational database skills

Python

ETL tools

Effective communication skills

Experience with Agile development process

Tools

DB2

SQL Server

Postgres

Kafka

MongoDB

Spark

Snowflake

Databricks

Power Designer

Unix

Job description

A technology company is seeking a Data Engineer in Montreal to translate business requirements into queries, design databases, and develop ETL processes. The ideal candidate should have strong skills in relational databases, Python, and experience with tools like DB2, SQL Server, and Kafka. This role offers a chance to work in a skilled global team focused on database design and big data solutions.