Prerna Pedamkar
Lead Marketing Data Analyst (on Visa Sponsorship) @THG
Signup · Get unlimited contacts
WORK HISTORY
Lead Marketing Data Analyst (on Visa Sponsorship) @THG
Manchester, GB
Delivering data-driven insights across THG Beauty (Lookfantastic, Cult Beauty, Dermstore, ESPA and other Beauty brands - UK & US)as part of the Beauty Data Insights team supporting marketing, trade, finance teams, strategic initiatives with structured analysis and actionable insights.• Own end-to-end customer and subscription analytics - tracking KPIs, lifecycle stages (acquisition, retention, LTV), loyalty, premier, recycle scheme performance (cross programme behaviour), cross-site behaviour (Retail vs D2C), site migration behaviour, Brand merger and acquisition analysis, used daily by commercial and marketing teams.• Built and maintained 25 scalable BigQuery/Dataform pipelines for customers & subscription state tracking, MTD KPI reporting, and top performing product, brand, category, and channel identification across beauty sites and apps.• Led in-depth analysis for major commercial events (Black Friday, Cyber Monday, Seasonal Sales, Advent campaigns) and newly launched programmes (Premier Delivery, Loyalty Schemes, Recycle & Sustainability), designed A/B testing and pre/post analysis, delivering insights covering ~£95M revenue,~700K New & Existing Customers directly to Senior Leadership and Finance.• Serve as primary analytics partner for Finance, Trade & Marketing, Paid Media, and Brand & Category teams - translating complex business questions into structured analysis, clear recommendations, and timely delivery of ad hoc requests.• Key contributor in GCP cloud migration - transitioning on-premises SQL sources to Google BigQuery and Dataform, replicating Excel reports in Tableau/Power BI; utilised advanced tooling across SQL, Python, Power BI, Tableau, PostgreSQL and GitHub for version control and code review.• Mentored junior analysts and collaborated with cross-functional teams and third-party vendors to ensure successful delivery of multiple high-impact projects each quarter; contributed to data team best practices and capability building.
EDUCATION
University of Mumbai
Bachelor of Science (B.Sc.), Information Technology
The Manchester Metropolitan University
MSc Business Analytics
ABOUT PRERNA PEDAMKAR
Experienced Data Professional with skills in Business Intelligence, Database/ DW Management, Business/Data Analysis, Business Statistics, Software Development, Support/Service Management, Digital Marketing, Digital Leadership Transformation and Decision making processes.• Experience of live and onsite projects in IT, Telecom Business Services, Depositary Participants Audit, Healthcare, Sales & Marketing, Insurance & Reinsurance, e-Commerce, Retail domains using Agile methodology.• Involved in client communication, analysis, designing, coding, reporting, dashboard development and system documentation.• Technical Consultant to clients in data architecture, data warehousing design & implementation, ETL processes, Data Visualization and Analytics.• Experienced in PowerBI, Microsoft Azure (Azure Data Factory), Power BI Report builder, Tableau, GCP, Google Bigquery, Dataform, Python, Oracle PL-SQL, Microsoft SQL Server T-SQL, MSBI (SSIS, SSAS,SSRS), VB.NET, Microsoft Visual Basic 6.0, Crystal Report 8.5/9, Panorama Necto (BI solution), Organization and task delegation with client interaction.• Currently, skilled worker visa holder - Sponsorship transfer required.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.