Citigroup Inc
Senior Data Engineer Developer - Vice President
Citigroup Inc, Irving, Texas, United States, 75084
The Applications Development Technology Lead Analyst is a senior level position responsible for establishing and implementing new or revised application systems and programs in coordination with the Technology team. The overall objective of this role is to lead applications systems analysis and programming activities.
Responsibilities
Partner with multiple management teams to ensure appropriate integration of functions to meet goals as well as identify and define necessary system enhancements to deploy new products and process improvements
Resolve variety of high impact problems/projects through in-depth evaluation of complex business processes, system processes, and industry standards
Provide expertise in area and advanced knowledge of applications programming and ensure application design adheres to the overall architecture blueprint
Utilize advanced knowledge of system flow and develop standards for coding, testing, debugging, and implementation
Develop comprehensive knowledge of how areas of business, such as architecture and infrastructure, integrate to accomplish business goals
Provide in-depth analysis with interpretive thinking to define issues and develop innovative solutions
Serve as advisor or coach to mid-level developers and analysts, allocating work as necessary
Appropriately assess risk when business decisions are made, demonstrating 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 judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency
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, Always On, Security/Roles
Scale and optimize performance via schema design, query tuning, and index creation
Knowledge of reporting (Power BI and Tableau) and query tools and related practice
Hands-on experience with Python scripting or similar
Must have experience in SCMs like GitHub, GIT, BitBucket and tools like JIRA
Agile/Scrum methodology experience is required
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:
Technology
Job Family:
Applications Development
Time Type:
Full time
Primary Location:
Irving Texas United States
Primary Location Full Time Salary Range:
$125,760.00 - $188,640.00
In addition to salary, Citi's offerings may also include, for eligible employees, discretionary and formulaic incentive and retention awards. Citi offers competitive employee benefits, including: medical, dental & vision coverage; 401(k); life, accident, and disability insurance; and wellness programs. Citi also offers paid time off packages, including planned time off (vacation), unplanned time off (sick leave), and paid holidays. For additional information regarding Citi employee benefits, please visit citibenefits.com. Available offerings may vary by jurisdiction, job level, and date of hire.
Most Relevant Skills
Please see the requirements listed above.
Other Relevant Skills
For complementary skills, please see above and/or contact the recruiter.
Anticipated Posting Close Date:
Aug 18, 2025
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 (https://www.citigroup.com/citi/accessibility/application-accessibility.htm) .
View Citi's EEO Policy Statement (https://www.citigroup.com/global/eeo-aa-policy) and the Know Your Rights (https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12ScreenRdr.pdf) poster.
Citi is an equal opportunity and affirmative action employer.
Minority/Female/Veteran/Individuals with Disabilities/Sexual Orientation/Gender Identity.
Responsibilities
Partner with multiple management teams to ensure appropriate integration of functions to meet goals as well as identify and define necessary system enhancements to deploy new products and process improvements
Resolve variety of high impact problems/projects through in-depth evaluation of complex business processes, system processes, and industry standards
Provide expertise in area and advanced knowledge of applications programming and ensure application design adheres to the overall architecture blueprint
Utilize advanced knowledge of system flow and develop standards for coding, testing, debugging, and implementation
Develop comprehensive knowledge of how areas of business, such as architecture and infrastructure, integrate to accomplish business goals
Provide in-depth analysis with interpretive thinking to define issues and develop innovative solutions
Serve as advisor or coach to mid-level developers and analysts, allocating work as necessary
Appropriately assess risk when business decisions are made, demonstrating 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 judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency
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, Always On, Security/Roles
Scale and optimize performance via schema design, query tuning, and index creation
Knowledge of reporting (Power BI and Tableau) and query tools and related practice
Hands-on experience with Python scripting or similar
Must have experience in SCMs like GitHub, GIT, BitBucket and tools like JIRA
Agile/Scrum methodology experience is required
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:
Technology
Job Family:
Applications Development
Time Type:
Full time
Primary Location:
Irving Texas United States
Primary Location Full Time Salary Range:
$125,760.00 - $188,640.00
In addition to salary, Citi's offerings may also include, for eligible employees, discretionary and formulaic incentive and retention awards. Citi offers competitive employee benefits, including: medical, dental & vision coverage; 401(k); life, accident, and disability insurance; and wellness programs. Citi also offers paid time off packages, including planned time off (vacation), unplanned time off (sick leave), and paid holidays. For additional information regarding Citi employee benefits, please visit citibenefits.com. Available offerings may vary by jurisdiction, job level, and date of hire.
Most Relevant Skills
Please see the requirements listed above.
Other Relevant Skills
For complementary skills, please see above and/or contact the recruiter.
Anticipated Posting Close Date:
Aug 18, 2025
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 (https://www.citigroup.com/citi/accessibility/application-accessibility.htm) .
View Citi's EEO Policy Statement (https://www.citigroup.com/global/eeo-aa-policy) and the Know Your Rights (https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12ScreenRdr.pdf) poster.
Citi is an equal opportunity and affirmative action employer.
Minority/Female/Veteran/Individuals with Disabilities/Sexual Orientation/Gender Identity.