Founding Analytics Engineer, Data Platforms

Saiyam Doshi

857-***-**** United States ************@*****.*** linkedin.com/in/saiyam-doshi github.com/saiyam155 doshisaiyam.com Work Experience

Aris Insights Boston, MA

Analytics Engineer June 2025 – February 2026

• Partnered with stakeholders to design a governed semantic layer in PostgreSQL with metric definitions, glossary, and column lineage, enabling LLM-powered SQL generation and cutting manual reporting by 80%.

• Designed a star-schema dimensional model in ClickHouse with bronze/silver/gold dbt transformation layers, building reusable macros, Slowly Changing Dimensions, and automated freshness checks that scaled cleanly across 10+ merchant warehouses.

• Owned the full platform build as founding engineer, using Python/PySpark, complex SQL, and AWS Lambda to clean, validate, and deduplicate 5TB+ of multi-tenant payment data on EMR, cutting silent failures by 60%.

• Automated ingestion of Stripe and payment datasets from API and file sources into AWS S3 (Parquet) with Airflow-orchestrated Python/SQL pipelines, engineering pagination, rate-limit handling, scheduling, and SDLC best practices to sustain 99.5% uptime.

• Built GitHub Actions and Terraform CI/CD from scratch, automating dbt deployments, schema migrations, and environment provisioning across dev and production, cutting release cycles by 50%. SlowRida Boston, MA

Data Analyst February 2025 – May 2025

• Architected star schema dimensional model in Snowflake using complex SQL transformations, established conformed dimensions and fact table for reporting downstream data quality issues by 60%, ad-hoc analysis and dashboard rework time by 70%.

• Built Python ETL pipelines processing 100K+ daily trip records from Bluebikes and Lime into Snowflake, orchestrated with Snowpipe AUTO INGEST for sub-10-minute latency so stakeholders always acted on fresh data.

• Dug into ambiguous business questions with product and marketing teams to define KPIs and dimensional models, delivering live Tableau and Power BI dashboards that exposed seasonal ridership trends and lifted user adoption by 40%.

• Went beyond reporting to build an LLM-powered recommendation system in Streamlit using a RAG pipeline with vector search and prompt engineering over 1M+ Snowflake records, improving recommendation accuracy by 60%. Corpack Solutions Mumbai, IN

Data Analyst January 2021 – January 2023

• Built an AWS data lake on S3, Glue, and Redshift with Python ingestion scripts pulling from 7+ source systems (ERP, billing, CRM), replacing manual data exports with an automated daily pipeline that removed a standing operational bottleneck.

• Dove deep into Redshift internals, tuning sort keys, distribution keys, and workload management to improve query speeds by 40% and reduce storage costs by 25%.

• Modeled business KPIs into star and snowflake schemas using SQL transformations, cutting metric discrepancies across teams by 90% so finance and operations could plan against one trusted set of numbers.

• Owned ad-hoc reporting for finance and operations, building Tableau and Power BI dashboards on financial data surfacing revenue trends, margin variance, and cost analytics that replaced manual reporting cycles and enabled faster data-driven decisions. Projects

Data Warehousing & Analytics of Vehicle Collisions (GitHub) August 2024 – December 2024

• Wrote advanced SQL to clean, profile, and transform 20M+ collision records from 3 cities in SQL Server, designed a Kimball star-schema with Talend ETL pipelines, and built Power BI and Tableau dashboards with DAX measures surfacing collision trends. EventLens – Full-Stack AI Chatbot (GitHub) January 2025 – April 2025

• Built a full-stack event recommendation platform — FastAPI backend, Streamlit UI, and LangGraph/OpenAI RAG pipeline delivering contextual suggestions from 1M+ records extracted via Selenium, BeautifulSoup, and Apify into Snowflake.

• Applied Snowflake Cortex for classification, vector similarity for deduplication, increasing coverage by 95%; deployed with Docker and GitHub Actions CI/CD, halving release cycles.

Skills

BI & Visualization: Tableau, Power BI, DAX, AWS QuickSight, Python (Plotly, Dash), Excel Programming & Analysis: Python, SQL, dbt, FastAPI, Flask Databases & Warehouses: Snowflake, ClickHouse, AWS Redshift, SQL Server, PostgreSQL, MySQL, Databricks Data Engineering & ETL: Apache Airflow, PySpark, Talend, Airbyte, Kafka, Star Schema, Snowflake Schema Cloud Platforms: AWS (S3, Glue, Lambda, Redshift, Athena), Azure, GCP DevOps & Workflow: GitHub Actions, Terraform, Git, Docker, Agile Scrum Education

Northeastern University September 2023 – August 2025 Master of Science in Computer Information Systems

Dwarkadas J Sanghvi College of Engineering June 2019 – July 2023 Bachelor of Engineering in Electronics and Telecommunication

Contact this candidate