Business Analyst -Security Reference Data -AVP

Organization & Department Overview

The Securities Master Central (SMC) is responsible for providing authoritative sources of securities indicative data to our clients across the organization, through implementing state of the art technologies and operational processes which promote the collection, storage, analysis, and distribution of product, pricing, account and corporate action data. SMC BA team is tasked with the enhancement to the system including integration of vendor feeds, data model enhancement and updates to existing data from vendors. This may involve analyzing multiple data sets manually or engineering automated solutions. The overall objective of this role is to understand business needs & conduct data analysis

Job Description:

• Data Analysis for complex systems and front to back flows
• Reverse engineering functional specifications from data
• Work closely with End Users/Clients to understand Business Process/Industry Standards/Regulatory Mandate requirements.
• Work closely with IT and Operations partners
• Work with external data vendors (i.e., Bloomberg, Reuters, IDC, Markit, etc) and standards organizations
• Able to execute projects Independently
• Conduct Systems Integrated Testing (SIT) and User Acceptance Testing (UAT)
• Create Function Specification Documents (FSD), System Requirement Specification (SRS), and test plans
  
  

Qualifications:

• Working experience of 9- 12 years. as Business Analyst or Data Analyst
• Strong background in financial reference data and capital markets asset classes such as fixed income, equities and derivatives
• Strong SQL knowledge required (able to query data, analyze and troubleshooting)
• Strong Data analysis and Mapping skill
• Knowledge of MS Excel, Visio
• College degree, specialized training or equivalent work experience
• Data Oriented with an excellent attention to detail
• Experience/understanding of business process reengineering and business modeling concepts, systems development lifecycle
• Strong analytical skills and writing skills, to include solid experience in writing functional and technical specifications
• Must possess good communication skills with the ability to be assertive
• Ability to focus on high quality work while under pressure
• Experience utilizing various SDLC methodologies like Waterfall, Agile (JIRA etc.)
• Comprehensive knowledge of the Testing Lifecycle with SIT, UAT, and Production.
  
  

Must to have:-

• Capital Markets experience specifically for instrument reference data; where person knows attributes in detail for at least one asset classes (Fixed Income or Equities or Derivatives)
• Data analysis with Excel and SQL queries on relation database
• Good communication skills to hold meetings with clients for requirement gathering
• Can write ETL Mapping specifications which can be given to developers
  
  

Nice to have

• Worked with data vendors such a Bloomberg, Refinitiv, ICE, FOW
• Exposure to tools such as JIRA, Visio
• Exposure to technical architecture of data flow such as ETL , Java, ISG Cloud (No development experience in this area is required)
  
  

Preferred Skills

• Experience working with major vendor data providers (i.e., Bloomberg, Reuters, IDC)
• Experience working closely with IT Project managers and development teams
• Experience with vendor product implementation
  
  

------------------------------------------------------

Job Family Group:

Technology

------------------------------------------------------

Job Family:

Business Analysis / Client Services

------------------------------------------------------

Time Type:

Full time

------------------------------------------------------

Most Relevant Skills

Please see the requirements listed above.

------------------------------------------------------

Other Relevant Skills

For complementary skills, please see above and/or contact the recruiter.

------------------------------------------------------

Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.

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 Citi’s EEO Policy Statement and the Know Your Rights poster.