Senior Business Analyst

Tech Mahindra

Mumbai

On-site

INR 800,000 - 1,100,000

Full time

2 days ago

Be an early applicant

Application generator

Turn this role into an interview — a resume and cover letter built around what this employer wants.

Get past ATS filters

Job summary

Tech Mahindra is seeking a Data Analyst - BI & Analytics for Mumbai to conduct statistical analysis on contact center data and provide analytics support to stakeholders. The role emphasizes SQL and Python, ETL, and end-to-end BI activities.

The candidate will manage junior analysts, participate in multiple interview rounds, and work strictly from the office in Mumbai (Malad/Goregaon). Graduation is required.

Qualifications

3+ years of experience in data analytics.
Knowledge of SQL (MS SQL Server / MySQL) is mandatory.
Experience with Python for data cleaning, ETL and analytics.
Experience in end-to-end analytics including data cleansing, ETL, modelling and reporting.

Responsibilities

Conduct statistical analysis and identify areas of concern in contact centre metrics.
Translate data into actionable business insights and strategies for stakeholders.
Perform end-to-end analytics and reporting: data analysis, cleansing, ETL, modelling, development, testing and implementation.
Prepare management presentations and dashboards to support business decisions.
Collaborate with MIS and Automation teams to translate analytics into requirements for applications/tools.

Skills

SQL

Advanced SQL

Complex SQL

Business Logic

Query Optimization

Analytical SQL

DBMS

Database Design

Normalization

Indexing

Query Performance Tuning

RDBMS

Database Management

Stored Procedures

Triggers

Cursors

PL/SQL

T-SQL

Database Programming

Logical Thinking

Problem Solving

Logical Reasoning

Algorithm Design

Analytical Thinking

Python Data Cleaning

Python

Data Cleaning

Data Wrangling

Pandas

NumPy

Data Preprocessing

ETL

Web Scraping

Beautiful Soup

Selenium

Scrapy

API Integration

Education

Graduation

Job description

*We are looking for Data Analyst - BI & Analytics - SQL - PYTHON for our organization*

Candidates should have skills, hand and experience on the below

SQL & Business Logic Tags

SQL

Advanced SQL

Complex SQL Queries

Business Logic Implementation

SQL Query Optimization

Analytical SQL

DBMS End-to-End Tags

DBMS

Database Design

Normalization

Indexing

Query Performance Tuning

RDBMS

Database Management

Stored Procedures / Triggers / Cursors (the specific technical depth you want)

Stored Procedures

Triggers

Cursors

PL/SQL

T-SQL

Database Programming

Logical Thinking / Problem Solving

Problem Solving

Logical Reasoning

Algorithm Design

Analytical Thinking

Python Data Cleaning & Wrangling

Python

Data Cleaning

Data Wrangling

Pandas

NumPy

Data Preprocessing

ETL

Web Scraping

Beautiful Soup

Selenium

Scrapy

API Integration

Years of Experience: - Need minimum 3+ years of experience

Candidates should be able to manage junior analyst even if not on papers that is acceptable, but should have knowledge of handling a team

Education Criteria - Min Graduation

Job Opportunity:- Strictly WORK FROM OFFICE ONLY

Work Location - Mumbai (Malad Goregaon)

Rounds of Interview - 3 rounds as below

Online test based on SQL and Python

Tech managerial Round (F2F/Virtual)

HOD Round (Compulsory F2F)

JOB PURPOSE:

Analyst BI Analytics will be responsible for conducting statistical analysis and highlighting areas of concerns in terms of Contact Centre statistical parameters; and providing regular analytics support to the team and external stakeholders

PRINCIPAL ACCOUNTABILITIES:

To conduct statistical analysis and highlight areas of concern in terms of Contact Centre statistical parameters:

Analyzes available data and reports, by using statistical tools (if required), to gain better understanding of issues/concerns impacting business.
Highlights areas of concern in terms of contact center statistical parameters by translating raw data into business insights and strategies.
Participates in activities such as modelling framework, defining data requirements, creating predictive variables, and coordinating model implementation with other business partners
Develops business insights out of analysis and puts together management presentations in PowerPoint with minimal guidance.

To provide analytics support to stakeholders:

Interfaces with stakeholders to better interpret their business needs and translates them into application and operational requirements.
Interfaces with stakeholders to validate business requirements/requests for analysis and presents intermediate and final analytical results.
Interfaces with MIS and Automation team members to translate analytical results into requirements for new and/or existing applications/tools and works to ensure high quality and stable implementations.

To manage and perform daily Business Intelligence (BI) activities:

Documents analytical methodologies used in the execution of analytical request projects.
Prepare documentation for developed models and provide analysis support for business strategies.
Performs end-to-end analytics and reporting solutions that include data analysis, cleansing ETL, modelling, development, testing, and implementation.
Develops analytical approaches to meet business requirements. This involves translating requests into database queries, analyzing data, mining data and transforming results into actionable reports, data visualizations, and interactive user interfaces.

KNOWLEDGE, SKILLS & COMPETENCIES REQUIRED

Functional Skills and Competencies:

Understands and knows the industry/organization and business drivers that impact the organization.
Understands basic project management techniques and knows how to implement these techniques.
Displays strong research orientation and is familiar with various research methodologies and fundamentals such as Data Collection Methods, Measurement and Scaling Techniques, Sampling Fundamentals, Analysis of Variance and Covariance, Multivariate Analysis Technique, etc.
Ability to adapt quickly and effectively to changing plans and priorities of the department.

Technical Skills and Competencies:

(Mandatory) Has experience and knowledge of coding in SQL (MS SQL Server / MySQL)
(Mandatory) Has experience and knowledge of coding in SQL (MS SQL Server / MySQL)
Understands and knows machine learning algorithms.
Performs end-to-end analytics that include data analysis, cleansing, ETL with Python, modelling, development, testing, and implementation
Knows how to do large scale data mining (multi-million row data sets), reporting and knowledge discovery.
Demonstrates strong Excel capabilities, with pivot tables, data tables, excel functions and scenario modelling.
Knows how to work with VBA in EXCEL.

Customer Focus (Core)

Ability to consistently place high value on customers and all issues related to customer.
Ability to anticipate customer needs, explore all options and develop appropriate reporting solutions, policies and procedures.
Ability to keep customers requirements and feedback at the base of all analytics related activities.
Required to maintain high confidentiality with sensitive information and data and display integrity.

Analytical Thinking:

Ability to analyze available data and reports to gain a better understanding of issues/concerns impacting business.
Ability to analyze and interpret stakeholder requests and identify their operational requirements accurately.
Ability to look beyond the obvious solutions and ways of working and create better reports or more efficient ways of reporting.

Influencing & Interpersonal Skills:

Ability to build and sustain relationships with (internal and external) stakeholders and influence them on decisions impacting the performance of your team.
Ability to influence stakeholders a decisions based on one s own presentation of data either verbally or through dashboards during meetings.

EDUCATION & EXPERIENCE REQUIRED:

Education: