Priyanka Sahoo

I’m an Analytics Engineer with 4+ years across consulting and enterprise settings, focused on turning raw data into reliable, business-ready analytics. I build and maintain data pipelines on GCP, write SQL and Python for cleaning and transformation, and deliver dashboards that leadership and teams actually use.

In my current role at Tata Consultancy Services, I architected a metadata-driven ingestion framework on GCP using a Bronze-Silver-Gold layered architecture. I designed Cloud Composer (Apache Airflow) DAGs for dependable orchestration and built Dataflow (Apache Beam) streaming jobs that cut data latency from 24 hours to under 5 minutes.

I also drive measurable performance improvements—cutting reporting time by 40% and reducing BigQuery query costs by 35% through partitioning and clustering. I implement SCD Type1 and Type2 transformations with MERGE logic across 200K+ rows, and I create reusable stored procedures and parameterized SQL for data quality checks, null validation, and schema conformance.

At PwC, I supported credit-card spending behavior and customer analytics by analyzing 100K+ transactions in BigQuery and automating data transformation workflows with Python. I built Power BI dashboards that helped identify $250,000 in potential cost-saving opportunities, improving data-scientist efficiency by 30% and increasing model accuracy by 4% through better feature engineering and automation.