Data Engineer

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

Job summary

Citi is seeking an Applications Development Technology Lead Analyst in Mississauga to architect, develop, and operate enterprise‑scale data pipelines. You will balance hands‑on coding with technical leadership across Spark, Databricks, and streaming architectures.

You will mentor a global team, optimize workloads, and drive end‑to‑end delivery while ensuring governance and security. A strong background in Scala, Python, and SQL is essential.

Qualifications

• Bachelor’s degree/University degree or equivalent experience.
• Master’s degree preferred.
• 6+ years of relevant Apps Development or systems analysis experience.
• Expert‑level development skills in Scala and Python.
• Advanced SQL development and query‑optimization skills.
• Strong knowledge of data warehousing concepts, Lakehouse modelling, and medallion architecture.
• Hands‑on experience with Apache Iceberg or Delta Lake is required.
• Extensive hands‑on experience with Apache Spark, Spark Structured Streaming, Databricks, Delta Live Tables, and Kafka.

Responsibilities

• Lead architecture, design, and development of high‑throughput batch and real‑time data pipelines.
• Provide SME guidance in Spark architecture, job optimization, SQL tuning, and Databricks performance.
• Mentor and develop a global team of data engineers; conduct code and architecture reviews.
• Collaborate with stakeholders to align data platforms with business goals and delivery milestones.
• Define standards for coding, testing, deployment, monitoring, and data quality.

Skills

Scala

Python

SQL

Apache Spark

Databricks

Kafka

Iceberg/Delta Lake

Lakehouse modelling

Medallion architecture

AWS/GCP

Education

Bachelor's degree/University degree or equivalent experience

Master's degree preferred

Job description

The Applications Development Technology Lead Analyst 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.

This is a hands‑on technology leadership role responsible for architecting, developing, optimizing, and operating large‑scale batch and real‑time data‑processing platforms at an enterprise scale. The position requires a candidate who can combine deep technical expertise in distributed data processing with effective team leadership, stakeholder management, and end‑to‑end delivery accountability. The successful candidate will serve as a subject‑matter expert in modern data engineering, guiding both technical strategy and execution.

The Data Engineering Lead will drive the design and implementation of high‑throughput data solutions capable of handling multi‑terabyte to petabyte‑scale datasets. This role balances advanced development and performance engineering with the leadership of a global team of data engineers, ensuring the delivery of robust, scalable, and maintainable data pipelines.

Responsibilities

• Partner with multiple management teams to ensure appropriate integration of functions to meet goals as well as identify and define necessary system enhancements to deploy new products and process improvements
• Resolve variety of high impact problems/projects through in-depth evaluation of complex business processes, system processes, and industry standards
• Provide expertise in area and advanced knowledge of applications programming and ensure application design adheres to the overall architecture blueprint
• Utilize advanced knowledge of system flow and develop standards for coding, testing, debugging, and implementation
• Develop comprehensive knowledge of how areas of business, such as architecture and infrastructure, integrate to accomplish business goals
• Provide in‑depth analysis with interpretive thinking to define issues and develop innovative solutions
• Serve as advisor or coach to mid‑level developers and analysts, allocating work as necessary
• Lead the architecture, design, and development of high‑throughput batch and real‑time streaming data pipelines using Apache Spark, Databricks, and Kafka.
• Serve as the senior subject‑matter expert for Spark architecture, job optimization, SQL query tuning, distributed processing, and Databricks performance engineering.
• Write, review, and approve clean, modular, and highly performant Scala and Python code, enforcing best practices across the team.
• Diagnose and resolve complex performance bottlenecks by analyzing Spark DAGs, execution plans, and executor metrics to address issues like data skew, shuffling, and memory management.
• Apply advanced optimization techniques for Spark and SQL, including broadcast joins, predicate pushdown, partition pruning, Z‑Ordering, and adaptive query execution.
• Manage and optimize Databricks workspaces, including Unity Catalog, Delta Live Tables, job clusters, security, governance, and monitoring.
• Implement and manage Apache Iceberg or Delta Lake as an enterprise table format, applying knowledge of features such as hidden partitioning, schema evolution, and compaction strategies.
• Develop and enforce enterprise data‑modelling standards and Lakehouse practices, including medallion architecture (Bronze, Silver, Gold layers).
• Lead, mentor, and develop a global team of data engineers, conducting code reviews, architecture reviews, and technical design sessions.
• Manage technical priorities, delivery milestones, dependencies, and risks, and collaborate effectively with business stakeholders, product owners, architects, and support teams.
• Define and enforce standards for coding, testing, deployment, monitoring, data quality, operational readiness, and production support.
• Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.

Recommended Qualifications

• 6+ years of relevant experience in Apps Development or systems analysis role
• Extensive experience system analysis and in programming of software applications
• Expert‑level development skills in Scala and Python.
• Advanced SQL development and query‑optimization skills, with a proven ability to tune slow‑running queries and Spark jobs.
• Strong knowledge of data warehousing concepts, Lakehouse modelling, and medallion architecture.
• Hands‑on experience with Apache Iceberg or Delta Lake is required.
• Extensive hands‑on experience with Apache Spark, Spark Structured Streaming, Databricks, Delta Live Tables, and Kafka.
• Deep knowledge of Apache Spark internals, including the Catalyst Optimizer, Tungsten execution engine, memory management, execution plans, partitioning, and shuffle behaviour.
• Expertise in reading Spark UI metrics to identify bottlenecks, resolve data skew, and optimise partitioning, caching, joins, and memory utilisation.
• Proven experience architecting and operating multi‑terabyte to petabyte‑scale data platforms in a public‑cloud environment (AWS or Google Cloud Platform).
• Subject Matter Expert (SME) in at least one area of Applications Development
• Experience in managing and implementing successful projects
• Experience leading and mentoring global or distributed data‑engineering teams.
• Demonstrated leadership and project management skills
• Exceptional communication, stakeholder‑management, and problem‑solving skills.
• Consistently demonstrates clear and concise written and verbal communication
• Ability to adjust priorities quickly as circumstances dictate

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.

\------------------------------------------------------

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.

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.