Senior Data Analytics Developer

Citi; Mississauga; On-site; CAD 94,000 - 142,000; Full time

Job summary

A multinational banking corporation in Mississauga seeks an experienced Data Analytics Developer to design and maintain a cutting-edge data analytics platform. Responsibilities include building data pipelines, optimizing analytics queries, and leveraging tools such as Apache Druid and Starburst (Trino). The ideal candidate has 5-8 years of experience in data engineering, strong SQL skills, and familiarity with cloud platforms. This role offers a competitive salary and opportunities for professional growth.

Qualifications

• 5-8 years of relevant experience.
• Proven hands-on experience in a data engineering or analytics developer role.
• Strong expertise with SQL and experience with various data analytical tools.
• Deep experience with Apache Druid, including cluster management and query optimization.
• Hands-on experience with Starburst (Trino) and performance tuning.
• Solid understanding of Apache Impala for fast SQL queries.
• Strong expertise with Apache Iceberg for data lake architectures.
• Experience with OLAP cube development and best practices.
• Proficiency in Java, Python, or PySpark for data pipeline development is desirable.
• Experience with cloud platforms such as AWS, GCP, or Azure is a plus.

Responsibilities

• Design, develop, and maintain data ingestion and processing pipelines.
• Utilize Apache Druid to build high-performance analytics solutions.
• Leverage Starburst (Trino) for query federation across data sources.
• Develop and optimize analytical queries using Impala.
• Implement datasets using Apache Iceberg for robust data lake operations.
• Apply OLAP techniques to design multidimensional data models.
• Collaborate with data architects and business intelligence teams.
• Troubleshoot and resolve performance and data quality issues.
• Maintain comprehensive documentation for all data processes.

Skills

SQL

Apache Druid

Starburst (Trino)

Apache Impala

Apache Iceberg

OLAP cube development

Java

Python

PySpark

Education

Bachelor's degree in Computer Science, Data Engineering, or related field

Job description

Overview

We are seeking a talented and experienced Data Analytics Developer to join our team. You will play a key role in designing, developing, and maintaining our next-generation data analytics platform. This involves building scalable and efficient data pipelines, optimizing query performance, and implementing robust solutions to enable real-time and historical data analysis for business stakeholders. Your expertise will be crucial in leveraging modern data lake architecture principles with tools like OLAP, Apache Druid, Starburst (Trino), Impala, and Apache Iceberg. You will work closely with data scientists, data engineers, and business analysts to translate complex data requirements into technical solutions that drive business intelligence and operational efficiency.

Responsibilities

• Design, develop, and maintain data ingestion and processing pipelines to move large volumes of data from various sources into the data platform.
• Utilize Apache Druid to build high-performance, real-time analytics solutions, focusing on data ingestion, indexing, and query optimization.
• Leverage Starburst (Trino) to implement a data mesh architecture and enable query federation across different data sources, including data warehouses, data lakes, and other systems.
• Develop and optimize analytical queries and reporting views using SQL within Impala for high-performance interactive and batch queries on large datasets.
• Implement and manage datasets using Apache Iceberg, ensuring features like schema evolution, partitioning, and time-travel are leveraged for robust and reliable data lake operations.
• Apply OLAP (Online Analytical Processing) techniques and tooling to design and develop multidimensional data models (cubes) for fast and efficient analysis.
• Collaborate with data architects and business intelligence teams to create and maintain optimal data models and data warehouse structures.
• Troubleshoot and resolve performance issues, data processing bottlenecks, and data quality problems within the data analytics ecosystem.
• Maintain comprehensive documentation for all data processes, architectures, and data flows.

Qualifications

• 5-8 years of relevant experience
• Proven hands-on experience in a data engineering or analytics developer role.
• Strong expertise with SQL and experience with various data analytical tools.
• Deep experience with Apache Druid, including cluster management, data ingestion, and query optimization.
• Hands-on experience with Starburst (Trino), including query federation and performance tuning across data sources.
• Solid understanding and experience with Apache Impala for fast, interactive SQL queries on Hadoop or cloud data storage.
• Strong expertise with Apache Iceberg, including implementation for data lake architectures, schema evolution, and partitioning.
• Experience with OLAP cube development, including knowledge of multidimensional expressions (MDX) and best practices.
• Proficiency in one or more of Java, Python or PySpark for data processing and pipeline development is desirable.
• Experience with cloud platforms such as AWS, GCP, or Azure is a plus.
• Excellent problem-solving, communication, and collaboration skills.

Education

• Bachelor’s degree/University degree or equivalent experience
• Bachelor's degree in Computer Science, Data Engineering, or a related 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: $94,300.00 - $141,500.00

Most Relevant Skills: Please see the requirements listed above.

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

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.