Business Data Analyst - Capital Market

Job Description

This role is within enterprise data office and product solution team; focused on ensuring accurate, timely, and fit for purpose data for business, risk management and regulatory reporting requirements.

Engage with Markets, Risk, Finance, Tech, Client org, and Data Engineering Teams to gather requirements, understand application processing, identify gaps and design systematic solution for business needs.

Average day is highly collaborative, focusing on reaching out to application teams and users to understand Markets products processing in Regulatory Reporting data Flow. Document product data flows along with transformation /mapping/enrichments/logic within enterprise systems.

Key Responsibilities:

• Understand Derivatives and SFT data flows within CITI
• Data analysis for derivatives products and SFT across systems for target state adoption and resolution of data gaps/issues
• Lead assessment of end-to-end data flows for all data elements used in Regulatory Reports
• Document current and target states data mapping and produce gap assessment
• Coordinate with the business for identifying critical data elements, defining standards and quality expectations, and prioritize remediation of data issues
• Identify appropriate strategic source for critical data elements
• Design and Implement data governance controls including data quality rules and data reconciliation
• Design systematic solution for elimination of manual processes/adjustments and remediation of tactical solutions
• Prepare detailed requirement specifications containing calculations, data transformations and aggregation logic
• Perform functional testing and data validations
  
  

• 9+ years of combined experience in banking and financial services industry, information technology and/or data controls and governance.
• Preferably Engineering Graduate with Post Graduation in Finance
• Extensive experience in the capital markets business and processes
• Deep understanding of Derivative products (i.e., Equities, FX, IRS, Commodities etc.) Or SFT (Repo, Reverse Repo, Securities Lending and Borrowing)
• Strong Data analysis skills using Excel, SQL, Python, Pyspark etc.
• Experience with data management processes and tools and applications, including process mapping and lineage toolsets
• Actively managed various aspects of data initiatives including analysis, planning, execution, and day-to-day production management
• Ability to identify and solve problems throughout the product development process
• Analytical thinking – ability to break down complex data structures and processes to identify issues and develop logical models that meet business needs.
• Strong knowledge of structured/unstructured databases, data modeling, data management, rapid / iterative development methodologies and data governance tools
• Strong understanding of data governance issues, policies, regulatory requirements, and industry information affecting the business environment
• Demonstrated stakeholder management skills
• Excellent communication skills – needs to be able to communicate with technical and non-technical stakeholders to gather requirement, express needs and develop clear documentation
• Excellent presentation skills, business and technical writing, and verbal communication skills to support decision-making and actions
• Excellent problem-solving and critical thinking skills to recognize and comprehend complex data flow and designs.
• Self-motivated and able to dynamically determine priorities
• Data visualization skills – can help in creating visual representation of data models and provide input to UX / UI team to help make it easier to communicate complex model relationships with stakeholders