Lee Surkis

• End-to-end dashboard development, from defining KPIs and designing wireframes to building reports (Looker/Power BI) with a focus on insights to inform growth and marketing strategies

• Create optimized reporting pipelines (SQL), ensuring clean, well-structured data tables that can be easily used by cross functional teams (Growth/Marketing/Product)

• Collaborate closely with stakeholders in GTM, data engineering and product teams to identify key business metrics, ensuring reports drive actionable insights. Hold training sessions after completion of projects.

• Led data validation and troubleshooting, ensuring accuracy and consistency across dashboards used to track marketing performance and customer behaviours.

• Conduct ad-hoc analyses to identify trends, diagnose issues, and support strategic decision-making.

• Proposed and developed a clustering model as a solution to automate and simplify the hiring strategy for new employees in one business area. Built and maintained the clustering algorithm using Python (Databricks) and visualized results on a map (geo-spatial data) using Spotfire to help identify areas with large resourcing gaps globally.

• Automated a monthly report developed for C-suite executive stakeholders including 19 KPIs in 7 different business areas, saving each department up to 15 hours per month.

• Identified data sources (these varied from excel sheets, Sharepoint lists, tables in the data warehouse, existing dashboards), and built new data warehouse views using SQL in the Snowflake to store all the information in one place. I then built an appropriate visualization for each KPI in a reporting dashboard.

• Provided knowledge sharing session to other employees on analysing and visualising geospatial data (focused on data functions applied to Polygons or Longitude and Latitude)

• Deep-dive analysis to understand top customer detractor.

• Identified an additional issue impacting customer satisfaction, previously not recognised.

• Highlighted biggest areas for improvement and presented a detailed action plan to senior leadership to inform decisions.

• Defined metrics which were measured and monitored weekly.

• Following our recommendations, reduced customer bad ratings by 61%, benefiting both Glovo and groceries partners.

• Retention analysis to understand churn and revenue.

• Develop weekly and monthly reports for Q-commerce partners using SQL and Looker.

• Create and maintain dashboards for different teams within Q-commerce for analytics needs such as; understanding city coverage, tracking operations KPIs, in-stock metrics for DarkStores.

• Create reports for quarterly business status updates to global team by extracting data and drawing insights.