Lead Data Engineer

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

The Lead Data Engineer is a senior level position responsible for establishing and implementing new or revised application systems and programs in coordination with the Technology team. The overall objective of this role is to lead applications systems analysis and programming activities.

Responsibilities

• 6-10 years of relevant experience in Apps Development or systems analysis role
• Extensive experience system analysis and in programming of software applications
• Experience in managing and implementing successful projects
• Subject Matter Expert (SME) in at least one area of Applications Development

• Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into our data warehouse.
• Write complex SQL queries and PL/SQL scripts to perform data manipulation, validation, and transformation.
• Develop and maintain data pipelines using Python and related libraries (e.g. Polar, Pandas).
• Optimize ETL processes and data pipelines for performance and scalability.
• Collaborate with data analysts and other stakeholders to understand data requirements and develop solutions.
• Implement data quality checks and monitoring to ensure data accuracy and consistency.
• Troubleshoot and resolve data-related issues.
• Create and maintain technical documentation for ETL processes, data pipelines, and database solutions.
• Stay up to date with the latest trends and technologies in data management and analytics.

Required Skills

• Python
• ETL
• PL/SQL
• SQL
• Data Warehousing
• Data Modeling
• Database Management
• Good communication and problem-solving skills
• Teamwork: Ability to work independently as well as in a team

Preferred Skills

• DAMA Certification a plus

Education

• Bachelor’s degree/University degree or equivalent experience
• Master’s degree preferred

This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.

Primary Location Full Time Salary Range: $120,800.00 - $170,800.00

Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law. If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity, accessibility at Citi. View Citi’s EEO Policy Statement and the Know Your Rights poster.