Data Analyst Data Analyst L3 (5.1-7 years)

About Us

Capco a Wipro company is a global technology and management consulting firm. Awarded with Consultancy of the year in the British Bank Award and has been ranked Top 100 Best Companies for Women in India 2022 by Avtar & Seramount. With our presence across 32 cities across globe we support 100 clients acrossbanking financial and Energy sectors. We are recognized for our deep transformation execution and delivery.

WHY JOIN CAPCO

You will work on engaging projects with the largest international and local banks insurance companies payment service providers and other key players in the industry. The projects that will transform the financial services industry.

MAKE AN IMPACT

Innovative thinking delivery excellence and thought leadership to help our clients transform their business. Together with our clients and industry partners we deliver disruptive work that is changing energy and financial services.

#BEYOURSELFATWORK

Capco has a tolerant open culture that values diversity inclusivity and creativity.

CAREER ADVANCEMENT

With no forced hierarchy at Capco everyone has the opportunity to grow as we grow taking their career into their own hands.

DIVERSITY & INCLUSION

We believe that diversity of people and perspective gives us a competitive advantage.

MAKE AN IMPACT

Job Description

Position Purpose:

The roleis responsible fordelivering data analysis andestablishingautomated reportingcontrolsand monitoring for theBROKKteam on bothadhocand scheduled basesleveraginga suite of analytical tools and SQL. TheBROKKteam is part of GMIT and addresses tariffinvoiceandfeedatacontrol & monitoring across four pillars:

• Data/Business Analysis:Perform and document analysis review and study of tariff invoice and fee data; understand business changes assess impact and cost.

• Data Visualization:Provide dashboards that present tariff usage invoice acquisitionstatusandfeetaxonomyin an appealinguserfriendlyway.

• Data Mining:Extract patterns and knowledge from large volumes of data stored in theBROKKdatabase (tariffs providers) to answer investigations or control needs.

• Data Science:Apply scientific methods to relational data to automate processes & controls (e.g. automatic validation ofratecarddocumentsautoacquisitionof invoices).

Responsibilities

Direct Responsibilities

• Set up automated controls for document storage tariff validation invoiceacquisitionand accounting based on user requirements.

• Act as specialist in one or more areas tariff managementeinvoicingfeetaxonomyreporting.

• Manageworkload prioritize and organize tasks recognizeurgencyand deliver on time.

• Analyze and solve problems proactivelyidentifymissing rate cards mismatched fee taxonomy or invoice gaps and implement solutions.

• Communicate clearly to both technical andnontechnicalaudiences; deliverhighqualitypresentations.

Contributing Responsibilities

• Prioritize tasks whilemaintaininga balance of technical and functional knowledge.

• Contribute to the teams agile way of working.

• Collaborate closely with developers helping them understand concepts to achieve targets.

• Suggest and implement optimized solutions.

• Suggest and implement optimized solutions.

Technical & Behavioral Competencies

• Strong grasp of relational databases; proficient in SQL.

• Experience in data mininganalysisand basic ETL processes.

• Curiousanalyticaland eager to learn.

• Excellent communication skills both written and verbal.

• Qualityfocusedwith strong attention to detail.

• Ability to thrive under pressure and manage stress effectively.

• Comfortable working with distributed teams and sharing knowledge.

• True team player with creativity and aproblemsolvingmindset.

Specific Qualifications:

• Bachelors or mastersdegree in engineering(Computer Science) and/or Financial Markets.

• Advanced knowledge of SQL withhandsonexperience in Oracle environments.

• Functional knowledge of financial products and regulatory frameworks (EMIR MiFID CFTC ).

• Proficiencywithvisualizationtools such as Microsoft PowerBI or OracleApex.

• Ability to produce clear technical and functional specifications.

• Knowledge of Python and ElasticSearch.

• Experience withmachinelearningor AI techniques is a plus.

• Autonomous rigorouscollaborativeand able to manage stress.

Experience Level:Minimum5years of IT experience with provenexpertiseinData Analystrole.

SkillsReferential(Required knowledgeskillsand abilities)

Technical Skills:

• Knowledge of financial products andfeetaxonomy

• SQL

• Datavisualization(PowerBI OracleApex)

• ETL concepts and tools

• Basicmachinelearning/ AI concepts

• Knowledge of financial products andfeetaxonomy

Behavioral Skills:

• Clear communication (technical &nontechnical)

• Analytical problem solving

• Strong quality focus and attention to detail

• Teamwork & collaboration

• Agile mindset and adaptability

• Stress management and resilience

Education Level:Bachelors orMasters degree in Computer Science Engineering or Finance (or equivalent).

Location:Mumbai