Citigroup Inc
Senior Data Engineer Developer - C13 - IRVING
Citigroup Inc, Irving, Texas, United States, 75084
Senior Data Engineer Developer - IRVING
Working at Citi is far more than just a job. A career with us means joining a team of more than 230,000 dedicated people from around the globe. At Citi, you'll have the opportunity to grow your career, give back to your community and make a real impact. Job Overview
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 firms 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 Bachelors 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.
Working at Citi is far more than just a job. A career with us means joining a team of more than 230,000 dedicated people from around the globe. At Citi, you'll have the opportunity to grow your career, give back to your community and make a real impact. Job Overview
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 firms 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 Bachelors 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.