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