Senior PySpark Python Data Engineer - Assistant Vice President
Citi
Get a reply from this employer
Your resume and cover letter, tailored to exactly what they’re hiring for.
Job summary
Citi in Pune, India seeks a Senior PySpark Data Engineer (Assistant Vice President- C12) to bridge business needs and data solutions. You will work on regulatory reporting and liquidity risk, building scalable data models, dashboards, and data pipelines.
Collaboration with AI/ML teams and stakeholders is essential for data quality and governance. You will lead complex data analyses, advise junior staff, and help define data architecture while ensuring compliance with regulatory standards.
Qualifications
- 8–12 years of experience in a senior PySpark Python Data Engineer role, preferably in financial services.
- Experience with regulatory reporting and liquidity risk is a plus.
- Advanced proficiency in PySpark, Python, and SQL for large datasets.
- Experience with SDLC and data governance frameworks.
Responsibilities
- Consult with business clients to define system specifications and collaborate with multiple units.
- Document data requirements, data flows, and lineage for new systems.
- Provide technical input during development and implementation phases.
- Design and develop data models to support reporting and analytics.
- Prepare data for AI/ML model development and ensure data quality.
- Leverage SQL for data extraction from relational databases and data warehouses.
- Develop dashboards/reports using Tableau, Power BI, or QlikView.
- Lead analysis of complex datasets for regulatory reporting and liquidity risk.
- Identify data risks and propose mitigation options.
- Evaluate new data technologies and recommend enhancements.
- Mentor junior analysts and ensure risk-aware decision making.
Skills
Education
Tools
Job description
The Technical Data Analyst is a senior-level position responsible for bridging the gap between complex business requirements and technical data solutions, leveraging advanced analytical and technical skills to develop data-driven solutions, with a focus on regulatory reporting and liquidity risk initiatives. This role will liaise extensively with business stakeholders and technology teams to articulate data needs, extract insights, and ensure data quality and integrity.
- Consult with business clients to determine system functional specifications and partner with multiple management teams and other units to meet organizational objectives.
- Define, document, and validate detailed data requirements, data flows, and data lineage for new or enhanced systems and applications.
- Provide technical input during the development and implementation phases, including formulating and defining systems scope, data objectives, and necessary data architecture enhancements for complex, high-impact projects.
- Design and develop robust data models (conceptual, logical, physical) to support reporting, analytics, and business processes.
- Prepare and curate data for AI/ML model development, working closely with AI engineers to ensure data quality, feature engineering, and model validation.
- Utilize advanced SQL for data extraction, manipulation, and analysis from various relational databases, data warehouses, and Big Data platforms.
- Develop and maintain data visualization dashboards and reports using tools such as Tableau, Power BI, or QlikView, translating complex data into understandable business insights.
- Lead the analysis of complex data sets to identify trends, patterns, and anomalies relevant to regulatory reporting, liquidity risk, and other critical financial functions.
- Identify and communicate data-related risks and impacts and propose risk mitigation options, considering business implications of the application of technology to the current business environment.
- Evaluate new data technologies, analytical tools, and evolving business requirements, and recommend appropriate systems alternatives and/or enhancements to current systems by analyzing business processes, systems and industry standards.
- Serve as advisor or coach to new or lower level analysts.
- Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgement regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.
- 8-12 years of experience as a Senior PySpark Python Data Engineer or similar role within the Financial Services industry, preferably in regulatory reporting (e.g., Basel, CCAR, FR 2052a) and liquidity risk.
- Advanced proficiency in PySpark, Python, SQL for complex data querying, analysis, and optimization across large datasets.
- Strong experience with relational databases (e.g., Oracle, SQL Server, DB2) and data warehousing concepts (e.g., dimensional modeling, star/snowflake schemas).
- Demonstrated expertise with Big Data technologies including Hadoop, Spark (PySpark/Scala Spark), Kafka, and cloud-based data platforms (e.g., AWS S3, Databricks).
- Demonstrated experience with data modeling tools and techniques.
- Proficiency in data visualization tools (e.g., Tableau, Power BI, QlikView) and strong Excel skills for data manipulation and presentation.
- Experience with scripting languages for data analysis (e.g., Python, R) is highly desirable.
- Experience with data preparation for AI/ML models and understanding of core AI/ML concepts and workflows is highly desirable.
- Comprehensive knowledge of data analysis principles, methodologies, and data governance frameworks.
- Experience across all phases of the Software Development Life Cycle (SDLC), with a focus on data-centric projects.
- Consistently demonstrates clear and concise written and verbal communication.
- Demonstrated problem-solving and decision-making skills.
- Ability to work under pressure and manage deadlines or unexpected changes in expectations or requirements.
- Bachelor's degree/University degree or equivalent experience.
- Master's degree preferred.
Technology
Applications Development
Full time
Please see the requirements listed above.
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.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
