Citi Logo

Citi

Senior Data Engineer – Python

Posted 4 Days Ago
Be an Early Applicant
In-Office
Mississauga, ON, CAN
Senior level
In-Office
Mississauga, ON, CAN
Senior level
Build and maintain scalable Python data pipelines, reusable engineering frameworks, SQL solutions, ETL/ELT workflows, and relational and NoSQL data models. Develop PySpark distributed-processing pipelines, data quality controls, and CI/CD automation while supporting governance, security, troubleshooting, and production operations. Collaborate with data scientists, analysts, engineers, and business stakeholders to deliver enterprise-scale data platforms and analytics solutions.
The summary above was generated by AI

We are seeking a skilled and experienced Senior Data Engineer with strong Python expertise to join our Engineering team. The ideal candidate is passionate about building robust, scalable data pipelines and platforms that power analytics, business intelligence, and data-driven decision-making across the enterprise. This role requires deep hands-on experience in Python-based data engineering, SQL development, data modeling, and ETL/ELT design, along with familiarity with both relational and NoSQL databases. Experience with Big Data technologies such as PySpark, and exposure to platforms like Databricks or Starburst, will be considered a strong advantage. The successful candidate will thrive in a collaborative, fast-paced environment and take ownership of end-to-end data solutions.

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 database platforms.

  • Design and implement ETL/ELT solutions including staging frameworks, incremental processing, data reconciliation, and error handling.

  • Develop and maintain logical and physical data models to support both operational and analytical use cases.

  • Work with NoSQL databases (e.g., MongoDB) to design data structures and access patterns suited to 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 to ensure accuracy and reliability across data products.

  • Collaborate with data scientists, analysts, software engineers, and business stakeholders to understand requirements and 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.

Qualifications

  • Strong proficiency in Python for data engineering, including data transformation, orchestration, workflow automation, and utility development.

  • Expert-level SQL skills across relational databases (PostgreSQL, Oracle, SQL Server, or MySQL).

  • Solid experience in data modeling — relational and dimensional modeling (Star/Snowflake schemas).

  • Hands-on experience designing and building ETL/ELT pipelines using Python-based frameworks .

  • Working experience with NoSQL databases, particularly MongoDB.

  • Experience with PySpark and distributed data processing frameworks for large-scale data workloads is a plus.

  • Familiarity with Databricks and/or Starburst is a plus.

  • Hands-on experience with AI Development Tools such as Claude Code, Devin AI, Cursor, Copilot etc.

  • Knowledge of data formats including Parquet, Avro, and JSON, and storage platforms such as HDFS or cloud object stores.

  • Proficiency with version control (Git) and CI/CD practices for data engineering workflows.

  • Familiarity with data orchestration tools such as Apache Airflow or equivalent schedulers.

  • Basic working knowledge of Java is a plus.

  • Strong analytical, problem-solving, and communication skills with the ability to work across technical and non-technical teams.

Experience

  • 6+ years of total experience in software or data engineering.

  • Hands-on experience specifically 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.

  • Demonstrated experience working with both relational (PostgreSQL, Oracle, SQL Server) and NoSQL (MongoDB) databases in real-world projects.

  • Experience working in regulated or highly process-oriented environments, preferably within Financial Services.

Education

  • Bachelor’s or Master’s degree in Computer Science, Software Engineering, or an equivalent technical field.

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

------------------------------------------------------

Job Family Group: Technology

------------------------------------------------------

Job Family:Applications Development

------------------------------------------------------

Time Type:Full time

------------------------------------------------------

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

------------------------------------------------------

Most Relevant Skills Please see the requirements listed above.

------------------------------------------------------

Other Relevant Skills For complementary skills, please see above and/or contact the recruiter.

------------------------------------------------------

Automated Processing and AI

We use automated processing, including artificial intelligence, for our legitimate business interests (or our reasonable and appropriate business purposes) to identify and align the candidate's skills and abilities with a specific job opening. Additionally, if you so choose, or consent, we can match your skills and abilities to other suitable roles at Citi.

Importantly, all our hiring processes and decisions, including determining your suitability for a role, are conducted, checked, and decided by individuals. Our automated processing and AI do not involve relying on automatic or autonomous decision-making. Please refer to any Jurisdictional Considerations, with specific provisions for your country (where relevant) for further details.

------------------------------------------------------

This job opening is for an existing job vacancy.

------------------------------------------------------

Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their 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 review Accessibility at Citi.
View Citi’s EEO Policy Statement and the Know Your Rights poster.

Similar Jobs

14 Days Ago
Remote or Hybrid
Canada
Senior level
Senior level
eCommerce • Information Technology • Machine Learning • Marketing Tech • Database • Analytics • Big Data Analytics
Design, build, and maintain scalable data pipelines and tenant-aware APIs to ingest and transform data from ad platforms, order systems, and real-time events. Ensure reliability, observability, and maintainability across event-driven and batch architectures, implement authentication flows, optimize data workflows in a cloud-native environment, and collaborate with product, infrastructure, and data teams to onboard new sources.
Top Skills: AirflowAPIsBigQueryDockerETLGraphQLKubernetesPythonRestSQLWebhooks
Yesterday
Hybrid
Toronto, ON, CAN
Entry level
Entry level
eCommerce • Fashion • Retail • Sales • Wearables • Design
Provides personalized styling advice, product recommendations, and customer service in a Kate Spade retail store. Responsibilities include driving sales through customer engagement and storytelling, completing POS transactions, maintaining stockroom organization, supporting virtual selling, and collaborating with the team. The role requires flexible scheduling, retail experience, strong communication skills, and the ability to perform physical tasks such as lifting, bending, and maneuvering through sales and stockroom areas.
Top Skills: Pos
2 Days Ago
Hybrid
Toronto, ON, CAN
Senior level
Senior level
Artificial Intelligence • Big Data • Enterprise Web • Fintech • Software • Financial Services
Lead analyst responsible for managing a portfolio of Canadian banks, non-bank financial institutions, and credit unions. Perform ongoing financial and credit analysis, prepare rating committee presentations, reports and press releases, attend issuer meetings, participate in rating committees, and maintain client relationships. Produce surveillance, research, and written analysis while collaborating with the ratings team.
Top Skills: Bloomberg

What you need to know about the Toronto Tech Scene

Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account