
Senior Data Engineer - Assistant Vice President
at Citi
Posted 6 days ago
No clicks
- Compensation
- Not specified
- City
- Chennai
- Country
- India
Currency: Not specified
We are seeking a highly skilled Big Data Engineer to design, develop, and optimize scalable data solutions using Hadoop, PySpark, and Hive. You will build robust ETL pipelines and data warehouses, implement SCD-2 dimensional modeling, and ensure data quality, reliability, and performance. The role requires strong Python and SQL skills, experience with Spark tuning and Hive optimization, and collaboration with data scientists and analysts to deliver robust data solutions. This is a senior, Assistant Vice President level role within Citi's technology organization.
Senior Data Engineer - Assistant Vice President
Discover your future at Citi
Working at Citi is far more than just a job. A career with us means joining a team of more than 230,000 dedicated people from around the globe. At Citi, you’ll have the opportunity to grow your career, give back to your community and make a real impact.
Job Overview
We are seeking a highly skilled and motivated Big Data Engineer to join our dynamic team. The ideal candidate will have extensive experience in designing, developing, and optimizing scalable data solutions using the Hadoop ecosystem, with a strong focus on PySpark and Hive. This role is crucial for building robust ETL pipelines, ensuring data quality, and driving performance improvements across our Big Data initiatives.
Key Responsibilities
Design, develop, and maintain efficient and scalable Big Data solutions using PySpark, Apache Hive, and Hadoop ecosystem tools (e.g., Sqoop).
Should have strong Python knowledge
Implement and optimize ETL (Extract, Transform, Load) processes and data warehousing solutions, including Fact, Dimension, and Slowly Changing Dimensions (SCD-2).
Conduct in-depth data analysis, troubleshoot complex data issues, and ensure the accuracy, reliability, and integrity of data.
Optimize Big Data workflows, including Spark job tuning and Hive query optimization, leveraging partitioning strategies and indexing techniques in distributed storage systems.
Perform rigorous unit testing and validation of data pipelines and transformations.
Collaborate with data scientists, analysts, and other engineers to understand data requirements and deliver robust data solutions.
Technical Qualifications
Big Data Technologies:Demonstrated proficiency with Apache Hadoop, Apache Hive, and PySpark for data processing and analysis.
Data Warehousing & Modeling:Strong understanding and practical experience with data warehousing concepts, dimensional modeling, and SCD-2 implementation.
ETL Development:Proven experience in designing and developing ETL pipelines; familiarity with various ETL tools is an advantage.
Database & SQL:Advanced SQL knowledge, including complex joins, subqueries, and performance tuning of SQL queries.
Scripting:Proficient in shell scripting for automation of batch processes.
DevOps & CI/CD:Experience with CI/CD tools such as Bitbucket and Jenkins.
BI Tools:Familiarity with business intelligence (BI) reporting tools like Tableau.
Desirable Qualifications (Added Advantage)
Experience and/or certifications with major cloud platforms and their Big Data services (e.g., AWS, Azure Databricks, Google Cloud).
Advanced knowledge of Unix shell scripting for system administration and automation.
Skills & Attributes
Excellent critical thinking and problem-solving skills with a strong analytical mindset.
Ability to work independently and collaboratively in a fast-paced environment.
Strong communication skills to articulate technical concepts and solutions effectively.
Education:
Bachelor’s degree/University degree or equivalent experience
If you are a passionate Big Data Engineer looking to make a significant impact, we encourage you to apply!
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.

