Prime Service Analyst

Master Mind Consultancy; Mumbai; On-site; INR 1,200,000 - 2,200,000; Full time

Job summary

Master Mind Consultancy seeks an analytics professional to prepare client scorecards and generate revenue, P&L, and business performance reports using SQL. The role involves validating data, investigating discrepancies, and automating reporting with SQL and Python to boost efficiency.

You will analyze client profitability, collaborate with global stakeholders to gather requirements, and support sales with insightful reports and management presentations.

Qualifications

• Strong knowledge of equities, derivatives, fixed income and related instruments.
• Understanding of P&L, Balance Sheet and financial resources.
• Advanced MS Excel and SQL/Python skills.
• Strong analytical, logical and problem-solving abilities.
• Excellent communication and stakeholder management skills.
• Ability to multitask and meet deadlines in a team setting.

Responsibilities

• Prepare client scorecards and generate daily/weekly revenue, balance sheet, and business performance reports using SQL.
• Validate reporting data, investigate P&L discrepancies, and troubleshoot issues.
• Automate reporting processes using SQL/Python and improve operational efficiency.
• Perform client profitability, revenue, and returns analysis to support sales teams.
• Collaborate with global stakeholders to gather requirements, develop reports, and implement solutions.
• Prepare management presentations and coordinate reporting of revenue, P&L, and business metrics.

Skills

Equities

Equity Derivatives

Convertible Bonds

Fixed Income

Report Building

Futures Studies

Options

SQL

Python

Excel

Analytical Thinking

Communication

Stakeholder Management

Multitasking

AI Tools

Tools

SQL

Python

Excel

Job description

• Prepare client scorecards and generate daily/weekly revenue, balance sheet, and business performance reports using SQL.
  
• Validate reporting data, investigate P&L discrepancies, and troubleshoot issues.
  
• Automate reporting processes using SQL/Python and improve operational efficiency.
  
• Perform client profitability, revenue, and returns analysis to support sales teams.
  
• Collaborate with global stakeholders to gather requirements, develop reports, and implement solutions.
  
• Prepare management presentations and coordinate reporting of revenue, P&L, and business metrics.

Requisites

• Strong knowledge of Equities, Equity Derivatives, Fixed Income, Repo, Convertible Bonds, and Futures & Options.
  
• Understanding of P&L, Balance Sheet, and Financial Resources.
  
• Advanced MS Excel skills and knowledge of SQL/Python.
  
• Strong analytical, logical, and problem-solving skills.
  
• Excellent communication, interpersonal, and stakeholder management skills.
  
• Ability to multitask, meet deadlines, and work effectively in a team.
  
• Familiarity with AI-powered tools and AI-assisted workflows.

Skills :

Equities,Equity Derivatives,Convertible Bonds,Fixed Income,Report Building,Futures Studies,Options