Business Analyst - Assistant Manager

Paytm; Dadri; On-site; INR 1,500,000 - 2,600,000; Full time

Job summary

Paytm is seeking a data-driven Business Analyst to turn complex business data into actionable insights using SQL, Python, and AI tools. The role emphasizes automating reporting, building dashboards, and developing data-driven decision support for leadership.

The ideal candidate will contribute to KPI development, data quality validation, and scalable analytics solutions across business functions.

Qualifications

• Strong SQL skills and experience with analytical databases.
• Proficient Python for data processing and automation.
• Excellent Excel and Google Sheets capabilities for dashboards and analysis.
• Hands-on with Claude or similar Generative AI tools.
• Ability to write effective AI prompts for business analysis.
• Understanding of data extraction, transformation, validation, and reporting automation.

Responsibilities

• Analyze large datasets using SQL and Python to identify trends, gaps, and risks.
• Build and optimize complex SQL queries for KPI reporting and performance analysis.
• Leverage AI tools for advanced analytics and leadership-level reporting.
• Develop automated Excel/Google Sheets dashboards and MIS reports.
• Translate business requirements into analytical frameworks and KPIs.
• Automate routine reporting and data processing with Python.
• Create reusable AI prompts and analytical frameworks for reporting.

Skills

SQL

Python

Excel/Sheets

Claude/AI tools

AI prompts

ETL/automation

Tools

Superset

Power BI

Tableau

Looker

Google Sheets API

Job description

Business Analyst - AI, Data Analytics & Automation

Role Overview

We are looking for a data-driven Business Analyst who can leverage AI, Claude, Python, SQL, and Excel/Google Sheets to convert complex business data into actionable insights. The role will work closely with business and leadership teams to identify performance gaps, automate reporting, build analytical solutions, and support data-driven decision-making.

Key Responsibilities

• Analyze large business datasets using SQL and Python to identify trends, gaps, opportunities, and business risks.
• Build and optimize complex SQL queries for business reporting, KPI measurement, and performance analysis.
• Use Claude/AI tools for advanced data analysis, business insights, automation, prompt engineering, and leadership-level reporting.
• Develop automated Excel and Google Sheets dashboards, MIS reports, trackers, and performance summaries.
• Convert business requirements into analytical frameworks, KPIs, dashboards, and actionable recommendations.
• Automate repetitive reporting and data-processing activities using Python.
• Build data pipelines for extracting, transforming, validating, and loading data into Excel/Google Sheets.
• Create leadership-ready business briefs, executive summaries, callouts, and performance reports using AI.
• Work with stakeholders to understand business problems and translate them into data-driven solutions.
• Validate data quality and ensure consistency across SQL, Excel, Google Sheets, and reporting outputs.
• Improve existing reporting processes through automation, standardization, and AI-assisted analysis.
• Develop reusable prompts and analytical frameworks for AI-based business reporting.

Required Skills

Technical

• Strong SQL skills, preferably Trino/Presto or similar analytical databases.
• Good Python knowledge, especially Pandas and data-processing/automation.
• Strong Excel / Google Sheets skills including Pivot Tables, formulas, lookups, dashboards, and data analysis.
• Hands-on experience with Claude or other Generative AI tools.
• Ability to write effective AI prompts / prompt engineering for business analysis.
• Understanding of data extraction, transformation, validation, and reporting automation.

Business Analytics

• Strong understanding of KPIs, productivity, participation, conversion, growth, and operational metrics.
• Ability to perform root-cause analysis and convert findings into business recommendations.
• Strong analytical and problem-solving skills.
• Ability to work with large datasets and identify meaningful business patterns.
• Experience creating management/leadership-level dashboards and business reports.

Preferred Skills

• Experience in AI-driven analytics and reporting automation.
• Experience integrating Python with Google Sheets APIs.
• Experience automating scheduled reports and MIS processes.
• Knowledge of BI tools such as Superset, Power BI, Tableau, or Looker.
• Experience working with business operations, sales, merchant, workforce, or field-force datasets.
• Understanding of data warehousing and analytical data models.

Key Deliverables

• Automated business MIS and dashboards.
• SQL-based analytical datasets.
• Python-based reporting and automation solutions.
• Google Sheets/Excel performance trackers.
• AI-generated leadership business briefs.
• KPI and productivity analysis.
• Day-on-day and month-on-month performance analysis.
• Root-cause analysis and business recommendations.
• Automated reporting workflows reducing manual effort.