Senior Data Engineer - ETL & Data Warehouse Lead

Citi; Mississauga; On-site; CAD 163,000 - 231,000; Full time

Job summary

A multinational financial service corporation is looking for a Lead Data Engineer to establish new application systems and lead programming activities. In this role, you will design, develop, and maintain ETL processes, write complex SQL and PL/SQL scripts, and optimize data pipelines using Python. The ideal candidate should possess 6-10 years in relevant fields, a degree in a related discipline, and the ability to work both independently and collaboratively in a team setting. A Master's degree is preferred.

Qualifications

• 6-10 years of relevant experience in Apps Development or systems analysis role.
• Extensive experience in system analysis and programming of software applications.
• Experience in managing and implementing successful projects.

Responsibilities

• Design, develop, and maintain ETL processes to extract, transform, and load data.
• Write complex SQL queries and PL/SQL scripts for data manipulation.
• Develop and maintain data pipelines using Python.
• Optimize ETL processes for performance and scalability.
• Collaborate with data analysts to understand data requirements.
• Implement data quality checks to ensure data accuracy.
• Troubleshoot and resolve data-related issues.
• Create and maintain technical documentation for ETL processes.

Skills

Python

ETL

PL/SQL

SQL

Data Warehousing

Data Modeling

Database Management

Good communication and problem-solving skills

Teamwork

Education

Bachelor’s degree/University degree or equivalent experience

Master’s degree preferred

Job description

A multinational financial service corporation is looking for a Lead Data Engineer to establish new application systems and lead programming activities. In this role, you will design, develop, and maintain ETL processes, write complex SQL and PL/SQL scripts, and optimize data pipelines using Python. The ideal candidate should possess 6-10 years in relevant fields, a degree in a related discipline, and the ability to work both independently and collaboratively in a team setting. A Master's degree is preferred.