Data Analyst

Tech Mahindra; Mumbai; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Tech Mahindra is seeking an Analyst - BI Analytics to conduct statistical analysis and highlight concerns in contact centre parameters. You will provide analytics support to stakeholders and manage end-to-end BI activities, including data cleansing, ETL, and modelling.

The role requires knowledge of SQL, R, Python, ML, NLP, Excel and VBA, with experience in MS SQL Server and MySQL. Graduation is mandatory, with a preference for post graduate quantitative studies.

Qualifications

• Graduation is required.
• Post Graduation in statistics, mathematics, etc. preferred.
• Minimum of 2 years’ experience, at least 1 year in data analytics.

Responsibilities

• Conduct statistical analysis and highlight areas of concern in contact centre parameters.
• Translate data into insights and business strategies for stakeholders.
• Participate in modelling framework, data requirements, and variable creation; coordinate model implementation.
• Develop business insights and create PowerPoint presentations for management.
• Manage end-to-end BI activities including data analysis, cleansing, ETL, modelling, testing and deployment.

Skills

SQL

R

Python

ML

NLP

Excel

VBA

Education

Graduation

Post Graduation in quantitative field

Tools

MS SQL Server

MySQL

PowerPoint

Job description

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:

I. To conduct statistical analysis and highlight areas of concerns 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 concerns 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.

II. 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.

III. 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) Understands and knows statistical analysis using tools and programming languages - R and Python (Preferred).
• (Mandatory) Understands and knows machine learning algorithms.Performs end-to-end analytics that include data analysis, cleansing, ETL with Python, modelling, development, testing, and implementation.[MG1]
• (Preferred) Knows web scraping with Python.
• (Preferred) Knowledge of NLP algorithms to work on text data.[MG2]
• 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[MG3]

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 decisions based on one’s own presentation of data either verbally or through dashboards during meetings.

EDUCATION & EXPERIENCE REQUIRED:

Education

• (Minimum) Graduation[MG4]
• (Preferred) Post Graduation in a quantitative field such as statistics, mathematics, etc.[MG5] [MG6]

Experience

• Minimum of 2 years’ experience of which at least 1 years should be in a data analytics related role.

[MG1]Exploratory Data Analysis (EDA), Feature Selection, Feature Engineering, Dimension Reduction

[MG2]Text Pre-Processing, EDA, Stemming, Stop Word

• [MG3]Knowledge of creating project plan, test plan and performing testing
• Capability of creating Power Point presentation and Business Report for sharing the analytical findings
• Ability to learn new technologies.

[MG4](Preferred Computer Science Degree Programs such as BCA, B.Sc. BE, B. Tech.)

[MG5]Fields such as Statistics, Mathematics, Computer Science, Computer Engineering