Data Analytics Lead Analyst

Citi • Irving, TX

1d • Hybrid

About The Position

Citibank, N.A. seeks a Data Analytics Lead Analyst for its Irving, Texas location. This role involves performing data modeling, integrating data from diverse sources while upholding data governance principles. The analyst will contribute significantly to the design, development, and maintenance of data warehouses, complex ETL processes, and robust schema designs, working collaboratively with data governance teams on standards and policies. Key responsibilities include defining Critical Data Elements (CDEs) and Data Quality Processes (DQP) for multiple data sources during ingestion, maintaining strict data model versioning and metadata management in repositories like Git and Collibra, and ensuring all designs align with business requirements and data governance policies through close collaboration with senior architects and project managers. The role also requires developing and maintaining complex PL/SQL applications for critical banking systems, optimizing database performance, working on Tableau reporting, and assisting with building a centralized robust and scalable software system for ICRM Applications. Preparation of design documents, applying best practices for data quality, and utilizing software development methodologies (waterfall, agile, scrum) with tools like Oracle SQL & PL/SQL, Ab Initio, EME, and Autosys on Linux/Unix are also key aspects. The role includes end-to-end application performance analysis, functional and unit testing, and supporting system integration and UAT. A telecommuting/hybrid work schedule may be permitted.

Requirements

• Master’s degree, or foreign equivalent, in Applied Computer Science, Computer Applications or related field and 4 years of experience as a Senior Data Analyst, Associate Consultant, Consultant, Software Engineer or related position performing data modelling, data governance, and maintaining data quality within the financial services domain.
• Alternatively, a Bachelor’s degree in the listed fields and 6 years of progressively responsible, post-baccalaureate experience in the listed positions.
• Maintaining data warehouses, ETL processes, and schema designs
• SQL, PL/SQL Development
• Database Performance Optimization
• Ab Initio, EME, and Autosys
• Software development methodologies (waterfall, agile, scrum)
• Git, Collibra, Data Catalog
• System integration and UAT
• AWS S3 stage and snowpipe
• Shell Scripting development
• 2 years of experience must include: SAP BO (BI) report Development.

Responsibilities

• Perform data modeling, integrating data from diverse sources while upholding data governance principles.
• Contribute significantly to the design, development, and maintenance of data warehouses, complex ETL processes, and robust schema designs, working collaboratively with data governance teams on standards and policies.
• Actively define Critical Data Elements (CDEs) and Data Quality Processes (DQP) for multiple data sources during ingestion.
• Maintain strict data model versioning and metadata management in repositories including Git and Collibra.
• Ensure all designs aligned with business requirements and data governance policies through close collaboration with senior architects and project managers, confirming adherence to established data modeling best practices.
• Develop and maintain complex PL/SQL applications for critical banking systems, encapsulating intricate transactions and ensuring data consistency, while also optimizing database performance through indexing, partitioning, and diligent query tuning.
• Work on Tableau reporting to prepare data sets for visualization.
• Assist with building a centralized robust and scalable software system in support of the development of ICRM Applications.
• Prepare design documents, design patterns, component design specifications, and technical specifications to define the software system architecture, application programs, modules, interfaces, and data flows for ICRM and other ICRM related initiatives.
• Apply best practices to ensure high data quality and reduced redundancies.
• Use software development methodologies (waterfall, agile, scrum) to develop strategic software systems and application programs using Oracle SQL & PL/SQL, Ab Initio, EME, and Autosys which are deployed on Linux and Unix Operating systems.
• Perform end-to-end application performance analysis.
• Perform functional and unit testing of the application and software systems to uncover any potential bugs, and support system integration and User Acceptance Testing (UAT).

Benefits

• medical, dental & vision coverage
• 401(k)
• life, accident, and disability insurance
• wellness programs
• paid time off packages, including planned time off (vacation), unplanned time off (sick leave), and paid holidays

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Number of Employees: 5,001-10,000 employees