The Lead Data Platform Engineer will guide a team in developing robust and scalable data solutions within the Microsoft SQL Server ecosystem. This role requires deep technical expertise in SQL Server development and database administration, along with experience in managing Very Large Databases (VLDBs). The ideal candidate will also mentor junior talent and drive innovation to deliver high-quality data products that provide critical business insights. The position emphasizes performance optimization, data architecture, and collaboration with the DBA team.

• 6+ years of relevant experience in Apps Development or systems analysis with extensive SQL Server expertise.
• Proven and extensive experience in developing, maintaining, and optimizing solutions for very large databases (VLDBs) in SQL Server version 2019 and above.
• Demonstrated ability in performance tuning for SQL Server, including expert-level skills in query optimization and indexing strategies.
• Deep understanding and practical experience in advanced data modeling principles and data architecture.
• Extensive experience with data loading processes and ETL development, primarily utilizing Microsoft BI tools.
• Strong experience in SQL code reviews and fine-tuning stored procedures.
• Proven experience in managing database security, including maintaining and enhancing existing entitlement and permission models.
• Ability to leverage AI tools for efficient SQL code refactoring and optimization.
• Experience in managing and implementing successful projects with demonstrated leadership skills.
• Consistently demonstrates clear and concise written and verbal communication.

• Manage, develop, and optimize solutions for very large databases within SQL Server version 19 and above.
• Lead performance tuning efforts for SQL Server databases, including query optimization and indexing strategies.
• Work closely with the dedicated DBA team to ensure adherence to best practices for VLDB environments.
• Oversee and guide data loading processes and ETL development utilizing Microsoft BI tools.
• Apply advanced data modeling principles and drive data architecture decisions for data warehouses.
• Conduct rigorous code reviews for SQL to ensure quality and adherence to DBA best practices.
• Maintain and enhance existing entitlement and permission models to ensure robust database security.
• Leverage AI tools to assist in SQL code refactoring and identifying performance bottlenecks.
• Serve as an advisor and coach to mid-level developers and analysts.
• Assess risk in business decisions, ensuring compliance with laws and regulations.

• Citi offers a comprehensive benefits package including competitive pay, stock programs, healthcare coverage, retirement plans, paid time off, parental leave, and programs supporting employee wellbeing and professional development.