Open to opportunities

Anshika Pandey

@anshikapandey3

Message

Data Analyst specializing in Power BI dashboards and SQL/Python automation for stakeholder-ready insights.

Australia

Message

What I'm looking for

I’m looking for a role where I can build impactful Power BI dashboards and automate SQL/Python data pipelines with strong data validation. I want cross-functional work that turns messy data into actionable KPIs and measurable business outcomes.

I’m a Data Analyst who turns raw data into stakeholder-ready insights, with hands-on experience building BI dashboards, SQL/Python pipelines, and automated data validation across SaaS, retail, and social media analytics. I focus on translating complex data into clear KPIs, trends, and decisions people can act on.

In my most recent role at DashboardWorx, I built and shipped production Power BI dashboards for retail sales, user analytics, and LinkedIn engagement, using DAX and star-schema data modelling to track 10+ KPIs. I also designed SQL-based ETL pipelines in BigQuery to convert GA4 exports into analytics-ready datasets for a 500+ user SaaS client—cutting weekly reporting effort by 20%—and automated GA4 processing with reusable scripts and validation checks to reduce data-quality incidents to near zero.

At BrandRadar, I built end-to-end brand-monitoring analytics pipelines, transforming raw JSON/social data into structured datasets for sentiment, themes, and crisis detection. I’ve also supported recruitment analytics as an HR Recruiter / Talent Intelligence Analyst, analyzing hiring trends and building Excel dashboards for leadership visibility into pipeline performance and bottlenecks.

Experience

Work history, roles, and key accomplishments

Data Analytics Intern

BrandRadar

Apr 2026 - Jun 2026 (2 months)

Built end-to-end analytics pipelines and dashboards for brand monitoring, transforming raw JSON/social data into structured datasets. Implemented Python-based ETL workflows (including schema standardisation) to extract sentiment, themes, and crisis signals, and supported reporting for 20+ tracked brands.

Python ETL Sentiment Analysis Dashboard Development

Data and Insights Analyst

DashboardWorx

Jan 2026 - Mar 2026 (2 months)

Built and shipped production Power BI dashboards for retail sales, user analytics, and LinkedIn engagement, tracking 10+ KPIs with DAX and star-schema data modelling. Designed BigQuery SQL ETL pipelines for GA4 reporting automation and implemented reusable SQL validation to remove manual data-cleaning.

Power BI DAX Star Schemas SQL BigQuery GA4 ETL Data Validation Report Automation KPI Tracking Data Visualization Power Query

HR Recruiter (Talent Intelligence)

YNG Media

Jun 2023 - Dec 2023 (6 months)

Analysed candidate and hiring data to identify trends and improve hiring efficiency, supporting stakeholder weekly visibility into recruitment performance. Built and maintained Excel dashboards and cleaned/validated candidate databases for accurate hiring reporting.

Excel Data Analysis Reporting Time To Fill Analysis Data Cleaning Data Validation

Talent Acquisition Intern

Workfall India

May 2022 - Sep 2022 (4 months)

Managed full-cycle recruitment across multiple countries and maintained an applicant database with reporting on sourcing channels. Ran social media sourcing campaigns and tracked engagement metrics to identify the highest-converting candidate channels.

Full cycle Recruitment Recruitment Reporting Social media sourcing Engagement Metrics