Data Engineer (Hybrid)

Job Id: 23629648

Job Description:

• As a member of the Data and Analytics group under the Securities Services Technology group, you will contribute to the team’s goal in enriching the data from various sources.
• You will be developing data pipelines (both real time and batch) to ingest, conform, transform and integrate data from various internal and external systems.
• You will gain an understanding of the complex domain model and define the logical and physical data model for the Securities services business.
• You will also constantly improve the warehouse processes by analysing them and possibly automating them where possible.
• You will be responsible for defining standards and best practices for the team in the areas of Code Standards, Unit Testing, Continuous Integration, and Release Management.
• You will be working with a wide variety of stakeholders (source systems, business sponsors, product owners, scrum masters, enterprise architects) and possess excellent communication skills to articulate challenging technical details to various class of people.

Position Requirements:

• 3+ years of experience in IT and data base/data warehouse domain
• Experience in writing sqls in Hive, Impala
• Strong SQL skills are essential; experience writing complex queries spanning multiple tables is required.
• Experience in AWS is plus.
• Working knowledge of performance tuning of database queries (understanding the inner working of the query optimizer, query plans, indexes, partitions etc.).
• Experience in a ETL/data warehouse environment handling tera bytes of data.
• Working knowledge of data modelling and dimensional modelling tools and techniques.
• Exposure to scripting language like shell scripting, python is required.
• Experience in data quality, data governance, DataOps and latest data management techniques a bonus.

We offer:

• Opportunity for professional development in the international and multicultural organization
• Developing opportunities and challenging assignments
• Attractive and stable employment conditions
• Social benefits (medical care, Benefit System, life insurance, pension scheme)
• Partial Remote work possible – Hybrid model

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:

Operations - Core

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

Job Family:

Operations Project Management

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

Time Type:

Full time

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

Citi is an equal opportunity and affirmative action employer.

Qualified applicants will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Citigroup Inc. and its subsidiaries (Citi”) invite all qualified interested applicants to apply for career opportunities. 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 the EEO is the Law poster. View the EEO is the Law Supplement.

View the EEO Policy Statement.

View the Pay Transparency Posting