We are seeking a motivated, detail-oriented Data Engineer to join our Data Engineering team. In this role, you will assist in designing, building, maintaining, and optimizing scalable data pipelines, data warehouses, and analytics infrastructure. You will work closely with senior data engineers, data scientists, software developers, and business stakeholders to transform raw data into structured, actionable data assets for reporting, advanced analytics, and operational systems.
Key Responsibilities1. Data Pipeline Development & Maintenance (ETL / ELT)
- Assist in developing, testing, and maintaining automated ETL/ELT pipelines to ingest structured and unstructured data from diverse sources (APIs, relational databases, streaming services, flat files).
- Monitor existing data pipelines, troubleshoot data ingestion failures, and implement bug fixes or performance enhancements.
- Implement data transformation, cleansing, and validation routines to maintain high data quality and consistency.
- Support the design and maintenance of relational schemas, dimensional models (star and snowflake schemas), and data lake storage structures.
- Write and optimize SQL queries, stored procedures, and views to extract and aggregate data efficiently.
- Assist in partitioning, indexing, and organizing datasets for optimal query performance.
- Collaborate with senior engineers to implement data validation checks, monitoring alerts, and data reconciliation processes.
- Follow enterprise data governance, privacy, and security policies (e.g., role-based access control, encryption, data masking).
- Document data lineage, metadata definitions, schema changes, and technical architecture.
- Participate in agile/scrum ceremonies including daily stand-ups, sprint planning, and retrospective meetings.
- Use version control systems (Git) for code management and follow continuous integration/continuous deployment (CI/CD) practices.
- Collaborate with QA teams and business analysts to conduct integration and user acceptance testing (UAT).
Qualifications & SkillsRequired Education & Experience
- Education: Bachelor’s degree in Computer Science, Information Technology, Data Science, Software Engineering, Applied Mathematics, or a related quantitative field (or equivalent practical experience/bootcamp certification).
- Experience: 2+ years of relevant hands-on experience in data engineering, data analytics, software development, or related academic/internship projects.
Key Skills & Technologies
Programming Languages
Python, SQL (mandatory); familiarity with Java, Scala, or Bash scripting is a plus.
Relational Databases & SQL
PostgreSQL, MySQL, MS SQL Server, or Oracle. Proficient in joins, window functions, indexing, and aggregations.
Data Warehousing & Lakes
Familiarity with platforms such as Snowflake, Google BigQuery, AWS Redshift, Databricks, or cloud storage (AWS S3, Azure Blob, GCS).
Data Processing Frameworks
Basic understanding of Apache Spark, PySpark, Pandas, or Polars.
Workflow Orchestration
Exposure to tools like Apache Airflow, Prefect, Dagster, or cron-based job scheduling.
Version Control & DevOps
Git/GitHub/GitLab, basic containerization (Docker), and exposure to CI/CD pipelines.
Soft Skills & Competencies- Problem Solving: Strong analytical thinking and troubleshooting mindset with attention to detail.
- Communication: Ability to communicate technical concepts clearly to both technical and non-technical stakeholders.
- Eagerness to Learn: Self-starter with a proactive attitude toward learning modern data architectures, cloud technologies, and best practices.
- Teamwork: Strong collaborative skills and ability to thrive in a team-oriented, fast-paced environment.
Preferred / Nice-to-Have Qualifications
- Cloud certification (e.g., AWS Certified Cloud Practitioner / Data Analytics, Azure Data Fundamentals DP-900 / DP-203, or GCP Associate Cloud Engineer).
- Familiarity with modern data stack tools such as dbt (data build tool), Kafka, or Delta Lake.
- Understanding of basic DevOps and Infrastructure-as-Code concepts (e.g., Terraform, Kubernetes).
- Familiarity with Business Intelligence (BI) and visualization tools (e.g., Tableau, Power BI, Looker).
Strong Python and SQL expertise
Hands on with Shell scripts, PySpark, Hadoop ecosystem
Knowledge on DevOps, CICD pipeline
------------------------------------------------------
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.
Skills Required
- Bachelor's degree in Computer Science, Information Technology, Data Science, Software Engineering, Applied Mathematics, or a related quantitative field, or equivalent practical experience or bootcamp certification
- 2+ years of relevant hands-on experience in data engineering, data analytics, software development, or related academic or internship projects
- Strong Python and SQL expertise
- Experience with relational databases and SQL concepts including joins, window functions, indexing, and aggregations
- Understanding of data warehousing, data lakes, and cloud storage platforms
- Basic understanding of Apache Spark, PySpark, Pandas, or Polars
- Exposure to workflow orchestration tools such as Apache Airflow, Prefect, Dagster, or cron
- Experience with Git-based version control, Docker, and CI/CD practices
- Hands-on experience with shell scripts, PySpark, and the Hadoop ecosystem
- Cloud certification such as AWS, Azure, or GCP certification
- Familiarity with dbt, Kafka, or Delta Lake
- Understanding of DevOps and Infrastructure-as-Code concepts, such as Terraform or Kubernetes
- Familiarity with Tableau, Power BI, or Looker
Citi Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Citi and has not been reviewed or approved by Citi.
-
Healthcare Strength — Health coverage is described as comprehensive and reliable, with multiple medical, dental, vision, prescription, and mental-health options. Wellness programs, counseling, and preventive resources further reinforce health support.
-
Retirement Support — Retirement planning is viewed as a standout, with dollar-for-dollar matching up to 6% and, in some cases, an additional fixed contribution. These elements are positioned as competitive features of the total rewards package.
-
Parental & Family Support — Family-support programs include parental leave, childcare and eldercare resources, backup-care assistance, and educational support. Part-time employees in some areas also access standard health and wellness benefits.
Citi Insights
What We Do
Citi's mission is to serve as a trusted partner to our clients by responsibly providing financial services that enable growth and economic progress. Our core activities are safeguarding assets, lending money, making payments and accessing the capital markets on behalf of our clients. We have 200 years of experience helping our clients meet the world's toughest challenges and embrace its greatest opportunities. We are Citi, the global bank – an institution connecting millions of people across hundreds of countries and cities.








.png)