Data Analyst
TaiwanRemote
AI Summary
What you'll be doing 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 an
About this role
What you'll be doing
- 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 the growth of core products
Our Stack
- MySQL (Must)
- Python (Good to have)
- AirFlow (Good to have)
- AWS (Good to have)
- Metabase (Good to have)
- Redshift (Good to have)
- Linux (Good to have)
What you'll bring
- 2+ years experience in a similar data-driven role
- Excellent working knowledge of SQL
- Excellent working knowledge of BI and data visualization tools
- Familiarity with Python
- Familiarity with ETL data pipeline
- Familiarity with Airflow
- 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
- Relevant knowledge or experience in the gaming industry
- Nice to have hands-on experience with machine learning
If you're interested, we encourage you to apply! Every application is reviewed by a member of our team (AI is not used in our recruitment process), and we aim to respond within 48 hours.