BI Analyst_BI數據分析

- Set up and execute extract, transformation and load (ETL) functions to build a data pipeline.
- Extraction and analysis of large data sets from MySQL
- Performance tuning for current and newly added queries to the databases, ensuring the database resources are fully utilized
- Delivering clear analysis and reporting of core business metrics to shareholders
- Creation and management of reports and dashboards
- Data management - Enhance and optimize existing reporting processes
- Ad hoc analysis and reporting to clients and shareholders
- Aid in reconfiguring existing architecture and database structure to address our shareholder’s evolving needs
- Daily maintenance and monitoring of all BI related databases and dashboards, including proficient handling of emergencies
- Providing actionable insight to drive growth of core products

Our Stack
MySQL
Python
AirFlow
AWS
Metabase
Redshift
Linux

Requirements

●Proactive and self-driven with excellent analytical skills
●Previous experience in a data-driven role
●Excellent working knowledge of SQL
●Familiarity with other data and BI tools a plus
●Good communication skills

- 2+ years experience in a similar data-driven role
- Excellent working knowledge of SQL
- Familiarity with Python and a range of BI and data visualization tools ie PowerBI
- Familiarity with ETL data pipeline
- Understanding of principles of relational databases and data warehouse
- Strong understanding of sports and gaming will be beneficial
- Proactive and self-driven with excellent analytical skills
- Ability to thrive in a fast paced and dynamic environment
- Great communication skills