Sr Data Developer- C12- AVP

The Applications Development Senior Programmer Analyst is an intermediate level position responsible for participation in the establishment and implementation of new or revised application systems and programs in coordination with the Technology team. The overall objective of this role is to contribute to applications systems analysis and programming activities

Technology Skills :

• Must have expert level (hands-on) knowledge and understanding in with MS SQL Server  and ETL (Extract, Transform, Load) processes
• Development of data extraction, transformation and loading (ETL) processes using SQL Server, Stored Procs, SSIS
• Data Modelling - dimensional/reporting, data warehousing and transactional use cases (Physical and Logical modelling)
• Performance optimizations on SQL Server, SQL tuning and investigation of bottlenecks
• Evaluation of tools and technologies for data processing
• Ability to translate architecture and low-level requirements to design and code using SQL
• Must be able to design logical and physical data models for performance aligned to business use cases
• Hands on SQL features - Indexes, Partitioning, Bulk loads, DB configuration, AlwaysOn, Security/Roles
• Scale and optimize performance via schema design, query tuning, and index creation.

• Nice to Have Skill
  • Knowledge of reporting (SSRS and Tableau) and query tools and related practices
  • Hands-on experience with Python  scripting or similar
• Qualifications:
  • Minimum of 7 years of Extensive experience in SQL Server and must have in depth architecture knowledge of SQL engine and Extraction-Transformation-Loading process (SSIS)
  • SQL Management Studio, SQL Server Analysis Services, SQL Server Reporting Services, and Integration Service
• Education:
• Bachelor’s degree/University degree or equivalent experience

This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.

------------------------------------------------------

Job Family Group:

------------------------------------------------------

Job Family:

------------------------------------------------------

Time Type:

------------------------------------------------------

Most Relevant Skills

------------------------------------------------------

Other Relevant Skills

------------------------------------------------------

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.