Data Analyst Lead Developer

Citibank - More jobs by this advertiser
Data Analyst Lead Developer-19031365
Description
 

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 Risk 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. Risk 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 Finance and Risk areas on financial products (Corp Loans, Securities, Derivatives, Trade Loans)

 

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 and 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 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 data warehouses, and data marts
  • Manage a team of Data Modelers, Data Mappers, Transformation Layer developers and testers
  • 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

Knowledge/Skills Required

  • Extensive experience with logical/physical relational data modeling using Erwin
  • Past experience (required) of Wholesale Products (Corp Loans, Trade Products, Securities, Derivatives)
  • Past experience (preferred) of reporting including CCAR (14Q, 14M), Basel, Liquidity FR2052
  • Past experience in Banking Data Warehouse (IBM BDW  financial industry standard Model
  • Knowledge of and experience applying data modeling techniques and best practices
  • Experience working with and supporting ETL and Front-End development teams
  • Strong Database experience with RDBMS: Teradata, Netezza, Oracle
  • 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
  • Overall from 10+ years of data architecture experience and 5+ years in lead teams
  • Ability to work independently under strict deadlines
  • 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

Qualifications
 

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 Risk 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. Risk 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 Finance and Risk areas on financial products (Corp Loans, Securities, Derivatives, Trade Loans)

 

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 and 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 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 data warehouses, and data marts
  • Manage a team of Data Modelers, Data Mappers, Transformation Layer developers and testers
  • 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

Knowledge/Skills Required

  • Extensive experience with logical/physical relational data modeling using Erwin
  • Past experience (required) of Wholesale Products (Corp Loans, Trade Products, Securities, Derivatives)
  • Past experience (preferred) of reporting including CCAR (14Q, 14M), Basel, Liquidity FR2052
  • Past experience in Banking Data Warehouse (IBM BDW  financial industry standard Model
  • Knowledge of and experience applying data modeling techniques and best practices
  • Experience working with and supporting ETL and Front-End development teams
  • Strong Database experience with RDBMS: Teradata, Netezza, Oracle
  • 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
  • Overall from 10+ years of data architecture experience and 5+ years in lead teams
  • Ability to work independently under strict deadlines
  • 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
  



30 September 2019
Location: India Marche Pune
Work type:
Full time
Sector:
Banking and Financial Services
Profession:
Other
PLEASE! No enquiries from Recruitment Agencies or Headhunters.

Only direct applications will be considered.

This career opportunity is no longer open.
Please search for current vacancies here.


Bookmark and Share
  • Previous Next


This website uses cookies

This website uses cookies to improve user experience. By using our website you consent to all cookies in accordance with our Cookie Policy.
I agree
Read more