Gaurav Tiwari, Developer in London, United Kingdom
Gaurav is available for hire
Hire Gaurav

Gaurav Tiwari

Verified Expert  in Engineering

Bio

Gaurav has 8+ years of experience developing data analytics solutions, leading analytics and engineering teams, and building data-driven cultures at the enterprise level. He specializes in ETL, reporting, BI, and analytics. Gaurav currently leads an engineering team at Spotify that's focused on growing its product userbase. He has also worked and led analytical teams at Facebook, Home24, and Lazada.

Portfolio

Spotify
Big Data, Management, Leadership, Team Leadership, Strategy, Data Engineering...
Facebook
SQL, Python 3, Tableau, Management, Technical Leadership, Python...
home24
Python 3, SQL, Redshift, Amazon Web Services (AWS), Amazon Athena, AWS Lambda...

Experience

  • SQL - 10 years
  • Data Analytics - 10 years
  • Tableau - 10 years
  • ETL Development - 8 years
  • Amazon Web Services (AWS) - 6 years
  • Google Data Studio - 6 years
  • Google BigQuery - 6 years
  • Google Cloud Platform (GCP) - 5 years

Availability

Part-time

Preferred Environment

MacOS, Jupyter Notebook, SQL, Tableau, Google Data Studio, Google BigQuery, Microsoft Power BI, Redshift, Amazon Web Services (AWS), Google Cloud Platform (GCP)

The most amazing...

...thing I've done was onboarding an organization of 1,400+ to a centralized, self-service reporting tool (Tableau) with a detailed permission and access model.

Work Experience

Engineering Manager

2021 - PRESENT
Spotify
  • Led a team of six software developers to integrate Spotify with Soundtrap as a bundle product that helps unleash creators to create and share their music seamlessly.
  • Defined the engineering team's overall vision and structure, which led to better clarity around the team's purpose and better collaboration with product and business stakeholders.
  • Developed and executed an organization-wide on-call structure for software developers, which decreased the response time and the on-call-related tasks.
Technologies: Big Data, Management, Leadership, Team Leadership, Strategy, Data Engineering, Data Analytics

Data Analytics Manager

2019 - 2021
Facebook
  • Managed a team of nine data analysts, leveraging my technical expertise and project management skills and providing thought leadership and mentorship for career growth.
  • Defined the vision and roadmap to meet the organization's long-term analytic needs. Liaised with and delivered solutions to meet stakeholder needs for business monitoring, insight discovery, and automation across the globe.
  • Built a culture of data-driven decision-making by providing analytical and prescriptive solutions to the organization.
Technologies: SQL, Python 3, Tableau, Management, Technical Leadership, Python, Mentorship & Coaching, Roadmaps, Business Intelligence (BI), Data Engineering, Data Analytics, Databases

Data Engineer

2015 - 2019
home24
  • Developed the marketing data warehouse that enabled marketing teams to connect with and build a customer journey over multiple channels and create metrics that justified the investment. I built the warehouse using R, SQL, and AWS.
  • Built a product recommendation system based on product images to recommend products with similar color characteristics. This led to a 4% increase in the overall conversion rate.
  • Strategized and implemented the company-wide rollout of a centralized self-serve reporting tool (Tableau).
  • Served as the BI lead to onboard 1,400+ employees to the Tableau server. This included developing a detailed permissions and access model to enable a culture of self-serve analytics.
Technologies: Python 3, SQL, Redshift, Amazon Web Services (AWS), Amazon Athena, AWS Lambda, AWS Step Functions, Tableau, Tableau Server, Looker, Python, Data Warehousing, R, Recommendation Systems, User Permissions, Business Intelligence (BI), Data Engineering, Customer Journeys, Attribution Modeling, Data Analytics

Senior Business Intelligence Analyst

2014 - 2015
Lazada
  • Developed price benchmarking scrapers in Python to enable price comparisons of Lazada products with competitors.
  • Created multiple VBA macros to automate daily and weekly reporting on data-heavy workflows, such as weekly communication to business stakeholders and executive reporting.
  • Implemented an organization-wide transition of the ETL workflow from manual to automated, using Alteryx as a complete ETL tool. The transition led to overall gains in efficiency and accuracy.
Technologies: Amazon Web Services (AWS), Big Data, SQL, Excel VBA, Microsoft Power BI, Alteryx, Tableau, DAX, Business Intelligence (BI), Python, ETL, Data Analytics, ETL Development

Experience

Customer Journey Analytics Attribution Model

While serving as a data engineer at home24, I collaborated with the data scientist and built a customer journey attribution model in R. The model was used to create a customer journey for a user who came to home24. Once the customer converted, the model assigned a revenue share to the multiple marketing channels that led to the overall conversion.

The model was complex, and the business multipliers from stakeholders for channel share attribution were set up in AWS using Lambda. The model ran daily as part of the daily revenue calculation and was part of the AWS-based data platform.

Calculating Recommendations Based on Product Images

https://drive.google.com/file/d/1sxrUCD_Zis76y655tyjyCDj2oKbs0fGM/view?usp=sharing
As part of the data engineering team at home24, I worked with a team to develop a recommendation system that utilized product images and generated recommendations for new products that the user might like given the color similarity. This recommendation system led to an overall increase of 10% in the CTR and 4% in the conversion rate.

Education

2013 - 2014

Master's Degree in Information Systems

Singapore Management University - Singapore

2008 - 2012

Bachelor's Degree in Electrical Engineering

Rajiv Gandhi Technical University - Indore, MP, India

Certifications

NOVEMBER 2020 - PRESENT

Fundamentals of Digital Marketing

Google

NOVEMBER 2020 - PRESENT

Google Analytics Certification

Google

Skills

Tools

Tableau, Microsoft Power BI, MATLAB, ElectricFlow, Amazon Athena, AWS Step Functions, Looker, Google Analytics

Languages

SQL, Python 3, R, Excel VBA, Python

Paradigms

ETL, Business Intelligence (BI), Management

Platforms

Amazon Web Services (AWS), Jupyter Notebook, MacOS, Google Cloud Platform (GCP), AWS Lambda, Alteryx

Storage

Redshift, Databases, PostgreSQL

Other

Google Data Studio, Google BigQuery, ETL Development, Data Analytics, Information Systems, Big Data, Big Data Architecture, Business Strategy, System Design, Control Systems, Leadership, Team Leadership, Strategy, Technical Leadership, Recommendation Systems, Tableau Server, DAX, Digital Marketing, Mentorship & Coaching, Data Warehousing, User Permissions, Roadmaps, Data Engineering, Customer Journeys, Attribution Modeling, Data Build Tool (dbt)

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring