28393-Data Analyst L2 (2.1-5 years) MUM

Position Description:

Responsibilities
Direct Responsibilities
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 US FED regulatory reports on risk liquidity exposures 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.
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 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:
Inter / CFA along with 2-2.5 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
. Use technologies SQL AI to augment the process
. Business Analyst working in a financial institution and has completed multiple SDLC lifecycle.

Experience Level: 2-2.5 years
Skills Referential(Required knowledge skills and abilities)
Technical Skills:

. Excel
. SQL
. Understanding of SDLC lifecycle
. Good to have knowledge on Power BI Python


Behavioral Skills:

. Ability to collaborate / Teamwork
. Attention to detail / rigor
. Ability to deliver / Results driven
. Active listening
. Analytical Ability
. Ability to understand explain and support change
. Ability to develop and adapt to a process
. Ability to manage / facilitate a meeting seminar committee training
. Ability to develop and leverage networks


Education Level:Masters degree or equivalent
Location:Mumbai

Skills:

• Communication
• Python
• Shell Script
• SQLite
• Infrastructure

What you can expect from us:

Together as owners lets turn meaningful insights into action.

Life at CGI is rooted in ownership teamwork respect and belonging. Here youll reach your full potential because

You are invited to be an owner from day 1 as we work together to bring our Dream to life. Thats why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our companys strategy and direction.

Your work creates value. Youll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas embrace new opportunities and benefit from expansive industry and technology expertise.

Youll shape your career by joining a company built to grow and last. Youll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

Come join our teamone of the largest IT and business consulting services firms in the world.