Starburst Senior Data Engineer- Vice President

Citi; New York (NY); On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Medical, dental, and vision coverage

401(k)

Paid time off packages

Job summary

Citi is looking for a highly experienced Starburst Expert to join their data team in New York. This role focuses on designing and optimizing data solutions using Starburst for high-performance analytics and data access.

The ideal candidate will have more than 10 years of experience in data-centric projects and a deep knowledge of data engineering, SQL, and cloud platforms. Citi provides competitive benefits and opportunities for growth within the company.

Qualifications

• 10+ years in data engineering, data warehousing, or big data analytics.
• 3+ years of direct experience with Starburst Enterprise in production.
• Deep SQL expertise, advanced query writing, and optimization skills.

Responsibilities

• Lead design and architecture of Starburst-based data solutions.
• Manage data lakes utilizing Apache Iceberg with Starburst.
• Implement and optimize SQL queries and data pipelines using Starburst.

Skills

Data engineering

SQL

Apache Iceberg

Data connectors

Cloud platforms

Scripting languages

Data modeling

Problem-solving

Education

Bachelor's or Master's degree in Computer Science or related field

Tools

Starburst

Docker

Kubernetes

Job description

Job Overview

We are seeking a highly experienced and skilled Starburst Expert to join our dynamic data team. The ideal candidate will have over 10 years of experience in designing, implementing, and optimizing data solutions within large-scale, data-centric projects. This role will be pivotal in leveraging Starburst (Trino/PrestoSQL) to enable high-performance analytics, federated querying, and efficient data access across diverse data sources. The successful candidate will be a thought leader, capable of driving technical strategy, mentoring junior team members, and ensuring the robust and scalable operation of our Starburst environment.

Responsibilities

• Design & Architecture: Lead the design and architecture of Starburst-based data solutions, ensuring scalability, performance, and reliability for enterprise-level data platforms.
• Apache Iceberg Management: Design, implement, and manage data lakes utilizing Apache Iceberg tables with Starburst, optimizing for ACID transactions, schema evolution, time travel, and high-performance queries.
• Implementation & Optimization: Develop, implement, and optimize complex SQL queries and data pipelines using Starburst to extract, transform, and load (ETL/ELT) data from various sources.
• Performance Tuning: Proactively monitor, troubleshoot, and fine‑tune Starburst clusters and queries to ensure optimal performance, resource utilization, and cost efficiency.
• Data Federation: Implement and manage data federation strategies using Starburst connectors to seamlessly integrate and query data across disparate systems (Data Lakes, RDBMS, NoSQL databases, Cloud Storage).
• Security & Governance: Collaborate with security and governance teams to implement robust data access controls, encryption, and compliance measures within the Starburst ecosystem.
• Mentorship & Leadership: Provide technical leadership and mentorship to data engineers and analysts, fostering best practices in Starburst usage, data modeling, and query optimization.
• Strategic Planning: Contribute to the long-term data strategy and roadmap, evaluating new features, technologies, and methodologies related to Starburst and the broader data ecosystem.
• Collaboration: Work closely with data scientists, business analysts, application developers, and other stakeholders to understand data requirements and deliver effective solutions.
• Documentation: Create and maintain comprehensive technical documentation for Starburst configurations, data models, query patterns, and operational procedures.

Qualifications

• 10+ years of hands‑on experience in data engineering, data warehousing, or big data analytics projects.
• Minimum of 3 years of direct experience with Starburst Enterprise (Trino/PrestoSQL) in a production environment, including configuration and administrative knowledge.
• Deep expertise in SQL, with advanced query writing and optimization skills specific to Starburst/Trino.
• Proven experience with Apache Iceberg, including table creation, schema evolution, time travel, and performance optimization when used with Starburst/Trino.
• Strong understanding of distributed systems and parallel processing architectures.
• Proficiency with various data connectors and their configuration within Starburst (S3, HDFS, Hive, Kafka, MongoDB).
• Experience with cloud platforms (AWS, Azure, GCP) and their data services (S3, ADLS, GCS, EMR, Athena, Databricks).
• Familiarity with data governance, metadata management, and data cataloging tools.
• Experience with scripting languages (Python) for data manipulation and automation.
• Knowledge of containerization technologies (Docker, Kubernetes) is a plus.
• Solid understanding of data warehousing concepts, data modeling (dimensional, 3NF), and ETL/ELT processes.
• Experience with large-scale data lakes and various file formats (Parquet, ORC, Avro).
• Excellent analytical and problem‑solving skills with a keen eye for detail.
• Strong verbal and written communication skills, with the ability to articulate complex technical concepts to both technical and non‑technical audiences.

Preferred Qualifications

• Certification in Starburst, Trino, or relevant cloud data platforms.
• Experience with data visualization tools (Tableau, Power BI, Looker) for connecting to Starburst.
• Familiarity with CI/CD practices for data pipelines and infrastructure as code.
• Experience in the financial services industry or other highly regulated environments.

Education

• Bachelor's or Master's degree in Computer Science, Engineering, Information Systems, or a related technical field.

Benefits

Citi offers competitive employee benefits, including medical, dental, and vision coverage; 401(k); life, accident, and disability insurance; wellness programs; paid time off packages (vacation, sick leave, and paid holidays). Additional incentive and retention awards may be offered for eligible employees.

Equal Opportunity Employer Statement

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, please visit Accessibility at Citi. View Citi’s EEO Policy Statement and Know Your Rights poster.