Senior Solutions Analyst
ThoughtSpot · Aug 2024 – Present
- Designed, built, and maintained ETL/ELT pipelines for 50+ enterprise customers integrating data from multiple sources and vendors (APIs, cloud storage, relational databases, CRM/ERP systems) into governed Snowflake data warehouse environments.
- Built and managed data warehouse solutions end-to-end designing dimensional data models (fact/dimension tables, star/snowflake schema, SCD handling), creating ETL processes, and implementing data quality mechanisms to ensure reliable analytical data.
- Performed exploratory data analysis (EDA) to troubleshoot data-related issues identifying root causes of data quality problems, analysing pipeline failures, and implementing permanent fixes to ensure data integrity across production systems.
- Managed direct client interactions engaging with technical and business stakeholders to understand data requirements, present engineering solutions, and provide ongoing technical guidance throughout delivery engagements.
- Provided mentoring and technical guidance to junior analysts - reviewing data models and pipeline designs, supporting skill development, and ensuring consistent engineering standards across the team.
- Integrated data from multiple enterprise sources including CRM (Salesforce-adjacent), operational databases, flat files, APIs, and cloud storage into unified Snowflake data platforms supporting holistic analytical insights.
- Implemented end-to-end data quality and data governance mechanisms
- validation rules, completeness checks, data lineage documentation, audit trails, and access controls (RLS, PII masking) across production data pipelines.
- Optimised Databricks and Snowflake workloads applying PySpark optimisation techniques, virtual warehouse tuning, clustering keys, and materialised views to improve pipeline performance and reduce compute costs.
- Managed Apache Airflow/Cloud Composer DAG orchestration designing dependency chains, retry logic, SLA-driven scheduling, and alerting for production ETL workflows.
- Worked with AWS services (EC2, S3) and Azure for cloud data engineering
- integrating cloud storage, managing data ingestion workflows, and ensuring multi-cloud data platform reliability.
- Maintained Git-based CI/CD workflows - version-controlled deployments, code reviews, and release governance for all ETL pipeline and data model assets.

