Data Analyst - Data Analyst  L3 (5.1-7 years)

Posted 2 Days Ago
Mumbai, Maharashtra, IND
Hybrid
Senior level
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Be Yourself at Work, Make a Difference, and Act with Integrity are our values at Capco.
The Role
Performs data analysis, mining, visualization, and automated reporting for tariff, invoice, and fee data. Builds controls for document storage, tariff validation, invoice acquisition, and accounting. Uses SQL, Oracle, Power BI, Oracle APEX, Python, and ETL concepts to investigate data issues, develop dashboards, support automation, and collaborate with technical and business stakeholders in an agile environment.
Summary Generated by Built In

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 across banking, 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 role is responsible for delivering data analysis and establishing automated reporting, controls and monitoring for theBROKKteam on both adhoc and scheduled bases, leveraging a suite of analytical tools and SQL. TheBROKKteam is part of GMIT and addresses tariff, invoice and feedata control & 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 acquisition status and feetaxonomy in an appealing, userfriendly way. 
  • 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 of ratecard documents, autoacquisition of invoices). 

Responsibilities 

Direct Responsibilities 

  • Set up automated controls for document storage, tariff validation, invoice acquisition and accounting based on user requirements. 
  • Act as specialist in one or more areas – tariff management, einvoicing, feetaxonomy reporting. 
  • Manage workload – prioritize and organize tasks, recognize urgency and deliver on time. 
  • Analyze and solve problems – proactively identify missing rate cards, mismatched fee taxonomy or invoice gaps and implement solutions. 
  • Communicate clearly to both technical and nontechnical audiences; deliver highquality presentations. 

Contributing Responsibilities 

  • Prioritize tasks while maintaining a balance of technical and functional knowledge. 
  • Contribute to the team’s 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 mining, analysis and basic ETL processes. 
  • Curious, analytical and eager to learn. 
  • Excellent communication skills, both written and verbal. 
  • Qualityfocused with 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 a problemsolving mindset. 

Specific Qualifications: 

  • Bachelor’s or master’s degree in engineering (Computer Science) and/or Financial Markets. 
  • Advanced knowledge of SQL, with handson experience in Oracle environments. 
  • Functional knowledge of financial products and regulatory frameworks (EMIR, MiFID, CFTC, …). 
  • Proficiency with visualization tools such as Microsoft PowerBI or OracleApex. 
  • Ability to produce clear technical and functional specifications. 
  • Knowledge of Python and ElasticSearch. 
  • Experience with machinelearning or AI techniques is a plus. 
  • Autonomous, rigorous, collaborative and able to manage stress. 

      Experience Level:Minimum5years of IT experience, with proven expertise in Data Analyst role. 

 

Skills Referential (Required knowledge, skills and abilities) 

Technical Skills: 

  • Knowledge of financial products and feetaxonomy 
  • SQL  
  • Data visualization (PowerBI, OracleApex) 
  • ETL concepts and tools 
  • Basic machinelearning / AI concepts 
  • Knowledge of financial products and feetaxonomy 

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: Bachelor’s or Master’s degree in Computer Science, Engineering or Finance (or equivalent). 

Location: Mumbai 

Skills Required

  • Bachelor's or master's degree in Computer Science, Engineering, Finance, Financial Markets, or equivalent
  • Minimum 5 years of IT experience with proven Data Analyst expertise
  • Advanced SQL knowledge and hands-on Oracle experience
  • Knowledge of financial products and fee taxonomy
  • Functional knowledge of financial products and regulatory frameworks, including EMIR, MiFID, or CFTC
  • Proficiency with Microsoft Power BI or Oracle APEX
  • Experience with data mining, analysis, and basic ETL processes
  • Ability to produce clear technical and functional specifications
  • Knowledge of Python and Elasticsearch
  • Clear written and verbal communication skills
  • Analytical problem-solving ability and attention to detail
  • Ability to collaborate with distributed teams and work in an agile environment
  • Ability to manage workload, deadlines, pressure, and stress effectively
  • Experience with machine-learning or AI techniques

What the Team is Saying

Sarvani
Michael
Josh
Marina
Dreidel
Maud
Lydia
Chris

Capco Compensation & Benefits Highlights

  • Healthcare Strength Health, dental, and vision coverage in the U.S. are characterized as strong, with good coverage and favorable costs. Mental health resources and broader wellbeing programs are also emphasized as part of a comprehensive package.
  • Leave & Time Off Breadth PTO and paid holidays are described as generous, with multiple mentions of strong vacation allowances. While client work can affect usage, the underlying entitlement is presented as solid.
  • Parental & Family Support Company materials highlight enhanced family-friendly policies, including substantial maternity and paternity leave. Flexibility and return-to-work support reinforce a family-oriented approach.

Capco Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: London
6,000 Employees
Year Founded: 1998

What We Do

Capco, a Wipro company, is a global management and technology consultancy specializing in driving transformation in the energy and financial services industries. Capco operates at the intersection of business and technology by combining innovative thinking with unrivalled industry knowledge to fast-track digital initiatives for banking and payments, capital markets, wealth and asset management, insurance, and the energy sector. Capco’s cutting edge ingenuity is brought to life through its award-winning Be Yourself At Work culture and diverse talent. TRUSTED ADVISORS - Our collaborative and entrepreneurial approach position us as trusted long-term partners to our clients. DEEP EXPERTISE - Clients look to us for clear guidance, proven expertise, and the support they need to set their companies up for success. DISRUPTIVE SOLUTIONS- We do not provide off -the-shelf answers to clients’ challenges. Instead, we work in close collaboration to understand the issues, and craft disruptive, bespoke solutions. ACCOUNTABILITY AND OWNERSHIP - We recognize every client has distinct needs and expectations, and we take ownership and accountability for the solutions we design, build, and deliver.

Why Work With Us

We support and encourage an inclusive culture, entrepreneurial outlook and independent thinking. Capco is not about organizational charts and rigid hierarchies – we want all employees to feel that Capco is their firm to own and run. We believe diversity powers innovation. Be Yourself At Work (#BYAW) is an integral and underlying part of our culture

Gallery

Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery

Capco Offices

Hybrid Workspace

Employees engage in a combination of remote and on-site work.

Typical time on-site: Not Specified
Company Office Image
HQLondon, GB
Company Office Image
Bengaluru, Karnataka
Company Office Image
Bengaluru, Karnataka
Company Office Image
Berlin, DE
Company Office Image
Bratislava, SK
Company Office Image
Brussels, BE
Company Office Image
Charlotte, NC
Company Office Image
Chicago, IL
Company Office Image
Dallas, TX
Company Office Image
Düsseldorf, DE
Company Office Image
Edinburgh, GB
Company Office Image
Frankfurt am Main, DE
Company Office Image
Geneva, CH
Company Office Image
Houston, TX
Company Office Image
Kuala Lumpur, MY
Company Office Image
Milan, IT
Company Office Image
Mumbai, IN
Company Office Image
New York, NY
Company Office Image
Orlando, FL
Company Office Image
Paris, FR
Company Office Image
Singapore, SG
Company Office Image
Toronto, Ontario
Company Office Image
Vienna, AT
Company Office Image
Zürich, CH
Learn more

Similar Jobs

Capco Logo Capco

Data Engineer

Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Hybrid
Pune, Maharashtra, IND
6000 Employees

Capco Logo Capco

Testing - Testing L2 (2.1-5 years)-29629-1

Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Hybrid
Mumbai, Maharashtra, IND
6000 Employees

Capco Logo Capco

Functional Testing with Banking Domain - Functional Testing with Banking Domain L2 (2.1-5 years)-29297-1

Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Hybrid
Mumbai, Maharashtra, IND
6000 Employees

Capco Logo Capco

Regulatory Reporting BA - CRD6

Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Remote or Hybrid
India
6000 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account