The purpose of this position is to conduct data risk assessment, find issues in the data used for US Federal Reserve regulatory reporting, set up detective rules to catch hold of exceptions. set up controls in close coordination with business stakeholders. The person joining will assist business and regulatory reporting teams to raise issues that affects them, conduct root cause analysis and take them to effective resolution owners to get them closed.
The position also helps in identifying areas of continuous improvement and improve them thus achieving higher efficiency. Support audit queries from time to time from audit teams.
Direct Responsibilities;
Data Risk Assessment
Conduct data risk assessment on data that is used, linked and moves across hobs and the risks faced.
Data Analysis
Analyze large volumes of data related to investment banking domains i.e. capital markets, corporate banking, liquidity, credit risk, market risk, client referential and securities referential and identify issues in them via data quality checks, conduct quality checks on a periodical basis as required and present results to stakeholder for corrective action and take them to closure. Prepare functional reports and assist in automating the process using tools as required. Undertake deep dive of issues affecting the business and come up with the remediation actions. Understand how the data moves across the bank and set up data control checks based on risks. Assess the exceptions generated and share the same with Data Stewards. Understand either of the US FED reports FFIEC002, FRY-15. FFIEC-009 and understand how they are filed from an accounting basis.
Understand the gaps in coverage and check for setting up of control checks. Write medium to complex SQL queries to extract data from database for data analysis. Be able to connect the dots. Explain the functional gaps to techno functional team so that they can incorporate those checks in their systems.
Develop test cases aimed at validating development for a given functional requirement and record them in the official test management platform. Have a continuous improvement mindset.
Data Controls
Maintain an overview and inventory of controls. Conduct a review of the controls in a periodic manner with Data Stewards and business, APS and IT stakeholders. Conduct a certification assessment of the controls on a quarterly cycle.
Prefiling Analysis
Conduct a prefiling analysis to understand whether the transactions are clubbed properly and reported in the correct MDRM in specific Fed reports.
Issue Management and Remediation
Keep a list of the issues, help conduct root cause analysis. Conduct root cause analysis on the issues identified and communicated in close collaboration with data stakeholders.
Project Work
Work on creating requirements for automating processes. Test the solution as per requirement.
Audit Support
Help support audit requirements and responses under stringent timelines.
Contributing Responsibilities;
- Partner with data domain owners to develop new functional logics in existing SQL queries; which will enhance and support the goal of quality data being used for reporting purposes.
- Produce and distribute daily/weekly team Status reports and contribute to project status reporting depending on the undertaking at hand
- Understand the competitive landscape and adopt technology based solutions to drive efficiency
- Create SOPs, perform knowledge transfer and cross training for proper backup in team
Technical Behavioral Competencies Able to write moderate level SQL queries in Oracle without any assistance.
- Understanding of various data models for extraction of required data sets to be consumed for Root cause analysis.
- Experience in one or many of these data quality tools and reporting tools/applications; Power BI, Collibra
- Proficient in MS Office applications; MS Excel, MS Word, MS Powerpoint.
Specific Qualifications (if required) M.Com/CA/ CFA along with 7 years of experience with all shown below:-
- Data quality area
- Data Controls attestation expertise
- Should have supported US FED reports
- Ability to perform root cause analysis
- Business Analyst working in a financial institution and has completed multiple SDLC lifecycle.
Skills Referential
Behavioural Skills : (Please select up to 4 skills)
Ability to collaborate / Teamwork
Attention to detail / rigor
Ability to deliver / Results driven
Active listening
Transversal Skills:
Ability to develop and adapt a process
Ability to understand, explain and support change
Analytical Ability
Ability to set up relevant performance indicators
Ability to develop and leverage networks
Education Level:
Master Degree or equivalent
