Data Analyst – Business & Data Mapping (Teradata FSLDM)
About This Role
This role combines data analysis, business requirement gathering, and data mapping expertise for projects built on the Teradata Financial Services Logical Data Model (FSLDM). You will work across business stakeholders, data architects, and ETL teams to translate financial services requirements into accurate source-to-target mappings and analytics-ready datasets.
Essential Functions
- Business Analysis & Stakeholder Engagement
- Collaborate with business teams to gather, analyze, and document requirements for reporting, analytics, and regulatory needs.
- Conduct workshops to understand banking/financial services processes and map them to FSLDM subject areas.
- Create functional specifications, process flows, and business glossaries.
- Data Analysis & Profiling
- Perform data profiling to assess source data quality, completeness, and integrity.
- Identify data gaps and recommend remediation strategies.
- Analyze existing FSLDM structures to determine fitment for business requirements.
- Data Mapping & Transformation Rules
- Develop Source-to-Target Mapping (STTM) documents aligning source systems (e.g., BANCs, LOS, CLOS, MUREX) with FSLDM entities and attributes.
- Define data transformation logic, lookup references, and business rules for ETL developers.
- Ensure mappings comply with data governance, regulatory, and naming standards.
- FSLDM Model Understanding
- Leverage FSLDM’s logical/physical model to align business needs with enterprise data architecture.
- Identify required extensions or customizations to FSLDM.
- Support integration with analytical layers like FSAS.
- Testing & Validation
- Support SIT/UAT by validating data outputs against business rules and source data.
- Coordinate defect triage and resolution with development teams.
- Governance & Documentation
- Follow governance standards for metadata, change control, and versioning.
Qualifications
- Bachelor’s Degree in Computer Science, Information Technology, Electronics, or related field
Must Have
- 5–10 years in data/business analysis within banking or financial services; exposure to regulatory reporting (Basel, BCBS 239).
- Understanding of Teradata FSLDM or other financial services data models.
- Strong in creating STTMs, transformation rules, and mapping documentation.
- Proficient in SQL for data extraction, profiling, and validation (Teradata, Oracle, or similar).
- Experience in requirement gathering, stakeholder management, and functional documentation.
- Ability to work with developers using Informatica, DataStage, or Talend.
- Familiar with ERwin (or similar modeling tools), Excel, PowerPoint, Confluence, Jira.
- Strong communication, presentation, and analytical thinking skills.
- Experience with metadata tools (IBM Information Governance Catalog, Informatica Enterprise Data Catalog, erwin Data Intelligence).
- Exposure to data governance and quality frameworks.
- Knowledge of multiple source systems in banking (payments, trade finance, credit, GL).