Sanchita Kochar
Senior Analyst @EY
Signup · Get unlimited contacts
WORK HISTORY
Senior Analyst @EY
Pune, IN
Designed and deployed 10+ marketing and operational Power BI dashboards used by 50+stakeholders to monitor chatbot engagement, user journeys, consent tracking, and campaigneffectiveness.• Processed daily chatbot interaction logs of 1M+ records for analytics reporting.• Built scalable Star Schema data models in Amazon Redshift, improving query performance by 30%and ensuring optimized reporting.• Developed end-to-end data pipelines by ingesting structured and semi-structured logs from AWS S3into Redshift staging and ODS layers.• Created and optimized complex SQL stored procedures to transform and load data from staging toODS tables, ensuring data quality and consistency.• Automated daily ETL workflows using Apache Airflow, enabling reliable and scheduled data refreshwith zero manual intervention.• Implemented Row-Level Security (RLS) and access controls in Power BI Service to ensure secure,role-based dashboard usage.• Reduced manual reporting efforts by 35% through automation and standardized semantic models.• Collaborated with business, marketing, and data engineering teams to translate requirements intoscalable analytics solutions.
EDUCATION
Gokhale Education Society's R. H. Sapat College of Engineering, Management Studies and Research
Bachelor of Engineering - BE, Computer Engineering
New Era English School - India
SSC
K. K. Wagh Polytechnic
Diploma, Computer Technology
ABOUT SANCHITA KOCHAR
Power BI Developer with 3.5+ years of experience designing end-to-end BI solutions across BFSI andHealthcare domains. Skilled in building scalable data models (Star Schema), optimizing SQL and storedprocedures, and developing interactive dashboards used by 50+ business stakeholders. Hands-onexperience with Amazon Redshift, AWS S3, Airflow-based workflow orchestration, and automated datarefresh pipelines. Strong expertise in DAX, Power Query, Row-Level Security (RLS), and performanceoptimization to deliver reliable, data-driven insights.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.