Resume
Contact Information
| Name | Satyarth Jaiswal |
| Professional Title | Business Intelligence & Data Analyst |
| jaiswal.satyarth070@gmail.com |
Professional Summary
Data & Business Intelligence Analyst with hands-on experience in SaaS, eCommerce, and advertising industries. Skilled in data modelling, designing scalable ETL pipelines, automating dashboards, and delivering actionable insights to drive business decisions. Proficient in SQL, dbt, BigQuery (GCP), Python, Power BI, Tableau, and Looker Studio. Strong track record of collaborating with cross-functional teams to develop strategic analytics solutions that optimise performance, improve reporting accuracy, and support growth initiatives.
Experience
-
2022 - present Remote
Senior Consultant – Marketing Science
Sciera Inc.
- Designed comprehensive and scalable marketing dashboards for key clients in the US.
- Collaborated with campaign execution, creative services, and client teams to address digital advertising challenges through data analysis and reporting.
- Ensured data accuracy, integrity, and usability for all in-house and client projects.
- Led a team of five to deliver digital campaigns, analytics, and performance insights to US clients.
- Designed and executed impact measurement frameworks to conduct brand lift studies for education, CPG, and apparel clients.
- Led experimental design (A/B testing) to optimise user engagement and improve KPIs, applying statistical analysis to validate results.
-
2020 - 2022 India
Manager – Marketing & Marketing Analytics
Aroscop Tech, Inc.
- Doubled monthly deal closures by implementing marketing automation and CRM workflows.
- Built and managed a team of 4 marketing, data and design professionals.
- Led the creation and delivery of 10 market research reports and 3 industry trend analyses.
- Planned and executed 2 online conferences to improve brand awareness, helping win 3 of Aroscop’s largest clients.
- Scaled subscriber base to 10k+ through strategic content initiatives.
-
2018 - 2020 India
Digital Marketing Manager
RazorThink
- Packaged AI products and solutions into marketing-friendly content.
- Promoted employee-generated content across YouTube and Medium to boost brand visibility.
- Drove lead generation through targeted, industry-specific LinkedIn campaigns.
- Partnered with product and presales teams to develop and execute social media and content strategies.
Key Achievements
Projects
-
Data Modelling, Transformation & Dashboarding with dbt, BigQuery & Looker Studio
- Designed an automated marketing analytics pipeline integrating Google Ads, Meta Ads, and CRM data into BigQuery.
- Transformed data with dbt and delivered real-time performance dashboards in Looker Studio.
-
ETL Pipeline and Performance Dashboard for Digital Advertising Campaigns
- Developed an automated ETL pipeline integrating digital advertising and CRM data.
- Enabled real-time performance tracking and efficient campaign optimisation.
-
CRM & Digital Ads Data Integration using BigQuery, SQL & Looker Studio
- Unified CRM data with Google and Meta Ads data using multidimensional data modelling.
- Revealed in-depth insights on lead quality, keywords, locations, and campaigns.
Skills
Data Engineering: SQL, Python, BigQuery, dbt, ETL Pipelines
Business Intelligence: Power BI, Tableau, Looker Studio, Data Visualization
Marketing Analytics: Google Ads, Meta Ads, GA4, Campaign Attribution, A/B Testing
Certificates
- Agentic AI and AI Agents for Leaders - Coursera (2025)
- Python for Data Science and AI - IBM (2025)
- Microsoft Certified: Power BI Data Analyst Associate (PL-300) - Microsoft (2025)
- Microsoft Power BI Data Analyst Specialisation - Coursera (2025)
- Google Cloud Data Analytics Professional Certificate - Google (2025)
- Google Business Intelligence Certificate - Google (2024)
- Google Advanced Data Analytics Certificate - Google (2024)
- Google Data Analytics Professional Certificate - Google (2024)
Education
-
- Indian Institute of Management
MBA – Marketing & Analytics
-
- The LNM Institute of Information Technology
B.Tech – Communication & Computer Engineering