Ashu Vatts

BI Engineer with 3+ years developing and deploying data visualization solutions and knowledge engine interfaces driving adoption and decision-making across e-commerce, fintech, and SaaS. Expert in Tableau, Power BI, Looker Studio, data integration (ETL pipelines, GA4, Meta Ads), data warehousing (BigQuery, AWS Redshift), and secure data governance. Delivered 20% partner activation lift, 15% business growth, and 152+ hours/year automation.

Strong communicator of complex insights through data storytelling.

BI Engineer & Data Analyst - Merca Applied Sciences Inc. - Remote

(2025-04)

• Created real-time Looker Studio dashboards by merging GA4 and Meta Ads data, establishing knowledge engine interfaces that increased team adoption and saved 152+ hours annually by removing ad-hoc reporting.
• Built and managed integrated data pipelines within a unified attribution framework, prioritizing data governance and strict compliance across all information streams.
• Developed BigQuery ML models for customer segmentation to drive personalized recommendations, while improving SQL queries and ETL processes to achieve a 30% reduction in execution time.
• Directed UAT cycles and data quality assurance to uphold security protocols and privacy standards, alongside formalizing governance frameworks and data handling documentation.

BI Engineer & Data Analyst - Midland Microfin Ltd. - Jalandhar, PB

(2023-03 - 2025-04)

• Engineered data warehouse (BigQuery, PostgreSQL) via ETL; maintained Tableau/Power BI dashboards analyzing 100M+ records; designed funnel/cohort analyses on 12M+ records, driving 20% activation lift and 30% faster insights.
• Implemented data governance frameworks and privacy compliance; automated Python/SQL reports improving efficiency by 20%; led UAT cycles ensuring data integrity and security protocols.
• SME in BI engineering; mentored 3 junior analysts on dashboard design and data storytelling; established best practices and reusable templates.

Data Analyst & Python Developer - Saguna Consulting Services - Remote

(2022-12 - 2023-02)

• Built Python scraping pipelines (BeautifulSoup, Selenium) to collect structured company and funding data across 500+ firms for client intelligence use cases.
• Designed ETL workflows to clean, deduplicate, and structure raw scraped data into a centralised master dataset for downstream analysis.
• Delivered Tableau and Power BI dashboards tracking funding rounds, headcount signals, and market KPIs, used by consulting teams to support client strategy engagements.
• Collaborated with cross-functional teams across India and the US in a remote-first setup, aligning deliverables to client timelines.

Bachelors' of Technology (B.Tech.) - Computer Science & Technology - Punjab Technical University (2018 - 2022)