Swayam Satapathy
Analytics Engineer
HYDERABAD
Summary
Analytics professional prepared for impactful roles in data analysis and engineering. Known for delivering insightful data solutions and optimizing complex data pipelines. Highly collaborative team player with focus on achieving results and adapting to changing requirements. Expertise in SQL, data visualization, and big data technologies.
Overview
4
4
years of professional experience
Work History
Analytics Engineer
Saras Analytics
01.2026 - Current
- Promoted to Analytics Engineer to work on Saras Pulse, a product delivering analytics-ready datasets to streamline e-commerce analytics across multiple platforms.
- Designed product-grade, standardized analytics data models focused on metric consistency, reusability, and cross-platform reporting.
- Implemented dbt schema and contract enforcement to prevent breaking changes and ensure trust in analytics for downstream consumers.
- Contributed to analytics product architecture decisions supporting multi-client usage and evolving source schemas.
- Partnered with product and analytics stakeholders to ensure datasets were business-ready, documented, and reliable.
Associate Analytics Engineer
Saras Analytics
Hyderabad
07.2023 - 12.2025
- Designed and owned end-to-end analytics data models in dbt and BigQuery across sales, inventory, memberships, and marketing domains.
- Built analytics-ready event models for Klaviyo (Email & Flows) and Postscript (SMS), replacing manual CSV workflows.
- Developed paid marketing analytics models for Meta (Facebook Ads) and TikTok Ads, enabling unified performance reporting.
- Built and optimized high-volume incremental dbt models using partitioning, clustering, and rolling lookback strategies, reducing warehouse compute costs by 65%.
- Implemented dbt tests including generic and singular tests, freshness checks, volume anomaly detection (Z-score), and schema validation.
- Enabled self-serve analytics by exposing curated presentation models to Power BI and Looker.
- Optimized Looker performance using PDTs, partitioning, and clustering, reducing query compute usage by 50%.
SDET & Operations Intern
Frugal Testing
06.2022 - 06.2023
- Supported fintech and e-commerce clients by validating data-driven workflows against business requirements.
- Collaborated with cross-functional teams to ensure analytics deliverables aligned with operational expectations.
Education
Bachelor of Technology - Computer Science & Engineering (Data Analytics)
Lovely Professional University
Punjab, India01.2023
Skills
- Analytics Engineering: SQL (Advanced), dbt (Incremental Models, dbt Tests, Schema & Contract Enforcement), BigQuery, Analytics Data Modeling, Data Quality Frameworks, ETL/ELT
- Orchestration & BI: Airflow, Power BI, Looker
- Python
Timeline
Analytics Engineer
Saras Analytics
01.2026 - Current
Associate Analytics Engineer
Saras Analytics
07.2023 - 12.2025
SDET & Operations Intern
Frugal Testing
06.2022 - 06.2023
Bachelor of Technology - Computer Science & Engineering (Data Analytics)
Lovely Professional University