Data Analyst - Business & Data Mapping

Client of Weekday AI

Job Description

Roles & Responsibilities

Desired Candidate Profile

Key Responsibilities

• Engage with business stakeholders to gather, analyze, and document functional requirements for analytics, reporting, and regulatory needs.
• Conduct workshops to understand banking workflows and map them to relevant FSLDM subject areas.
• Create functional specifications, business glossaries, and process flow documents.
• Perform detailed data profiling to assess completeness, consistency, and quality across multiple source systems.
• Identify data gaps and propose remediation or transformation strategies.
• Analyze Teradata FSLDM structures for suitability, alignment, and required enhancements.
• Develop complete Source-to-Target Mapping (STTM) documents, integrating systems such as BANCs, LOS, CLOS, and MUREX with FSLDM entities.
• Define transformation logic, lookup rules, and business rules to support downstream ETL development.
• Ensure mapping, lineage, and documentation adhere to regulatory, governance, and data-quality standards.
• Utilize logical and physical FSLDM models to accurately represent business requirements.
• Provide recommendations for model extensions or customizations when required.
• Support SIT/UAT cycles by validating outputs against defined rules and business expectations.
• Work with ETL teams for issue analysis, triage, and resolution.
• Maintain mapping inventories, lineage documentation, metadata standards, and change-management records.

• 5 10 years of experience in data/business analysis within the banking or financial services domain.
• Deep understanding of Teradata FSLDM or similar large-scale financial services data models.
• Strong SQL skills for data profiling, validation, and analysis across Teradata/Oracle environments.
• Proven ability to create detailed STTMs, business rules, and transformation logic.
• Exposure to regulatory frameworks such as Basel or BCBS 239.
• Experience collaborating with ETL development teams (Informatica, DataStage, Talend).
• Hands-on proficiency with ERwin or similar data modeling tools.
• Strong communication, analytical reasoning, and documentation skills.
• Ability to manage stakeholders effectively, work cross-functionally, and deliver high-quality mapping outputs in complex environments.
• Organized, detail-oriented, and comfortable working in data-governed, process-heavy settings.