Data Engineer-Assistant Vice President

Overview

Assistant Vice President-level Data Engineer role in Citi's Technology team, responsible for designing and building enterprise data warehouse, data product and data pipeline solutions, and leading technical direction, mentorship and governance for data development.

What you'll do

• Develop data warehouse and data-as-a-product solutions, leading architecture and solution design and development of scalable, secure data architecture supporting downstream and reporting applications.
• Develop data models, taxonomies, metadata, data mappings, data standards, versioning and semantic layers for domains and data products, supporting data consumption, AI and regulatory requirements.
• Build automated data integration solutions and data pipelines, including reference data, to meet business and reporting requirements.
• Implement data governance and management, quality standards and data controls to ensure data accuracy and security.
• Manage and maintain data process documentation, data processes and jobs.
• Contribute to technical direction and strategic decisions as a technical expert in development and implementation phases, providing in-depth analyses and innovative solutions.
• Work closely with business users, stakeholders, BAs, product managers and development teams to understand problem space and define solutions.
• Contribute to CI/CD implementation using DevOps best practices and ensure a robust testing framework for functional and nonfunctional testing.
• Exhibit strong leadership, providing guidance and mentorship to team members and promoting continuous learning.
• Demonstrate a data-driven approach to problem-solving, using metrics and performance indicators to assess team efficiency and identify improvements.
• Partner with the Support team to ensure production stability through proactive monitoring and health checks.
• Partner with other Citi development teams to build APIs, integrations and shared components.

What you'll need

• Strong experience designing and building best-in-class enterprise data engineering solutions in a highly matrixed, complex organization.
• Strong experience architecting complex end-to-end data pipelines in highly available, distributed systems for data extraction, ingestion and processing of large data sets.
• Strong hands-on advanced development experience with large databases, complex data models, procedures, error handling, performance tuning/profiling, data security and database optimization and configurations.
• Solid experience in complex data integration.
• Strong experience in large complex physical and logical data model design and development for data warehouse, reporting, and reference and master data.
• Hands-on experience with complex data integration and developing scalable, high-volume data pipelines using APIs, Python, Airflow and Spark.
• Experience in data mesh technologies: Trino/Starburst, S3, distributed stream processing Kafka.
• Strong experience developing data quality and reconciliation controls, data lineage and data catalog documentation, and data control monitoring, and proactively identifying and resolving data inconsistencies and gaps.
• Excellent verbal and written communication skills for collaboration with cross-functional teams, stakeholders and management.
• Strong hands-on experience with modern software paradigms including cloud-native (AWS, Docker) and microservices.
• Experience implementing DevOps, such as CI/CD and modern best practices including testing frameworks and SOLID principles; CI/CD tooling and test automation tools.
• Passion and commitment for adopting new technologies with an exploratory mind-set.
• Experience working in an Agile/Scrum work environment.
• Experience building observability and monitoring for data processes and jobs.
• Innovative ideas and a can-do attitude to work under pressure.
• Experience building data quality control and monitoring.
• Understanding of trading data and experience working in financial services is required.
• Proficiency with modern AI coding and testing tools.
• 7 to 10 years of relevant experience (recommended).
• Experience in systems analysis and programming of software applications (recommended).
• Experience in managing and implementing successful projects (recommended).
• Working knowledge of consulting/project management techniques/methods (recommended).
• Ability to work under pressure and manage deadlines or unexpected changes in expectations or requirements (recommended).
• Bachelor's degree/University degree or equivalent experience.

Nice to have

• Strong hands-on experience in S3, Starburst, Oracle database, Databricks and Snowflake.
• Development DBA experience.

Details

• Location: Pune, Maharashtra, India.
• Time type: Full time.
• Job family: Applications Development (Technology).