About Me

Data Analyst with 2+ years of experience building automated ETL pipelines, developing analytics dashboards, and delivering actionable insights. Expertise in Python, SQL, and BigQuery with a strong background in digital marketing analytics (including paid social, paid search, and e-commerce).

Job Desk

Data Engineering & ETL Development

• Engineered end-to-end in-house ELT/ETL pipeline combining Airbyte, Cloud Functions, and BigQuery to ingest ad platform data, perform custom transformations, and enable automated reporting, cutting costs 50% ($82/month). 

• Performed monitoring and data validation checks in pipelines to achieve 99.9% data accuracy, minimize failures, and ensure reliable downstream analytics and reporting.  

• Optimized Cloud Functions orchestration logic for faster execution, better retry handling, and cost-efficient resource usage during high-volume ad data ingestion.

Reporting & Dashboard Development

• Automated SQL-driven reporting in Google Sheets via complex queries (CTEs, window functions, joins) connected directly to BigQuery, eliminating manual effort and reducing reporting time from 2 days to automated daily access for 50+ active campaigns.

• Built and maintained 10+ interactive Looker Studio dashboards integrating multiple data sources (ad platforms, GA4, BigQuery, Google Sheets) with daily-updated KPI visibility.

Automation & Process Optimization

• Developed real-time budget monitoring using Google Ads API and Apps Script that auto-pauses campaigns at budget thresholds, achieving 99% budget utilization accuracy and preventing overspend.

• Created automated email alert system using Google Workspace API for critical campaign events (campaign pauses, system errors).

Marketing Analytics & Cross-Functional Collaboration

• Collaborated closely with account managers to implement tracking, define reporting requirements and KPI frameworks aligned with business objectives.

• Performed ad-hoc analysis identifying opportunities that improved ROAS by 61% (mid-tier hotels) and 65% (budget hotels).

• Provided knowledge sharing and training on attribution modeling, tag implementation, BigQuery best practices, and dashboard creation.

Key Achievements

• Cost Reduction: Reduced reporting infrastructure costs by 50% by replacing vendor solutions with custom Python/SQL ETL pipelines.

• Efficiency Gain: Eliminating manual effort and reducing reporting turnaround from 2 days to automated daily updated.

• Budget Optimization: Achieved 99% budget utilization accuracy through real-time monitoring automation, eliminating overspend while maximizing campaign spend.

• Enhanced overall pipeline reliability and data accuracy to 99.9% through proactive validation and error-handling frameworks.

Technical Skills

Programming & Scripting: SQL, Python, JavaScript. 

Data Platforms: Google Cloud Platform.

Analytics Tools: Google Analytics 4, Google Tag Manager, Looker Studio.

Marketing Platforms: Google Ads, Meta Ads, CPAS, TikTok Ads, E-Commerce.