Data Analyst
Current• Establish key metrics aligned with stakeholder requirements and tailored to diverse business units• Compile and refine departmental raw data to ensure standardization of master data across all systems• Execute data retrieve and extraction from multiple sources, streamline report requisitions and enhance data integrity through BigQuery• Control the complete process of utilizing SQL queries to undertake thorough data preparation and processing• Optimizequeryperformanceandminimizestoragecoststhroughefficient database management• Design, develop, and maintain interactive dashboards with Superset, Looker Studio, and Power BI to allow for insightful data visualization and real-time tracking at all organizational levels.• Perform ad hoc work using Google Sheets and Excel as needed to accommodate different project demandsAccomplishments:• Built dashboards measuring: Store operational benchmarks; Employee and Corporate Cost management; Warehouse and Inventory tracking; Customer and Product Marketing to support in-depth analysis• Designed and implemented automation templates for the monthly management report, which significantly increased workflow effectiveness and cut down on report generation time• Determined the underlying problem and reduced The Coffee House's database and query costs
