Chennai
June 19, 2020
Key Roles & Responsibilities:
3 major key responsibilities are (inclusive but not exhaustive):
1) Analysis and recommendation of data sources and standards for projects
2) Analysis and documentation of data requirements as per Business Requirements, including Data Profiling
3) Provision of data related advice and enforcement of data standards in projects
1) Project support:
All technology projects in the bank are ultimately about data. In addition to enterprise-wide projects that support customer-facing products or channels and internal requirements such as finance and risk, SCB has also implemented an Enterprise-wide data management (EDM) programme and more recently ASPIRE project using SAP FSDM.
For all data projects, the Finance Technology data analysts will be expected to support individual projects by:
Reviewing BRDs and distilling data requirements from the same
Mapping the data requirements to the bank's standard data model
Comparing data requirements with group data standards, and identifying potential sources of non-compliance
Recommending data sourcing approach (including golden sources where applicable)
Planning and coordinating profiling of data at source to ascertain data quality and consistency
Initiating (but not executing) data cleansing where necessary
Proposing data quality validation rules and data quality maintenance where appropriate
Planning and performing acceptance testing activities to ascertain standards and recommendations are being followed
2) Data Requirement Documentation:
As part of the BCBS (Basel Committee on Banking Supervision) 239 requirements, SCB and other banks are required to document data definitions, ownership, lineage, quality and controls for all data needed for risk and finance reporting. Similar regulatory initiatives to guarantee data integrity are coming into place in many of SCB's geographies.
For these projects, the data analyst will perform As-Is analyses to study and document the current state of systems that are in scope of the projects.
The documentation should include: Business Data Requirements, data definitions, mapping to source table and columns, business logic, linkages and controls. It should also include a mapping between data attributes in different existing systems that are in scope of the projects, and the bank's standard data model.
The As-Is analysis is also expected to result in identification of instances where inappropriate or inconsistent data sources are being used, data quality is poor, and/ or controls to ensure data quality are missing or inadequate. Finally, the exercise should also result in recommendations on addressing these issues
3) Project advice and enforcement:
As the team executes on #1 and #2, it will build up collective knowledge and expertise on the bank's data, and he or she has a critical role in:
Assessing the impact of changes in upstream systems on downstream data consumers
Providing advice to anyone in the bank who needs to source a particular type of data for internal use or (particularly) external reporting
Enforcing the bank's data standards through collaboration with the various functional and technology teams supporting the bank's systems
What's expected from you?
Qualifications
Degree in Accounting, Statistics, or Computer Science specializing in Information Management, or equivalent
Domain Knowledge:
Minimum 6 - 12 years of work experience in Banking domain involving one or more of the following: Core Banking, Trade & lending products, Treasury products (Foreign exchange, Money market, Bonds etc), Client on boarding or Due diligence, Regulatory or Internal reporting, sanctions/ anti-money-laundering, Risk Management (Market, Credit or Operational), Data Governance, OR
IT or data analysis/ profiling roles supporting the above areas
In addition, candidates from outside the banking domain will be considered if they have deep functional knowledge of finance and treasury function OR have been involved in data analysis and migration work in major data warehousing projects
Technical skills:
All members of the team must be very proficient in MS Excel (critical to data analysis work). In addition, any combination of the following skills will also be an advantage (though not mandatory)
Prior experience of data analysis and profiling work
Intermediate to advanced knowledge and skills in SQL
Experience of working with data profiling
Knowledge of Logical data modelling concepts, and ideally some practical experience
Experience of working with any of the major transaction processing systems (e.g., eBBS, Hogan, RLS, CCMS, IMEX, OTP, Murex, ACBS, OPICS, etc) or data warehouses (Teradata, KEDW, CDW, IFRS9) used in SCB
Intrinsic traits:
Attention to detail
Curiosity
High degree of responsibility
Self-motivated, requiring minimal supervision
Structure and discipline
Good written communication skills
Able to challenge/ question
What you can expect from the role?
The opportunity to be part of a global team
The opportunity to become the go-to person/focal person for data across the bank globally
Extensive exposure to all parts of the bank's business model
Exposure to data profiling techniques
Exposure to Basel III, BCBS 239 or IFRS9
Sound base for a future career in the broader data space (including analytics, business intelligence, 'big data' etc); the knowledge gained from this role will be invaluable in preparing individuals broader roles in the future
Role - Business Analyst
Industry Type - Banking, Financial Services, Broking
Functional Area - IT Software - Application Programming, Maintenance
Employment Type - Full Time, Permanent
Role Category - System Design/Implementation/ERP/CRM
Education:
UG :Graduation Not Required, Any Graduate in Any Specialization
PG :Any Postgraduate in Any Specialization, Post Graduation Not Required
Doctorate :Doctorate Not Required, Any Doctorate in Any Specialization
Offered Pay Amount
Pay Amount : Rs. 1700000.00Industry
Data Analysisnumber of openings :
1Qualification :
Risk Management, SQL, Data Management, Data Profiling, Basel liiJob Location