Gunjan Dhiman
Brisbane
Summary
Results-driven Data Specialist with 5+ years of experience transforming complex datasets into actionable insights that drive strategic decisions. Proficient in SQL, Power BI, BigQuery, and GCP, with proven expertise in building scalable ETL pipelines, developing interactive dashboards, and collaborating with stakeholders to define requirements, deliver tailored solutions, and ensure robust data governance.
Overview
15
15
years of professional experience
1
1
Certification
Work History
BI Developer/ Data Analyst
Epsilon Retail Media (Former CitrusAd)
10.2021 - Current
- Designed and maintained ETL pipelines and data workflows using GCP (Big Query, Dataflow, Cloud Composer, Cloud Storage), processing large datasets with 99% data accuracy for analytics and reporting.
- Developed and maintained interactive dashboards and reports in Domo and Power BI, enabling stakeholders to make faster, data-driven decisions and improving reporting efficiency by 30%.
- Built and optimized complex SQL queries, resolving data inconsistencies and improving query performance.
- Automated data processing and reporting workflows, cutting manual effort by 35% and accelerating report delivery timelines.
- Monitored key retail media KPIs (ROAS, CTR, conversion) and delivered actionable insights, contributing to a 15% increase in campaign performance.
- Collaborated with cross-functional teams to translate business requirements into scalable data solutions while enforcing data quality and governance, improving overall dataset reliability by 30%.
- Utilize Python for workflow automation, data transformation, advanced data analysis, and integrating multiple data sources, reducing manual effort by 35% and accelerating report delivery timelines while enabling scalable, reliable reporting solutions.
Data Analyst
MVP Studio
09.2020 - 09.2021
- Built and optimized databases and complex SQL queries, ensuring reliable analytics, faster query performance, and accurate data integration across multiple sources to support strategic and operational business needs.
- Developed scalable ETL pipelines using SSIS and designed multidimensional cube structures with SSAS, improving data processing efficiency by 30% while enabling seamless data transformation, cleaning, and aggregation for reporting.
- Created interactive dashboards in Power BI and Tableau using advanced DAX, providing stakeholders with actionable insights, trend analysis, and real-time performance monitoring to support decision-making.
- Deployed reporting solutions to web and SQL servers, automating data updates, standardizing reporting processes, and reducing manual reporting effort by 40%, while maintaining data governance and quality standards.
Operations Analyst
Mex-in's
06.2014 - 06.2019
- Analyzed product performance, customer behavior, and marketing initiatives to identify trends, optimize strategies, and support data-driven decision-making.
- Monitored and reported on customer acquisition and retention metrics, contributing to a 40% growth in new customers and 90% increase in returning customers.
- Prepared financial and operational reports, evaluating performance and providing actionable insights to improve efficiency and drive business outcome.
Associate Operations Analyst
Customer Support Finance
01.2011 - 06.2012
- Supported client onboarding, financial operations, and reporting, ensuring accurate and timely processing of transactions and compliance with organizational standards.
- Managed cross-departmental processes using SAP and CRM systems, improving workflow efficiency and data consistency.
- Analyzed transactional data using Excel and SQL, generating actionable insights to support decision-making and operational improvements.
Education
Master of Science - Information Systems
Central Queensland University
11.2014
Master of Technology - Applied Geophysics
Kurukshetra University
Kurukshetra06.2011
Bachelor of Science - Electronics
Kurukshetra University
04.2008
Skills
- Data Analytics: SQL, BigQuery, Snowflake, Data Modeling, DAX, Python
- Cloud & ETL: GCP (Cloud Storage, Dataflow, BigQuery), SSIS, SSAS, Matillion
- Visualization Tools: Power BI, Tableau, Domo, Looker
- Methodologies: Agile, SDLC, Operational Reporting, Data Storytelling
- Other Tools: Excel (Pivot Tables, VLOOKUP), JIRA, Git
Certification
- Business Intelligence Expert Certification - Industry Connect
- Microsoft Power BI certification - Udemy
Timeline
BI Developer/ Data Analyst
Epsilon Retail Media (Former CitrusAd)
10.2021 - Current
Data Analyst
MVP Studio
09.2020 - 09.2021
Operations Analyst
Mex-in's
06.2014 - 06.2019
Associate Operations Analyst
Customer Support Finance
01.2011 - 06.2012
Bachelor of Science - Electronics
Kurukshetra University
Master of Science - Information Systems
Central Queensland University
Master of Technology - Applied Geophysics
Kurukshetra University
Similar Profiles
Jeffrey BadgerJeffrey Badger
Sales Director at Epsilon Retail MediaSales Director at Epsilon Retail Media
Jami WilliamsJami Williams
Sales Director, Advertising at Epsilon Retail MediaSales Director, Advertising at Epsilon Retail Media
Jocelyn ChiurcoJocelyn Chiurco
Sr. Sales Director at Epsilon Retail MediaSr. Sales Director at Epsilon Retail Media
Josephine (josie) WillmottJosephine (josie) Willmott
Placement at Southern IML PathologyPlacement at Southern IML Pathology
JU HYUN LEEJU HYUN LEE
Kindergarten Teacher at KidsworldKindergarten Teacher at Kidsworld