Applications Development Technical Senior Lead Analyst

Citibank, N.A. seeks an Applications Development Technical Senior Lead Analyst for its Irving, Texas location.

Duties : Build and design ETL tool for Big data platform, define schema of Hadoop and Oracle to store the Data and audit trial details for Treasury and Enterprise Risk Management data for retail products including Credit Cards, Mortgage and Personal Loans.

Facilitate data provisioning of regulatory submissions programs - CCAR, 14A, 14M, 14Q, FDIC, IFRS 9, CECL and BASEL. Attend daily defect triage meetings for various supported applications.

Provide continuous support for Developing and QA teams in all phases like analysis, design, coding, testing, implementation and post-production monitoring.

Attend Business requirement walkthroughs with the Retail Risk business team to understand the business requirements and functional specifications and translate it into technical user stories, system diagrams, and low-level design documents.

Analyze enterprise and application’s logical and physical data models and associated business rules using complex and nested SQL commands in Oracle, Hive, and Big data environment.

Create Ab Initio Graphs and Plans to ETL and Ingest Retail Regulatory Reporting Data. Use PySpark tool to create the cloud architecture.

Create system design documents, architecture and technical design documents using Visio and Ab Initio plans to demonstrate how the system works for bank’s Retail Risk project.

Create reusable automation scripts using UNIX and Python for repetitive mappings and tasks. Perform reverse engineering of existing software application eco-system to provide feasibility assessment.

Track any requirement changes coming outside of project milestones as change requests for future releases using requirement tracking module in HP ALM and JIRA.

Build Database / UI design and Schema for Big data, Hadoop, Oracle, Teradata, and Netezza to store the data and Audit trial details for Treasury and Enterprise Risk Management data for bank’s Retail products.

A telecommuting / hybrid work schedule may be permitted within a commutable distance from the worksite, in accordance with Citi policies and protocols.

Requirements : Requires a Bachelor’s degree (or foreign equivalent) in Electronic Engineering or related field and 7 years of progressively responsible, post-baccalaureate experience as an ETL Architect, Delivery Project Lead, Technology Lead or related position involving Implementation, Development, Design and Analysis in banking Finance and Risk domain.

• 7 years of experience must include : ETL, Hadoop, Oracle, Teradata, Netezza; CCAR, 14A, 14M, 14Q, FDIC, IFRS 9, CECL, BASEL;
• SQL, Hive; Big Data, Ab initio, HP ALM; and UNIX, Python. At least 4 years of experience must include : CCAR, 14A, 14M, 14Q, FDIC, IFRS 9, CECL, BASEL;

JIRA, Visio, PySpark, Connect Direct (NDM); and Bank products : Credit Cards, Mortgage, Personal Loans. Applicants submit resumes at Please reference Job ID #24748287. EO Employer.

Wage Range : $186,701.15 to $213,000

Job Family Group : Technology

Job Family : Applications Development

Job Family Group : Job Family :

Job Family : Time Type :

Time Type : Full time

Full time

Primary Location :

Irving Texas United States

Primary Location Full Time Salary Range :

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.

Anticipated Posting Close Date :

Jul 17, 2024

Citi is an equal opportunity and affirmative action employer.

Qualified applicants will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Citigroup Inc. and its subsidiaries ("Citi ) invite all qualified interested applicants to apply for career opportunities.

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 the "EEO is the Law () " poster. View the EEO is the Law Supplement () .

View the EEO Policy Statement () .

View the Pay Transparency Posting ()

Citi is an equal opportunity and affirmative action employer.

Minority / Female / Veteran / Individuals with Disabilities / Sexual Orientation / Gender Identity.