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

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 SOP's, 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 model's 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:
M.Com/CA 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: Master's degree or equivalent
Location: Mumbai

Your future duties and responsibilities

Required qualifications to be successful in this role

Together, as owners, let’s turn meaningful insights into action.

Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll 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. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.

Your work creates value. You’ll 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.

You’ll shape your career by joining a company built to grow and last. You’ll 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 team—one of the largest IT and business consulting services firms in the world.