Business intelligence, data analytics and engineering professional with 15 years of experience across consultant, team lead, and leadership positions in the public, financial services, infrastructure, and telecom sectors. Relied on as a key advisor, delivering actionable insights via data analytics and reporting.

Dhruv Pandey

Business intelligence, data analytics and engineering professional with 15 years of experience across consultant, team lead, and leadership positions in the public, financial services, infrastructure, and telecom sectors. Relied on as a key advisor, delivering actionable insights via data analytics and reporting.

Available to hire

Business intelligence, data analytics and engineering professional with 15 years of experience across consultant, team lead, and leadership positions in the public, financial services, infrastructure, and telecom sectors. Relied on as a key advisor, delivering actionable insights via data analytics and reporting.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate

Language

English
Fluent

Work Experience

Data Analyst I at Alpha Financial Management Company
August 1, 2025 - November 6, 2025
Working on a major private pensions data transformation project; extracting data from various sources; transforming data to meet business logic and standards; writing complex SQL queries; creating stored procedures, views and functions; analysing and reporting large datasets to identify trends, anomalies, and insights using Python and Power BI.
BI and Data Architect at The National Lottery (CF)
March 1, 2025 - March 1, 2025
Redesigned and recreated the Power BI driven reporting layer; migrated data from Oracle HCM, Oracle ERP, Metabase, Salesforce, ClickHouse, GA4 and Google Big Query to AWS S3 and Athena using Python; remodelled upstream data models, DAX calculations and Power Queries; introduced NLP-driven Q&A visual features and Copilot capabilities; managed end-to-end stakeholder management, requirements gathering, agile delivery of Power BI reports.
Reporting Lead - Performance Analytics at Social Security Scotland
October 1, 2024 - October 1, 2024
Operational data reporting; revamped BI layer; migrated existing reporting to Power BI and AWS Quicksight; web application data reporting including user journey KPIs across platforms using Google Analytics, GTM and Power BI; data modelling and data reporting for internal projects including user calls and chat data; DAMA and DCAM assessments; cross-functional collaboration with product and design teams.
Data Analytics Reporting Lead at Zego Insurance
August 1, 2022 - August 1, 2022
Created BI setup from scratch; automated Snowflake, DBT, Python, Tableau driven reporting; implemented Tableau as the organisation-wide BI platform by migrating from Power BI and Looker; led migration from AWS Redshift to Snowflake; hired and led a team of 6 analysts and data engineers; focused on data ingestion and data modelling for internal stakeholders and regulatory authorities.
Team Lead, Data Engineering at Bigtincan
November 1, 2021 - November 1, 2021
Led the data engineering and reporting vertical in the R&D team for a sales enablement firm.
MI and Data Reporting at JP Morgan Chase
August 1, 2021 - August 1, 2021
Part of the Credit Risk team in the Corporate Technology vertical; MI reporting, analysis and visualization using Tableau and QlikView; dealt with data from SQL, Oracle and Hadoop; ensured data quality; led projects including credit risk data, stress scenarios, incident management, change management and data lake utility data; built relationships across teams to deliver MI solutions; established an MI team of 2 analysts.
MI Transformation Consultant (Contract) at UK Government (DFID)
July 1, 2018 - July 1, 2018
MI, DA and data visualization consultant; created analytics pipeline and MI dashboards from data in a procurement IT tool; gathered requirements across multiple teams; designed and delivered MI solutions; automated data collection; prepared data models and KPIs across dashboards; established analytics practice in procurement and delivery value chain.
Senior BI Analyst and Manager at Cisco
May 1, 2017 - May 1, 2017
Onsite team lead and consultant in Strategy and Planning, Data Science and Analytics; led a global team; implemented Tableau as Cisco EMEA data reporting solution; delivered KPI and performance dashboards and market intelligence; managed data sets across sales, products, partners, customers, HR, finance; supported senior management decisions; grew accounts and team.
Analyst / Senior Analyst / Manager at Evalueserve
June 1, 2013 - June 1, 2013
Led research, market sizing, data visualization and insights; managed a team of 15-25 analysts; delivered client engagements; won multiple awards.

Education

Mechanical and Automation Engineer at Northern India Engineering College, GGSIP University
January 11, 2030 - January 1, 2008

Qualifications

Snowflake Data Analyst
January 11, 2030 - November 6, 2025
DBT
January 11, 2030 - November 6, 2025
AWS CCP
January 11, 2030 - November 6, 2025
Agile and Scrum certified
January 11, 2030 - November 6, 2025

Industry Experience

Financial Services, Government, Telecommunications, Software & Internet, Professional Services