Sara Siddiqui

Built automated KPI monitoring dashboards in Looker Studio, enabling leadership to detect performance anomalies and track operational trends across multiple systems. Designed and maintained Python-based ETL pipelines integrating 7+ data sources (including Oracle DB), improving reporting speed and data reliability. Developed structured analytical workflows for automated reporting, mail merge generation, and roster creation, reducing manual workload by 60%. Prepared, validated, and merged large multi-year datasets, ensuring consistency, audit readiness, and high data integrity. Conducted requirements elicitation with academic and operational teams, translating complex needs into reporting specifications and clear analytical outputs. Implemented data quality assurance processes, including automated validation rules and documentation of calculation logic. Provided user training and technical support to non-technical teams on dashboards, reports, and analytical tools.

Prepared, Processed and analyzed large-scale datasets (10,000+ responses) using SQL and Python (Pandas), producing insights for program evaluation and strategic decision-making. Developed 8+ Power BI dashboards tracking 15+ KPIs, improving visibility into performance indicators for academic leadership. Conducted descriptive, trend, and behavioral patterns via Python NLP techniques to process 300,000+ text reviews, reducing manual review time by 80%. Structured data models and prepared transformation logic to support efficient querying and reporting. Documented data definitions, reporting logic, and processes to ensure long-term consistency and reproducibility. Collaborated with ERP teams and stakeholders to extract high-volume data, resolve discrepancies, and deliver tailored dashboards. Prepared qualitative datasets for analysis, using Python to pre-process text responses and improve analytical readiness.

Designed and implemented event-based tracking strategies using Google Analytics and Google Tag Manager, significantly improving the accuracy of user-behavior tracking and in-app/web event capture. Built and optimized SQL data models on Google Cloud Platform (GCP), enhancing dashboard performance, query efficiency, and analytical depth for multiple client reporting workflows. Developed 10+ dynamic dashboards in Looker Studio, providing real-time visibility into marketing KPIs, user engagement patterns, conversion funnels, and campaign performance. Conducted campaign and web performance analysis, generating actionable optimization recommendations that contributed to increased conversion rates and improved ROI for clients. Performed structured data audits and implemented QA checks in Excel and Looker, ensuring data accuracy, consistency, and reliability across all client-facing analytics products. Collaborated with clients to understand reporting needs and translated them into clear analy