Lead Data Business Analyst / Data Subject Matter Expert
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.
Key Skills for This Role
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.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Citi
FX Production Support Lead - Vice President
Mississauga, CAN
Discover your future at Citi -------------------------------- Working at Citi is far more than just a job. A career with us means joining a team of approximately 219,000 dedicated people from around the globe. At Citi, y
KYC Operations Analyst - Post Execution Quality Review (PEQR) Analyst - DUBAI
Dubai, UAE
FX Production Support Lead - Vice President
Mississauga, CAN
KYC Operations Analyst - Post Execution Quality Review (PEQR) Analyst - DUBAI
Dubai, UAE
Salesperson Digital FX - Vice President - DUBAI
Dubai, UAE
Infra Tech Lead Analyst - Vice President
Pune, IND
Application Developer - Java Angular
Pune, IND
Senior Software Engineer (VP)
London, GBR
Technical Solutions Architect with Java
London, GBR
Program Management Analyst
Bengaluru, IND