**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 (https://www.citigroup.com/citi/accessibility/application-accessibility.htm)_ _._ _View Citi’s_ _EEO Policy Statement (https://www.citigroup.com/global/eeo-aa-policy)_ _and the_ _Know Your Rights (https://www.eeoc.gov/sites/default/files/2023-06/22-088\_EEOC\_KnowYourRights6.12ScreenRdr.pdf)_ _poster._ Citi is an equal opportunity and affirmative action employer. Minority/Female/Veteran/Individuals with Disabilities/Sexual Orientation/Gender Identity.