Senior Python Data Engineer - Scalable Data Pipelines

Citi; Mississauga; On-site; CAD 167,000 - 236,000; Full time

Job summary

Citi is seeking a Senior Data Engineer to build robust Python-based data pipelines powering analytics and BI across the enterprise. You will design ETL/ELT processes, model data, and work with both SQL and NoSQL databases such as MongoDB. Proficiency in PySpark and familiarity with Databricks or Starburst are highly valued.

The role emphasizes end-to-end ownership of data solutions in a collaborative, fast-paced environment with strong cross-functional collaboration.

Qualifications

• 6+ years of total experience in software or data engineering.
• Hands-on experience in Python-based data engineering, SQL development, ETL design, and data modeling.
• Proven experience building and maintaining production-grade data pipelines and platforms at enterprise scale.

Responsibilities

• Design, develop, and maintain scalable Python-based data pipelines for ingestion, transformation, and distribution of data across enterprise platforms.
• Build reusable Python libraries, frameworks, and automation utilities to support data engineering workflows.
• Develop and optimize complex SQL queries, stored procedures, and database objects across multiple relational databases.
• Design and implement ETL/ELT solutions including staging frameworks, incremental processing, data reconciliation, and error handling.
• Develop and maintain logical and physical data models for operational and analytical use cases.
• Work with NoSQL databases (e.g., MongoDB) to design data structures and access patterns for non-relational workloads.
• Build and maintain data pipelines using PySpark for large-scale distributed data processing where applicable.
• Implement data quality, validation, and completeness controls across data products.
• Collaborate with data scientists, analysts, software engineers, and business stakeholders to deliver high-quality data solutions.
• Contribute to CI/CD pipelines for automated testing, deployment, and version control of data workflows.
• Participate in code reviews, troubleshooting, debugging, and production support of data systems.
• Support data governance, security standards, and compliance requirements across all data assets.

Skills

Python

SQL

Data modeling

ETL/ELT

NoSQL (MongoDB)

PySpark

Databricks

Starburst

Git

Apache Airflow

Java basics

Education

Bachelor’s or Master’s degree in Computer Science/Software Engineering

Tools

Databricks

Starburst

Git

CI/CD

Apache Airflow

Job description

Citi is seeking a Senior Data Engineer to build robust Python-based data pipelines powering analytics and BI across the enterprise. You will design ETL/ELT processes, model data, and work with both SQL and NoSQL databases such as MongoDB. Proficiency in PySpark and familiarity with Databricks or Starburst are highly valued.

The role emphasizes end-to-end ownership of data solutions in a collaborative, fast-paced environment with strong cross-functional collaboration.