Data Analyst (Engineer)
Current• Created a new database and designed schema for structured data in MySQL, ensuring optimized data storage and retrieval.• Designed and implemented data pipelines, enabling seamless data transfer from various sources (EPOS systems, external websites) to a MySQL database.• Integrated REST API into data pipelines for retrieving and converting JSON data into structured formats, improving database performance and usability.• Enhanced data acquisition through web scraping scripts, automating the retrieval of crucial data from multiple online sources, significantly improving data quality and availability.• Created and maintained an automated Power BI dashboard, streamlining data visualization and reporting processes for stakeholders.• Enabled IT team to focus on other tasks and improved strategic decisions for marketing.