Hi! I'm Swastik Tripathi, a data analyst with 1+ year of experience across contract and freelance roles, specializing in SQL and BI tools. I excel at end-to-end analysis, quickly adapting to evolving requirements, and clearly communicates insights to both technical and non-technical stakeholders to drive informed decisions.

Swastik Tripathi

Hi! I'm Swastik Tripathi, a data analyst with 1+ year of experience across contract and freelance roles, specializing in SQL and BI tools. I excel at end-to-end analysis, quickly adapting to evolving requirements, and clearly communicates insights to both technical and non-technical stakeholders to drive informed decisions.

Available to hire

Hi! I’m Swastik Tripathi, a data analyst with 1+ year of experience across contract and freelance roles, specializing in SQL and BI tools.

I excel at end-to-end analysis, quickly adapting to evolving requirements, and clearly communicates insights to both technical and non-technical stakeholders to drive informed decisions.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Intermediate

Work Experience

Associate at PwC - Data, Analytics and Technology Solutions
October 1, 2025 - Present
Supported 20+ parallel client engagements, including multiple high-profile accounts, rapidly adapting to diverse data systems and delivering consistent, high-quality ETL pipelines, reconciliations, and analytic outputs. Executed multi-stage data analysis on large financial and operational data sets using SQL, Excel, Databricks (PySpark) and Snowflake to support audit and compliance engagements. Executed data transformations, validation checks, and reconciliation workflows to ensure completeness, accuracy, and audit readiness of multi-source client data sets. Communicated findings, anomalies, and validation issues directly to managers and client stakeholders, enabling faster decision-making and resolving data inconsistencies under tight timelines.
Business Operations & Financial Analyst Intern at GoesOnline
June 1, 2025 - August 1, 2025
Built optimized Power BI dashboards and integrated multi-source data sets, reducing data processing time by 50% and delivering insights for daily founder briefings on company performance and strategic initiatives. Automated lead-tracking and operational workflows using Looker and SQL, enabling real-time visibility for outreach/sales teams and contributing to a 5% reduction in related operational expenses.
Group Lead at Google Developers Group
September 1, 2024 - May 1, 2025
Organized and led 7 successful tech events while managing stakeholders, analyzed engagement data to optimize processes, and fostered collaboration, growing membership from 900 to 1,350.
Data, Analytics and Technology Solutions Associate at PwC
October 1, 2023 - Present
Supported 20+ parallel client engagements, including high-profile accounts, delivering robust ETL pipelines, reconciliations, and analytic outputs. Performed multi-stage analysis on large financial and operational datasets using SQL, Excel, Databricks (PySpark), and Snowflake, including transformations, validation checks, and reconciliation workflows. Communicated insights and data issues directly to managers and client stakeholders, enabling faster resolution and timely decision-making.
Business Operations & Financial Analyst Intern at TrainerGoesOnline
June 1, 2025 - August 1, 2025
Built optimized Power BI dashboards and integrated multi-source data sets for a fitness startup, reducing data processing time by 50% and delivering insights for founder briefings on performance and strategic initiatives.
Data Analyst – Project-Based Engagements at Freelance (Remote)
August 1, 2024 - September 1, 2025
Delivered 7+ short-term analytics projects through referral-based engagements, developed 12+ SQL-driven reports and BI dashboards for small business clients. Designed SQL data models and lightweight ETL workflows, integrating data from Excel, CSVs, APIs, and relational databases (50K–500K+ records) to ensure consistent, reliable reporting. Reduced manual reporting efforts by 30–40% by automating recurring reports and iterating rapidly based on stakeholder feedback.
Google Developers Groups Lead at Google Developers Group (Kolkata)
September 1, 2024 - May 1, 2025
Organized and led 7 successful tech events while managing a 30-member team; analyzed engagement data to optimize processes, and fostered collaboration, growing membership from 900 to 1,350+.

Education

B.Tech in Computer Science & Engineering at B. P. Poddar Institute of Management and Technology
January 1, 2021 - January 1, 2025
Higher Secondary Education (ISC) Class XII at St. Thomas’ Church School Howrah
January 1, 2017 - January 1, 2019
Secondary School Examination (ICSE) Class X at St. Thomas’ Church School Howrah
January 1, 2015 - January 1, 2017
B.Tech in Computer Science & Engineering at B.P. Poddar Institute of Management and Technology
January 1, 2021 - January 1, 2025
Class XII (ISC) at St. Thomas' Church School Howrah
January 1, 2017 - January 1, 2019
Class X (ICSE) at St. Thomas' Church School Howrah
January 1, 2015 - January 1, 2017

Qualifications

Python for Data Science, AI & Development (IBM)
January 11, 2030 - January 25, 2026
Career Essentials in Data Analysis (Microsoft)
January 11, 2030 - January 25, 2026
Career Essentials in Data Analysis (Microsoft)
January 11, 2030 - January 25, 2026
Data Analyst Job Simulation (Tata Group)
January 11, 2030 - January 25, 2026
Python for Data Science, AI & Development (IBM)
January 11, 2030 - January 25, 2026

Industry Experience

Software & Internet, Professional Services, Education, Media & Entertainment, Other, Financial Services