Pranav S

About Pranav S

Senior Data Analyst with 6+ years of experience designing scalable data solutions, building high-performance data pipelines, and translating complex data into actionable business insights. I specialize in working across Azure data platforms, leveraging tools like Databricks, PySpark, and Azure Data Factory to build robust ETL/ELT pipelines and dimensional data models. My experience spans financial services, insurance, and healthcare, where data accuracy, governance, and compliance are critical. In my current role, I design and optimize large-scale data pipelines processing millions of records daily, implement data quality frameworks, and collaborate closely with data engineers and architects to ensure seamless data movement across systems. Key strengths: Building scalable Databricks & PySpark pipelines Designing star schema & dimensional models Developing ADF pipelines & cloud data integrations Implementing data governance & quality frameworks Creating Power BI dashboards for executive insights I’m passionate about solving complex data problems and enabling organizations to make data-driven decisions through reliable and well-structured data systems.

Experience

1. Senior Data Analyst

   Valley Bank

   Aug 2024 — Present · Overland Park, KS, US

   Designed scalable data pipelines using Databricks and PySpark to process high-volume financial dataBuilt Delta Lake architectures with performance optimization (partitioning, Z-ordering)Created Source-to-Target Mappings (STTMs) and Design Documents for data workflowsDeveloped Azure Data Factory pipelines for end-to-end data integrationImplemented data governance, quality checks, and metadata managementBuilt Power BI dashboards with DAX and row-level securityOptimized pipeline and query performance using Spark UI and SQL tuning

Education

• University of Central Missouri

  Master's degree

  2022 — 2023