Senior SQL & ETL Developer - Assistant Vice President

Senior SQL & ETL Developer - Assistant Vice President | Citi Careers

• Design, develop, and optimize complex SQL queries, stored procedures, functions, and views for data extraction, transformation, and loading.
• Analyze and tune database performance (e.g., query optimization, indexing strategies) to ensure efficient data processing and retrieval.
• Implement data integrity checks and validation rules within SQL scripts.
• Develop and maintain database schemas and data models in collaboration with data architects.
• Lead the design, development, and implementation of robust, scalable, and automated ETL processes using various ETL tools (e.g., Informatica PowerCenter, SSIS, DataStage, Talend, or cloud-native ETL services).
• Develop and maintain data pipelines for ingesting data from diverse sources (e.g., relational databases, flat files, APIs, cloud storage) into target data warehouses or data marts.
• Implement error handling, logging, and monitoring mechanisms within ETL workflows.
• Ensure data quality and consistency throughout the ETL process.
• Apply strong understanding of data warehousing concepts (e.g., Kimball, Inmon methodologies), dimensional modeling, and OLAP principles.
• Work closely with data architects and business analysts to translate business requirements into technical data solutions.
• Manage and maintain data dictionaries and data lineage documentation.
• Lead small to medium-sized data development projects from inception to completion, including planning, execution, and deployment.
• Provide technical guidance and mentorship to junior developers on SQL, ETL best practices, and troubleshooting.
• Diagnose and resolve complex data-related issues, including data discrepancies, performance bottlenecks, and ETL job failures.
• Provide production support for data solutions, ensuring high availability and reliability.
• Collaborate effectively with cross-functional teams including business users, data analysts, data scientists, architects, and IT operations.
• Translate business requirements into technical specifications for data solutions.
• Communicate project status, challenges, and solutions clearly to technical and non-technical stakeholders

• 5+ years of progressive experience in SQL development and ETL design/implementation.
• Must have significant experience in the banking or financial services domain.
• Demonstrated strong domain knowledge in one or more of the following areas: Liquidity Management, Stress Modeling, and Markets Data (e.g., trading data, market risk data).
• Proven experience in leading data projects and/or mentoring junior team members.
• Experience working with large datasets and complex enterprise data architectures.

• 401k matching
• Health insurance
• Flight privileges

Discover your future at Citi