AVP, Business Data Analyst (Techno-Functional)

The role:

• The Business Analyst requires to work with the users to gather and document business requirements.

Experience:

• Must have previous Data Warehousing experience with banking domain knowledge
• Minimum 11 years of experience

Job Description:

• Clarifies and translates business requirement to IT system functional requirement and system interaction and flows.
• Collaborate with business users and technical delivery teams in developing scalable and flexible IT solution including studying both the business and system impact, create user stories, functional design, test strategy,
• Understand business context of business requirement, assess if there are gaps and work with business to update requirement documents.
• Based on the translated system feature list, analyse the impact to the existing applications, determine required changes to existing applications
• Develop functional solution design specification that IT Technical team can use and develop the corresponding technical solution design specification.
• Map the requirement into the mapping document that IT technical team can use to build the ETL jobs
• Participate in projects meetings to provide clarity and guidance to the technical delivery team on the functional solution design specification. Update the functional solution design specification as and when necessary.
• Develop test cases and test scripts to test and confirm the delivered IT systems work as per specified by the functional solution design specification.
• Analyse, assess impact, prioritise and update functional solution design document for any additional change requests raised by business.
• Perform data mapping based on DWH data design and model.
• Perform data profiling to identify data quality issues

Functional Skills

• Must have Banking domain experience.

Technical Skills

Hands-on experience on:

• SQL Query ( Preferably Teradata / Hadoop) Intermediate / Advance
• Must have experience in Data Warehouse
• Must Have strong ETL and SQL

Ideal to have:

• FSLDM (Teradata Financial Services Logical Data Model)
• Other banking data model