Job Description

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, PL SQL, Data Modeling, 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 towards best practices and continuous improvement.

What You'll Do:

Data Modelling :

Design Database objects like tables and views

ETL Development and Optimization:

Design, build, and fine-tune high-performance ETL pipelines using Oracle SQL, PL/SQL, leveraging your expertise in query optimization and performance tuning

Technical Leadership:

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:

8+ 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

Data warehousing concepts :

Understanding of data warehousing concepts and tools

Programming Skills:

Strong programming skills in PL/SQL and stored procedures 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

Other Programming language :

Experience with other programming language/scripting language like Python/Java

Real-Time Data Experience:

Knowledge of real-time data processing frameworks such as Kafka

Education:

Bachelor's degree/University degree or equivalent experience


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


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.