GFTS Lead Data Architect / Dat...

citi Citi

Primary Location: United States,Texas,Irving

Other Location: United States,Florida,Tampa

Education: Bachelor's Degree

Job Function: Technology

Schedule: Full-time

Shift: Day Job

Employee Status: Regular

Travel Time: Yes, 10 % of the Time

Job ID: 16069356


The GFTS Data Management and Strategy group supports the Citigroup Global Functions of Compliance, Enterprise Risk, Finance HR & Legal. The group provides centralized expertise in data management processes and technologies, in the areas of Data Architecture, Data Modeling, ETL Development, Business Intelligence, Data Quality, Data Acquisition, Integration and Distribution. Lead Data Architect / Data Modeler is responsible for designing end to end data flows and supporting logical and physical data models in support of a global data warehouse and Reporting Database for use by Finance, Enterprise Risk and Compliance across all lines of business. Lead Architect / Modeler will be responsible for all deliverables associated with end to end data architecture, model, including source to target mappings and data dictionary, with specific focus on Wholesale and Retail areas including financial products (Securities, Derivatives, SFT, Trade Product, Mortgages, Credit Cards, etc) and functions CCAR, FRB reporting (14Q, 14M, Y9C etc) Responsibilities:

Lead meetings with clients and key stakeholders to gather requirements, analyze, finalize and have formal sign-off’s from approvers.

Manage Level 3 escalations and ensure timely resolution to Production outages

Manage team work slate to ensure timely delivery of artifacts on agreed timelines.

Gather and report on all key metrics to determine effectiveness of the process, identify issues and look for improvements

Serve as a Manager leading, mentoring, developing, recruiting and retaining high quality resources and subject matter experts on your team.

Candidate will be an experienced program manager to provide senior management leadership for establishing and running.

Interact with Technology senior management committees and provide status, risk/issues reporting.

Lead the Asia Data Modelers, Data Investigators and technology teams related to GFTS Data Management in the functional analysis, design and project planning.

Lead the Asia GFTS Data Management teams in the project execution, resolve any issues and risks that may arise during the course of the project;

Own and Maintain End to End Data Flow and Architecture of Global Finance systems.

Participate and Drive development and maintenance of Global Finance systems logical data models.

Transform logical models into physical database designs for staging areas, data warehouses, and data marts.

Manage a team of Data Modelers and Data Mappers.

Assess the quality of data during development and test phases of the projects, and open trouble tickets when defects are found. Follow up with development teams to insure that issues are resolved expeditiously.

Respond promptly to trouble tickets opened by testers and production users who report defects in the data. Pinpoint the root cause and assign the tickets to the appropriate development teams.


Must Have

Bachelor's degree or equivalent work experience

Overall from 10+ years of data architecture experience and 5+ years in lead teams.

Past experience (required) of Wholesale Products (Corp Loans, Securities, Derivatives, SFT, Trade Product)

Past experience (Required) of Risk reporting including CCAR (14Q, 14M), Basel, FR2052.

Past experience in Banking Data Warehouse (IBM BDW financial industry standard Model.

Knowledge of and experience applying data modeling techniques and best practices.

Extensive experience with logical / physical relational data modeling using Erwin.

Strong experience in interacting with Sr. Leadership in Risk/Finance Organizations.

Ability to work independently under strict deadlines. Strongly Required

Experience working with and supporting ETL and Front-End development teams.

Strong Database experience with RDBMS: Teradata, Netezza , Oracle, Big Data

Ability to write complex SQL needed to investigate data issues, repair damaged data, and migrate data to new structures.

Familiarity with tuning and performance optimization techniques.

Excellent written and oral communication skills, including use of Excel for presentation of data and mappings.

Demonstrate Complete System Development Life Cycle experience for large scale complex projects with various industries.

Domain knowledge in the Local Regulatory Reporting Data Modeling and Architecture a strong plus.

Domain knowledge in Accounting, Finance is a strong plus.

Ability to manage multiple and remote teams.

Strong Project Management, Resource Management skills

Demonstrated experience managing software products in a business critical environment This position is local to Irving TX. Relocation is not budgeted for this position. Candidates from outside of the area must be able to relocate themselves. Relocation assistance will not be provided. The secondary location is Tampa, FL.

To apply for this job please visit