Nikhil Rai

At Polestar Analytics, I've built data engineering and analytics solutions for retail, CPG, sales, finance, HR, and operations clients using Snowflake, Databricks, GCP, SQL Server, Python, PySpark, SSIS, and Power BI.

I develop batch, incremental, and near-real-time pipelines from APIs, relational databases, flat files, cloud storage, and event-based sources. My work spans ingestion through curated warehouse and reporting layers, including Delta Lake medallion-style architectures, Snowflake ELT workflows, and Power BI semantic models.

I've implemented watermarking, merge/upsert logic, checkpointing, deduplication, audit metadata, reconciliation, and backfill-ready processing for sales and transaction data. I also build KPI logic covering gross and net sales, budget, forecast, last-year sales, transaction counts, and operational exceptions.

I've supported delivery from requirements and solution design through QA, UAT, production deployment, and support, while mentoring junior engineers on SQL, PySpark, data modeling, debugging, and validation practices.