Job Description: Data Analyst & AWS Engineer (Snowflake Focus)
Job Title: Data Analyst & Engineer
Experience Level: 3-5 Years
Location: Pune
Job Summary
We are seeking a highly analytical and technically skilled Data Analyst & Engineer with a primary focus on Snowflake and data analytics. In this role, you will be the bridge between our data infrastructure and our business intelligence needs. You will leverage your deep expertise in Snowflake to model, transform, and analyze complex datasets, providing the critical insights that drive our business forward. While your core strength will be in data analysis and Snowflake, you will use your secondary skills in AWS and modern data orchestration tools to help build and maintain the pipelines that feed our analytics platform.
Key Responsibilities
- Design, develop, and maintain complex SQL queries, stored procedures, and data models within Snowflake to support analytical requirements.
- Perform in-depth data analysis to identify trends, patterns, and insights that address key business questions.
- Ensure data integrity, quality, and accuracy within the Snowflake environment.
- Support the data engineering team by contributing to the design and maintenance of data pipelines using tools like MWAA, AWS EKS and AWS Lambda.
- Work within a modern data stack, utilizing Terraform for infrastructure and EKS for containerized applications where necessary.
Required Qualifications & Skills
Primary Skillset (Core Requirements)
- Snowflake: 3+ years of deep, hands-on experience with the Snowflake Data Cloud. This includes:
- Advanced SQL and query performance tuning.
- Data Analysis & Analytics:
- Proven experience in performing quantitative and qualitative data analysis.
- Strong ability to translate raw data into actionable business insights.
Secondary Skillset (Supporting Technologies)
- AWS: Solid understanding of core AWS services, particularly:
- S3: For data lake storage and integration with Snowflake.
- AWS Lambda: For serverless data processing tasks.
- Workflow Orchestration: Experience with building and scheduling data pipelines using MWAA (Managed Workflows for Apache Airflow) or a similar tool.
- Containerization: Familiarity with Docker and Kubernetes (EKS) is a plus, for deploying data-related applications.
- Infrastructure as Code (IaC): Experience with Terraform is highly desirable.
Programming: Proficiency in Python for scripting and data manipulation.
------------------------------------------------------
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
- 3+ years of experience with Snowflake Data Cloud
- Proven experience in quantitative and qualitative data analysis
- Solid understanding of AWS services, particularly S3 and AWS Lambda
- Experience with data pipelines using MWAA or similar tools
- Familiarity with Docker and Kubernetes
- Experience with Terraform
- Proficiency in Python for scripting and data manipulation
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 — Benefits coverage is positioned as comprehensive, including health, dental, and vision insurance plus on-site clinics, prescription drug support, and disability coverage. Family-building support such as fertility assistance is described as a notable differentiator within the overall package.
-
Retirement Support — Retirement benefits are framed as strong, highlighted by a 401(k) with matching and additional plan options like a Roth 401(k). Financial support is reinforced through discounts and broader financial guidance resources tied to the benefits ecosystem.
-
Wellbeing & Lifestyle Benefits — Wellbeing support extends beyond insurance through programs like an Employee Assistance Program, counseling/legal resources, and gym or wellness reimbursement. These offerings increase the perceived total rewards value even when cash compensation sentiment varies by role.
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.
