{bc}
indeed

Lead Data Business Analyst / Data Subject Matter Expert

Citi
Belfast, GBR
Full-time
Onsite
Discovered 2 weeks ago
SQLClient and Account data modelsData lineage and flow mappingData profiling and reconciliationData quality rules and validationOracle

Full Job Posting

Role overview

Lead data business analyst and subject matter expert for Client and Account data flows, lineage, transaction processing, and governance.

Bridge business stakeholders, operations, technology, and data engineering to improve data accuracy, pipeline design, compliance, and business intelligence.

Data domain and analysis

  • Own expertise in Client Master Data, account hierarchies, onboarding and offboarding, KYC/entity reference data, and downstream data flows.
  • Map end-to-end data lineage from source ingestion through operational stores and warehouses to reporting and regulatory consumers.
  • Identify data bottlenecks, discrepancies, latency issues, and pipeline breakages.
  • Use advanced SQL for discovery, reconciliation, profiling, and root-cause analysis across relational and distributed databases.
  • Validate migrations and data feeds through profiling, variance analysis, gap analysis, and trend identification.
  • Implement automated data quality rules, validation scripts, and reconciliation frameworks.

Business analysis and governance

  • Gather requirements and create technical specifications, BRDs, and FRDs with business, compliance, operations, and product stakeholders.
  • Define user stories, acceptance criteria, data dictionaries, and mappings for Agile/Scrum teams.
  • Plan UAT, create complex data test cases, validate cutover strategies, and oversee execution.
  • Partner on data standards, privacy regulations, and financial regulatory reporting; define critical data elements, ownership, glossaries, and metadata catalogs.

Qualifications

  • 10+ years as a Data Analyst, Business Analyst, Data SME, or Technical Data Consultant in enterprise environments.
  • Expert SQL skills, including complex joins, aggregations, window functions, optimization, indexing, and debugging.
  • Hands-on Client and Account data model expertise, including hierarchies, account lifecycles, counterparty and party master data, and LEIs.
  • Experience reverse-engineering data models, creating ER diagrams, and mapping source-to-target interfaces.
  • Agile/Scrum and Jira and Confluence proficiency; experience with Tableau, Power BI, Looker, or Qlik.
  • Strong communication skills and ability to influence senior business and technical stakeholders.
  • Financial services, banking, fintech, or consulting experience is preferred.

Working model

  • The description states a hybrid working model with up to two days working at home per week; the source text is truncated after this phrase.

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at Citi