Role Overview:The candidate will be responsible for requirements gathering, data analysis, source-to-target mapping, data profiling, reconciliation, and stakeholder engagement. The ideal candidate will bridge business and technical teams to ensure successful delivery of data products and reporting solutions.
Key Responsibilities:- Gather and document business requirements.
- Analyze source system data structures and relationships.
- Conduct gap analysis between current and future-state solutions.
- Translate business requirements into technical specifications.
- Prepare Source-to-Target Mapping (STM), Data Mapping Documents, Business Rules Documentation, and Functional Specifications.
- Perform data profiling and analysis, identify data quality issues, and analyze data anomalies and reconciliation differences.
- Validate conversion and migration results.
- Conduct requirement workshops and facilitate discussions between Business Teams, Data Engineers, Architects, and QA Teams.
- Manage requirement clarifications and approvals.
- Support Sprint Planning, review design documents, assist UAT execution, and validate reporting and downstream data delivery.
- Create Business Requirement Documents (BRD), Functional Requirement Documents (FRD), Data Dictionaries, Data Lineage Documentation, and Data Mapping Specifications.
Required Skills:- Advanced SQL
- Data Profiling
- Source-to-Target Mapping
- Data Quality Analysis
- SQL Developer
- Teradata SQL Assistant
- Github/Copilot
- JIRA
- Confluence
- Dimensions and Facts
- Data Lineage
- Master Data Concepts
- Reference Data Management
- BRD
- FRD
- User Stories
- Acceptance Criteria
- Process Flows
Qualifications:- 3+ years of Data Analysis experience.
- Experience in large-scale migration or modernization programs.
- Experience in Commercial Lending System.
Preferred Skills:- Banking and Lending Knowledge
- FIS Commercial Lending
- Loan Servicing
- Customer Information Systems
- Financial Reporting