Hannah Solomon

Developed ad-hoc and executive dashboards in Tableau visualizing KPIs related to healthcare utilization, clinical outcomes, patient engagement, and customer service efficiency (telephony/IVR data), supporting strategic decision-making. Automated recurring reporting workflows using Python and SQL, reducing weekly report turnaround time by 50% and improving data validation accuracy. Collaborated with data engineers to optimize Snowflake and Redshift-based data warehouse architecture, improving SQL performance and reducing response time by 70%. Ensured data integrity through governance, validation, audit checks, and documentation of source-to-report data lineage. Trained operational managers and business users on dashboard interpretation and self-service analytics.

Managed over 1,000 real-time global escalations involving sensitive and legal content across social media platforms; reviewed and refined content moderation policies to align with legal and operational guidelines, ensuring compliance and risk mitigation. Collaborated with law enforcement, legal teams, and outreach partners to ensure user safety and risk mitigation. Built reports and dashboards using SQL and BI tools to track operational performance, identify trends and business needs.

Utilized BI tools such as Power BI and Tableau to create interactive and comprehensive KPI dashboards to assist business stakeholders in tracking operational performance. Wrote complex SQL queries to retrieve and manipulate datasets for reporting needs. Collaborated with team leaders and other internal stakeholders in identifying business needs and provided support in generating ad hoc reports to compile and present specific data, resulting in identifying trends and discrepancies. Conducted anomaly detection and data integrity checks to ensure accurate reporting and reduce inconsistencies across data pipelines. Worked within Agile frameworks to constantly meet project deadlines and deliverable objectives, in order to meet client’s needs and expectations. Troubleshot and debugged technical errors in dashboards to fix performance issues and improve usability. Used Python and Hadoop tools to maintain and develop scripts and data pipelines to acquire, clean, and process data. Performed m