Business Analyst – Data Lakehouse Program

Key Responsibilities

Requirements & Stakeholder Management

·                 Engage with business, IT, EDM, DWH, Data Governance, and reporting stakeholders to gather and document requirements.

• Conduct workshops to understand business processes, reporting needs, and data consumption requirements.
• Translate business requirements into functional specifications and user stories.
• Manage requirement traceability throughout the project lifecycle.

Data Analysis & Modeling Support

·                 Analyze source systems, data flows, and business processes.

• Support logical and physical data model validation aligned with FSLDM and FSAS standards.
• Review and validate source-to-target mappings, transformation rules, and business logic.
• Ensure business definitions, data semantics, and reporting requirements are accurately captured.

Data Quality & Reconciliation

·                 Define and validate business data quality rules.

• Support data profiling, reconciliation, and validation activities across Source Systems, DWH, EDM, and Data Lakehouse layers.
• Analyze data discrepancies and collaborate with technical teams for remediation.
• Participate in defect triage, root cause analysis, and resolution tracking.

Reporting Repointing Support

·                 Collaborate with reporting teams to understand report logic and dependencies.

• Support mapping of legacy reports to new Gold Layer data structures.
• Validate data readiness and business acceptance for report repointing activities.
• Facilitate business sign-off and UAT approval processes.

Testing & Validation

·                 Prepare and review SIT/UAT scenarios and test cases.

• Coordinate business testing activities.
• Validate functional and data requirements against implemented solutions.
• Support performance and business validation reviews.

Documentation & Governance

·                 Prepare BRDs, Functional Requirement Specifications (FRS), Data Mapping Documents, Process Flows, and User Stories.

• Maintain requirement traceability matrices, issue logs, and decision registers.
• Support data governance, metadata, lineage, and compliance initiatives.
• Participate in project governance, status reporting, and stakeholder communication.

Required Skills & Experience

·                 10+ years of Business Analysis experience in Banking and Financial Services.

• Strong knowledge of Data Warehousing, Data Lakehouse, EDM, and reporting ecosystems.
• Experience with FSLDM, FSAS, enterprise data models, and data governance frameworks.
• Strong understanding of ETL/ELT processes, data reconciliation, and data quality concepts.
• Experience in Agile and Waterfall delivery models.
• Excellent stakeholder management, communication, and documentation skills.

Preferred Skills

·                 Experience with Cloudera, Informatica, Teradata, Denodo, Kafka, and modern Data Lakehouse platforms.

• Exposure to regulatory reporting and banking data domains.
• Knowledge of NDMO/NDI compliance and data governance practices.

·                 Relevant certifications such as CBAP, PMI-PBA, Agile BA, or Data Management certifications are preferred.

Key Deliverables

·                 Business Requirement Documents (BRD)

• Functional Specifications
• Source-to-Target Mapping Validation
• Data Reconciliation Reports
• UAT Sign-off Documentation
• Report Repointing Support Artifacts
• Data Model Review & Validation Documents