Data Analyst

Qualifications & Experience:

▪ 2 - 4 years overall experience in ETLs, data pipeline, Data Warehouse development and database design

▪ Software solution development using Hadoop Technologies such as MapReduce, Hive, Spark, Kafka, Yarn/Mesos etc.

▪ Expert in SQL, worked on advanced SQL for at least 2+ years

▪ Good development skills in Java, Python or other languages

▪ Experience with EMR, S3

▪ Knowledge and exposure to BI applications, e.g. Tableau, Qlikview

▪ Comfortable working in an agile environment

Exp-10 Years

Location Mumbai

Ready to work from Office

Permanent role

Role

Business Analytics/Data Analytics Lead

• Enable Business Transformation with Data Analytics by working with our big clients in major sectors such as Oil & Gas, Manufacturing, Retail, BFSI
• Partner business teams to understand the business area, work with the team to evolve and define the business problems, use-cases, translate the same into an analytical problem, design solution approach, define ROI, help execute to deliver relevant insights that lead to actions and business value.
• Connect business requirements with Technology solutions and be able to determine feasibility, technical gaps, size etc.
• Be able to define a project plan for the identified solutions, help hire and train technical resources, be the glue between Business team and the technical/implementation team
• Be proficient at solving ad hoc business problems, innovating on potential future solutions, and working with technology partners to build solutions and/or creative approaches to solve ‘one of a kind’ problems.
• Embed tested solutions to make them business as usual and help quantify value benefits from analytics.
• Be creative and a committed problem-solver using Data and Advanced analytics skill alongside leadership and direct engagement of business leaders.
• Be a trusted advisor to the client CxOs/leadership team in evangelising the use of Data & Data Science in business decisions. Help accelerate the organisation journey to become data driven.
• Provide input during development and implementation phases, including formulation and definition of systems scope, objectives and necessary system enhancements for complex, high-impact projects
• Work with development and testing teams to deliver solutions and support UAT
• Identify and communicate risks and impacts and propose risk mitigation options, considering business implications of the application of technology to the current business environment.

Qualifications

• 10+ years experience in technology/project management/product management/solution delivery
• 4+ years of relevant work experience in roles partnering in Data Analytics related use-cases and solutions resulting in significant cost, productivity and/or quality gains for the business
• Bachelors degree in a relevant technical field (Computer Science, IT, Statistics, Business Analytics or similar). MBA preferred

·       Experience of specifying and writing business requirements and suggesting appropriate solutions in the field of Data Analytics/AI

• Prior industry experience in defining/creating Data Analytics solutions  in one or more of Oil & Gas, BFSI, Manufacturing, Retail sectors.
• Strong preference for experience in setting up & managing analytics / data products / platforms & leading change management.
• Be able to articulate and have a keen eye on the value that Data Analytics, AI, Machine Learning, Data Lake/Catalogue can bring to organizations
• Ability to communicate complex quantitative insights in a precise, and actionable manner
• Strong communication skills and ability to work with peers & senior stakeholders demonstrating strong vertical and lateral influence.
• Working knowledge of Analytics tools such as PowerBI, Tableau, AI modelling such as Regression, Classification, and Time Series Problems.
• Experience building insights from analytics & telling data stories
• Passion for empirical research and for answering hard questions with data

Minimum of 8 years of experience of which, 4 years should be of applied data mining

experience in disciplines such as Call Centre Metrics.

 Strong experience in advanced statistics and analytics including segmentation, modelling, regression, forecasting etc.

 Experience with leading and managing large teams.

 Demonstrated pattern of success in using advanced quantitative analytic methods to solve business problems.

 Demonstrated experience with Business Intelligence/Data Mining tools to work with

data, investigate anomalies, construct data sets, and build models.

 Critical to share details on projects undertaken (preferably on telecom industry)

specifically through analysis from CRM.

Required Experience

· 3+ years of relevant technical experience as a data analyst role

· Intermediate / expert skills with SQL and basic statistics

· Experience in Advance SQL

· Python programming- Added advantage

· Strong problem solving and structuring skills

· Automation in connecting various sources to the data and representing it through various dashboards

· Excellent with Numbers and communicate data points through various reports/templates

· Ability to communicate effectively internally and outside Data Analytics team

· Proactively take up work responsibilities and take adhocs as and when needed

· Ability and desire to take ownership of and initiative for analysis; from requirements clarification to deliverable

· Strong technical communication skills; both written and verbal

· Ability to understand and articulate the "big picture" and simplify complex ideas

· Ability to identify and learn applicable new techniques independently as needed

· Must have worked with various Databases (Relational and Non-Relational) and ETL processes

· Must have experience in handling large volume and data and adhere to optimization and performance standards

· Should have the ability to analyse and provide relationship views of the data from different angles

· Must have excellent Communication skills (written and oral).

· Knowing Data Science is an added advantage

Required Skills

MYSQL, Advanced Excel, Tableau, Reporting and dashboards, MS office, VBA, Analytical skills

Preferred Experience

· Strong understanding of relational database MY SQL etc.

· Prior experience working remotely full-time

· Prior Experience working in Advance SQL

· Experience with one or more BI tools, such as Superset, Tableau etc.

· High level of logical and mathematical ability in Problem Solving

Specialism- Advance Analytics, Data Science, regression, forecasting, analytics, SQL, R, python, decision tree, random forest, SAS, clustering classification

Senior Analytics Consultant- Responsibilities

• Understand business problem and requirements by building domain knowledge and translate to data science problem
• Conceptualize and design cutting edge data science solution to solve the data science problem, apply design thinking concepts
• Identify the right algorithms , tech stack , sample outputs required to efficiently adder the end need
• Prototype and experiment the solution to successfully demonstrate the value
  Independently or with support from team execute the conceptualized solution as per plan by following project management guidelines
• Present the results to internal and client stakeholder in an easy to understand manner with great story telling, story boarding, insights and visualization
• Help build overall data science capability for eClerx through support in pilots, pre sales pitches, product development , practice development initiatives

• Must Have 3-4 Experience in SSIS, Mysql
• Good Experience in Tableau
• Experience in SQL Server.
• 1+ year of Experience in Tableau
• Knowledge of ETL Tool
• Knowledge of Dataware Housing