Capco Logo

Capco

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

Posted 6 Days Ago
Hybrid
Mumbai, Maharashtra
Senior level
Hybrid
Mumbai, Maharashtra
Senior level
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.
The summary above was generated by AI

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 

Similar Jobs at Capco

2 Days Ago
Hybrid
Senior level
Senior level
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Develop, test, and maintain Python- and SQL-based data pipelines and ETL/ELT processes on Google Cloud Platform. Build BigQuery transformations, support data warehouse modeling, troubleshoot data quality issues, document solutions, and collaborate with engineers and analysts. The role requires strong GCP data engineering experience, including BigQuery and Pub/Sub, with preferred experience in Cloud Composer, Dataflow, Cloud Functions, Git, and Google Cloud certification.
Top Skills: Apache AirflowBigQueryCloud ComposerCloud FunctionsDataflowGitGoogle Cloud Platform (Gcp)Pub/SubPythonSQL
3 Days Ago
Hybrid
Expert/Leader
Expert/Leader
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Business Analyst supporting capital markets and investment banking projects. Responsibilities include stakeholder management, requirements gathering, business and functional documentation, process change, testing coordination, and collaboration with project managers and sponsors. The role requires knowledge of trade lifecycles, financial products, regulations, trade processing, regulatory reporting, collateral management, or derivatives operations, along with strong communication, analysis, documentation, estimation, and problem-solving skills.
Top Skills: AgileMS OfficeSdlcWaterfall
3 Days Ago
Remote or Hybrid
India
Entry level
Entry level
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Supports finance and risk regulatory change initiatives as a business analyst. Responsibilities include documenting requirements, analyzing complex regulatory data models and high-volume datasets, designing functional solutions, identifying risks and trade-offs, supporting stakeholder decisions, and providing subject matter expertise. The role also involves working with Basel III/IV, PRA/COREP reporting, HSBC credit-risk data, SQL, Excel, Python, and Google Cloud Platform in complex global programs.
Top Skills: Basel Iii/IvExcelGoogle Cloud PlatformPra/CorepPythonSQL

What you need to know about the Chennai Tech Scene

To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account