Senior Data Analyst

• Securities Lending

We are seeking a Senior Data Analyst with strong expertise in Securities Lending or Capital Markets data. This pivotal role blends deep data analysis, financial domain knowledge, data modelling enablement, and engineering collaboration. The successful candidate will ensure canonical models accurately reflect real-world data, meet regulatory/business requirements, and are technically sound. This position serves as a crucial bridge across Business, Data Modelling, Engineering, and QA teams, ensuring end-to-end data integrity from initial source systems through to final data lake and reporting output.

K͏ey Responsibilities

Data Analysis & Discovery:

• Analyse diverse source systems (relational databases, flat files, vendor feeds).

• Conduct data profiling, pattern recognition, and field-level interpretation.

Securities Lending Domain Expertise:

• Decompose and analyze datasets pertinent to securities lending loans, collateral (cash/non-cash), investment positions/inventory, and accruals (e.g., rebates, fees, interest).
• Understand and document lifecycle events from trade initiation through settlement, collateralization, and return.

1. Cross-Functional Collaboration
   Serve as the central integration point, collaborating with:

• Business / SMEs: Validate data, clarify requirements, resolve ambiguities.

• Data Modelers: Provide structured inputs (entities, attributes, relationships), ensuring model accuracy.

Data Model Enablement:

• Provide high-quality inputs for data modelling (data dictionaries, attribute definitions, entity relationships, source-to-canonical mappings).
• Define business rules, transformation logic, and validation rules.

Skills and Experience͏

Domain & Functional:

• Experience in Capital Markets data (Securities Lending strongly preferred).
• Strong understanding of at least one of the following:
• Positions / inventory
• Collateral / margining
• Trade lifecycle

Data & Technical:

• Strong SQL and hands-on data analysis capability.
• Experience working with relational databases (e.g., Oracle), large/complex datasets, and flat files/vendor feeds.
• Ability to read and interpret SQL and data transformation logic.
  Core Capability:
• Strong analytical and problem-solving skills, including the ability to:
• Interpret complex datasets.
• Identify patterns, inconsistencies, and gaps.
• Derive business meaning from raw data.
  Collaboration:
• Proven experience working with Business stakeholders, Data modelers, Developers, and Testing / QA teams.
• Ability to drive end-to-end traceability from data to output.

͏