Product Analyst

Role - Senior Executive Analytics (BI)

Overview of job -

Our Client is the world’s largest media investment company and are a part of WPP. In fact, we are responsible for one in every three ads you see globally. We are currently looking for a Senior Executive Analytics to join us. In this role, you will be responsible for a massive opportunity to build and be a part of largest performance marketing setup APAC is committed to fostering a culture of diversity and inclusion. Our people are our strength, so we respect and nurture their individual talent and potential.

Reporting of the role - This role reports to the Director - Analytics.

3 best things about the job:

1. Responsible for data & analytics projects and developing data strategies by diving into data and extrapolating insights and providing guidance to clients

2. Build and be a part of a dynamic team

3. Being part of a global organisations with rapid growth opportunities

Responsibilities of the role:

• Design and build Visualization, Dashboard and reports for both Internal and external clients using Tableau, Power BI, Datorama or R Shiny/Python, SQL, Alteryx.

• Work with large data sets via hands-on data processing to produce structured data sets for analysis.

• Good to Have - Build Marketing-Mix and Multi-Touch attribution models using a range of tools, including free and paid.

What you will need:

• Degree in Mathematics, Statistics, Economics, Engineering, Data Science, Computer Science, or quantitative field.

• Proficiency in one or more coding languages – preferred languages: Python, R

• Proficiency in one or more Visualization Tools – Tableau, Datorama, Power BI

• Proficiency in using SQL.

• Minimum 3 years of experience in Marketing/Data Analytics or related field with hands-on experience in building Marketing-Mix and Attribution models is a plus.

About InEvolution

Founded in 2009, InEvolution stands as a beacon of excellence in providing back-office, operations, and customer support services globally. Our team, comprising highly skilled professionals, is committed to delivering top-notch quality services while ensuring cost efficiency. At InEvolution, we value innovation, quality, and our team's growth and development.

About the Role

• Work on building, processing and transferring data and dashboards from existing Domo Platform to Power BI Platform.
• Audit existing data systems and deployments and identify errors or areas for improvement.
• Utilize Power BI to build interactive and visually appealing dashboards and reports.
• Build Data Documentation and explanation on parameters, filters, models and relationships used in the dashboards.
• Review existing SQL data sources to improve, connect and integrate it effortlessly with Power BI.
• Create, test and deploy Power BI scripts, as well as execute efficient migration practices.
• Work closely with the current analytics team, to define requirements, migration steps and, have an open and transparent communication with the team on reviewing the migrated reports and data sources for successful outcomes.
• Ensure all dashboards and data sources are thoroughly reviewed by the team before publishing to the production environment.
• Convert business needs into technical specifications and establish a timeline for job completion.

Requirements & Skills:

• 2+ years of experience in using Power BI to run DAX queries and other advanced interactive functions.
• 2+ years of experience with Data Analysis and Data Visualization tools.
• 1+ years of experience working with Relational Databases and building SQL queries.
• Familiarity with Data Collection, Cleaning and Transformation processes.
• Attention to detail and the ability to work with complex datasets.

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.

Roles and Responsibilities

• Managing available resources such as hardware, data, and personnel so that deadlines are met.
• Analyzing the ML and Deep Learning algorithms that could be used to solve a given problem and ranking them by their success probabilities
• Exploring data to gain an understanding of it, then identifying differences in data distribution that could affect performance when deploying the model in the real world
• Defining validation framework and establish a process to ensure acceptable data quality criteria are met
• Supervising the data acquisition and partnership roadmaps to create stronger product for our customers.
• Defining feature engineering process to ensure usage of meaningful features given the business constraints which may vary by market
• Device self-learning strategies through analysis of errors from the models
• Understand business issues and context, devise a framework for solving unstructured problems and articulate clear and actionable solutions underpinned by analytics.
• Manage multiple projects simultaneously while demonstrating business leadership to collaborate & coordinate with different functions to deliver the solutions in a timely, efficient and effective manner.
• Manage project resources optimally to deliver projects on time; drive innovation using residual resources to create strong solution pipeline; provide direction, coaching & training, feedbacks to project team members to enhance performance, support development and encourage value aligned behaviour of the project team members; Provide inputs for periodic performance appraisal of project team members.

Preferred Technical & Professional expertise

• Undergraduate Degree in Computer Science / Engineering / Mathematics / Statistics / economics or other quantitative fields
• At least 2+ years of experience of managing Data Science projects with specializations in Machine Learning
• In-depth knowledge of cloud analytics tools.
• Able to drive Python Code optimization; ability review codes and provide inputs to improve the quality of codes
• Ability to evaluate hardware selection for running ML models for optimal performance
• Up to date with Python libraries and versions for machine learning; Extensive hands-on experience with Regressors; Experience working with data pipelines.
• Deep knowledge of math, probability, statistics and algorithms; Working knowledge of Supervised Learning, Adversarial Learning and Unsupervised learning
• Deep analytical thinking with excellent problem-solving abilities
• Strong verbal and written communication skills with a proven ability to work with all levels of management; effective interpersonal and influencing skills.
• Ability to manage a project team through effectively allocation of tasks, anticipating risks and setting realistic timelines for managing the expectations of key stakeholders
• Strong organizational skills and an ability to balance and handle multiple concurrent tasks and/or issues simultaneously.
• Ensure that the project team understand and abide by compliance framework for policies, data, systems etc. as per group, region and local standards

We are looking for a Senior Data Analyst who will support our product, sales, leadership, and marketing teams with data collection and organization of data in order to draw conclusions, make predictions, and drive informed decision making.

• The ideal candidate is adept at using large data sets to find opportunities for product and marketing optimization and using data models to test the effectiveness of different courses of action.
• Not just that, you also understand how to clean and organize data for complete analysis and calculations using spreadsheets, SQL Python, and R programming.
• Visualizing and presenting data findings in dashboards, presentations and commonly used visualization platforms must be your strength.

SKILLS YOU MUST HAVE:

• Data Cleansing, Data Analysis, Data Visualization (DataViz), SQL Questioning, Decision-Making, Problem Solving, Data Collection, Data Ethics, Sample Size Determination, Spreadsheet,

RESPONSIBILITIES:

• Work with stakeholders throughout the organization to identify opportunities for leveraging company data to drive business solutions.
• Mine and analyze data from company databases (GOOGLE ANALYTICS, User DB, and 3rd party Marketing Analytics tools) to drive optimization and improvement of product development, marketing techniques, and business strategies.
• Assess the effectiveness and accuracy of new data sources and data gathering techniques.
• Strong understanding of Google Analytics (GA) fundamentals and how to work with raw GA data
• Automate custom data fetching from Google Analytics dashboard to excel sheet and other primary and secondary sources
• Work with complex SQL queries
• Work with Big Query with GA integration to extract data
• Preparing final analysis reports for the stakeholders to understand the data-analysis steps, enabling them to take important decisions based on various facts and trends.
• Filter Data by reviewing reports and performance indicators to identify and correct code problems
• Developing and maintaining databases, data systems reorganizing data in a readable format
• Using statistical tools to identify, analyze, and interpret patterns and trends in complex data sets could be helpful for the diagnosis and prediction
• Assign a numerical value to essential business functions so that business performance can be assessed and compared over periods of time.
• Use predictive modeling to increase and optimize customer experiences, revenue generation, ad targeting, and other business outcomes.
• Develop company A/B testing framework and test model quality.
• Coordinate with different functional teams to implement models and monitor outcomes.
• Develop processes and tools to monitor and analyze model performance and data accuracy.
• Understanding of statistical concepts like Statistical significance, t-test, and z-test for AB testing
• Performing analysis to assess quality and meaning of data
• Preparing reports for the management stating trends, patterns, and predictions using relevant data
• Working with programmers, engineers, and management heads to identify process improvement opportunities, propose system modifications, and devise data governance strategies.
• Robust understanding of Mix panel and Amplitude

Skill requirement:

• 6-8 years of experience in database management and a strong understanding of Google Analytics
• Strong mathematical skills to help collect, measure, organize, and analyze data
• Experience using statistical computer languages (R, Python, MATLAB, SQL, etc.) to manipulate data and draw insights from large data sets.
• Experience analyzing data from 3rd party providers: Google Analytics, Site Catalyst, Coremetrics, Adwords, Crimson Hexagon, Facebook Insights, etc.
• Technical proficiency regarding database design development, data models, techniques for data mining, and segmentation.
• Knowledge of a variety of machine learning techniques (clustering, decision tree learning, artificial neural networks, etc.) and their real-world advantages/drawbacks.
• Knowledge of advanced statistical techniques and concepts (regression, properties of distributions, statistical tests, and proper usage, etc.) and experience with applications.
• Knowledge of data visualization software like Tableau
• Knowledge of how to create and apply the most accurate algorithms to datasets in order to find solutions
• Accuracy and attention to detail
• Adept at queries, advanced excel management, writing reports, and making presentations
• Team-working skills
• Verbal and Written communication skills
• Proven working experience in data analysis

Job Title: Power BI Developer(Onsite)

Location: Park Centra, Sec 30, Gurgaon

CTC:        8 LPA

Time:       1:00 PM - 10:00 PM

Must Have Skills: 

• Power BI Desktop Software
• Dax Queries
• Data modeling
• Row-level security
• Visualizations
• Data Transformations and filtering
• SSAS and SQL

Job description:

We are looking for a PBI Analytics Lead responsible for efficient Data Visualization/ DAX Queries and Data Modeling. The candidate will work on creating complex Power BI reports. He will be involved in creating complex M, Dax Queries and working on data modeling, Row-level security, Visualizations, Data Transformations, and filtering. He will be closely working with the client team to provide solutions and suggestions on Power BI.

Roles and Responsibilities:

• Accurate, intuitive, and aesthetic Visual Display of Quantitative Information: We generate data, information, and insights through our business, product, brand, research, and talent teams. You would assist in transforming this data into visualizations that represent easy-to-consume visual summaries, dashboards and storyboards. Every graph tells a story.
• Understanding Data: You would be performing and documenting data analysis, data validation, and data mapping/design. You would be mining large datasets to determine its characteristics and select appropriate visualizations.
• Project Owner: You would develop, maintain, and manage advanced reporting, analytics, dashboards and other BI solutions, and would be continuously reviewing and improving existing systems and collaborating with teams to integrate new systems. You would also contribute to the overall data analytics strategy by knowledge sharing and mentoring end users.
• Perform ongoing maintenance & production of Management dashboards, data flows, and automated reporting.
• Manage upstream and downstream impact of all changes on automated reporting/dashboards
• Independently apply problem-solving ability to identify meaningful insights to business
• Identify automation opportunities and work with a wide range of stakeholders to implement the same.
• The ability and self-confidence to work independently and increase the scope of the service line

Requirements: 

• 3+ years of work experience as an Analytics Lead / Senior Analyst / Sr. PBI Developer.
• Sound understanding and knowledge of PBI Visualization and Data Modeling with DAX queries
• Experience in leading and mentoring a small team.