Skip to main content
Saswata Ghosh

Saswata Ghosh

Data Analyst | Analytics Engineer

Talent
KolkataMember since August 9, 2026
Data AnalystAnalytics EngineerSqlPythonAdvanced ExcelPower BiPower QuerySql ServerDaxData AnalysisBusiness AnalystExploratory Data Analysis (EDA)KPI Analysisdbt CoreDatabricksAzureSnowflakeMedallion ArchitectureStar SchemaData WarehousingData VisualizationData ScientistEtl PipelinesData PipelineEtlCTEsWindow FunctionsStored ProcedurePivot TablesVba
·

Hire this person

Send a job offer directly to this candidate

Data AnalystAnalytics EngineerSqlPythonAdvanced Excel

About

Data Analyst | Analytics Engineer skilled in SQL, Python, Power BI, Tableau, dbt Core, Databricks, and Apache Airflow. I build tested, documented pipelines (Medallion Architecture, dimensional modeling) and turn the output into business-ready dashboards and insights.

At Reason Analytics Softech, I automated manual SQL Server reporting across Sales, Inventory, and Logistics, cutting manual report prep and catching ~5% anomalous rows before executive dashboards.

Built 3 end-to-end projects: a customer analytics pipeline on 541K transactions (62.8% revenue from one segment, 1,841 at-risk customers, churn model ROC-AUC 0.781); an e-commerce platform on 99,441 orders linking a 7.87% SLA breach rate to a ~2-star drop in reviews; and a sales performance analysis in SQL Server and Power BI.

Machine Learning, Statistical Analysis, ETL/ELT, and Business Intelligence are central to how I work.

B.Tech CSE (AI & ML). Actively seeking Data Analyst, Analytics Engineer, or Data Engineer roles.

Experience

Data Analyst Intern at Reason Analytics Softech Pvt. Ltd. (2025-09 – 2026-01)

  • Refactored 5 SQL Server stored procedures and CTE-based queries into reusable pipelines, replacing manual report prep across Sales, Inventory, and Logistics.
  • Wrote T-SQL validation scripts using window functions to catch duplicate records and flag anomalous rows 5% of the dataset before they reached Power BI.
  • Merged 3 operational data sources into one Power BI dashboard using Power Query and DAX — Sales, Inventory, and Logistics KPIs in one place instead of 3 separate reports.

Technical Consultant Intern at Newscope Media (2024-11 – 2025-05)

  • Mapped client workflows to identify 4 operational bottlenecks, working with senior team members to evaluate issues and recommend process changes that reduced project turnaround from 7 days to 4 days.
  • Tracked 3 concurrent workstreams and turned client requirements into functional documentation used by a 5-person team for status reporting and coordination.

Education

Bachelor of Technology in Computer Science and Engineering (AI-ML) – Sister Nivedita University (2022-08 – 2026-07)

Skills

Data AnalystAnalytics Engineer

Reviews

Related