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.
