About the Role:

We're looking for a seasoned Lead Database Engineer to spearhead the design, development, and optimization of our large-scale data solutions. This role demands a deep understanding of Oracle SQL, Spark ETL, Python, and proven leadership capabilities. You will be instrumental in building and maintaining robust ETL pipelines, ensuring data integrity and performance, and guiding a team of data engineers towards best practices and continuous improvement.

What You'll Do:

• ETL Development and Optimization: Design, build, and fine-tune high-performance ETL pipelines using Python and Oracle SQL, leveraging your expertise in query optimization and performance tuning.
• Technical Leadership: Lead and mentor a team of data engineers, fostering a culture of collaboration, best practices, and continuous learning.
• Collaboration and Solution Design: Partner with stakeholders across the organization to understand their data needs and translate them into scalable and efficient data solutions.
• Data Integrity and Security: Implement and maintain processes to ensure data quality, integrity, security, and optimal performance across our data platforms.
• Innovation and Continuous Improvement: Stay abreast of industry trends and emerging technologies in data engineering, advocating for and implementing improvements to our data infrastructure and processes.

What You'll Need:

• Extensive Experience: 10+ years of hands-on experience in data engineering or a closely related field.
• Database Expertise: Mastery of Oracle SQL, including advanced query optimization and performance tuning techniques.
• ETL Proficiency: Proven experience developing and optimizing ETL processes using Apache Spark.
• Programming Skills: Strong programming skills in Scala and/or Python for data engineering tasks.
• Leadership Qualities: Demonstrated ability to lead and mentor engineering teams, manage projects effectively, and foster a positive and productive work environment.
• Data Platform Knowledge: Solid understanding of data warehousing principles, distributed computing architectures, and cloud platforms.
• Problem-Solving Abilities: Excellent analytical and problem-solving skills, with the ability to thrive in a fast-paced, dynamic environment.

Bonus Points:

• DevOps Mindset: Familiarity with CI/CD pipelines and DevOps practices.
• Real-Time Data Experience: Knowledge of real-time data processing frameworks such as Kafka.

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

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

Most Relevant Skills

Please see the requirements listed above.

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

Other Relevant Skills

CI/CD, ETL Development, GitLab CI/CD, Oracle Database, Oracle Database Programming, Oracle SQL, Oracle SQL*Loader, Oracle SQL Developer, PL/SQL (Programming Language), PySpark.

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

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.