Senior Business Analyst

*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

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:

• (Minimum) Graduation

• Preferred) Post Graduation in a quantitative field such as statistics, mathematics, etc.

Experience:

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

TO BOOK YOUR INTERVIEW drop your updated resume on my WHATSAPP [phone removed]