22 days ago
Pune, IndiaSenior / Staff+
Responsibilities
- Consult with business clients and technology teams to define functional specifications, data requirements, data flows, and data lineage.
- Provide technical input on complex data-centric projects, including scope, objectives, architecture enhancements, and implementation.
- Design and develop conceptual, logical, and physical data models for reporting, analytics, and business processes.
- Prepare and curate data for AI/ML model development, including data quality, feature engineering, and model validation.
- Use advanced SQL to extract, manipulate, and analyze data from relational databases, warehouses, and Big Data platforms.
- Develop and maintain data visualization dashboards and reports using Tableau, Power BI, or QlikView.
- Analyze complex datasets to identify trends, patterns, and anomalies related to regulatory reporting and liquidity risk.
- Identify data-related risks, recommend mitigation options, and support compliance with applicable laws, policies, and controls.
- Evaluate data technologies and analytical tools and recommend system alternatives or enhancements.
- Advise or coach new and lower-level analysts.
Requirements
- 8–12 years of experience as a Senior PySpark Python Data Engineer or in a similar role within the financial services industry.
- Preferred experience with regulatory reporting such as Basel, CCAR, or FR 2052a and liquidity risk.
- Advanced proficiency in PySpark, Python, and SQL for complex querying, analysis, and optimization across large datasets.
- Strong experience with Oracle, SQL Server, DB2, relational databases, and data warehousing concepts such as dimensional modeling and star or snowflake schemas.
- Expertise with Hadoop, Spark, PySpark, Scala Spark, Kafka, AWS S3, Databricks, and other cloud-based data platforms.
- Experience with data modeling tools and techniques.
- Proficiency with Tableau, Power BI, QlikView, and Excel.
- Experience with Python or R for data analysis is highly desirable.
- Experience preparing data for AI/ML models and understanding AI/ML concepts and workflows is highly desirable.
- Knowledge of data analysis principles, methodologies, and data governance frameworks.
- Experience across all phases of the Software Development Life Cycle for data-centric projects.
- Bachelor's degree or equivalent experience required; master's degree preferred.
- Strong written and verbal communication, problem-solving, decision-making, deadline management, and adaptability skills.
Tech Stack
Categories
Data Engineering
About Citi
Citi is a public financial-services company offering consumer and institutional banking, credit cards, wealth management, treasury and trade solutions, and capital-markets services. It serves individuals, corporations, financial institutions, and governments in more than 160 countries and jurisdictions, earning interest and fee income from lending, payments, trading, and advisory. Founded in 1812 and headquartered in New York, it trades on the NYSE under the ticker C.