BI Analyst BI數據分析

Responsibilities

● 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 
● 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

1. Online test: 90 mins
2. Online interview: 130 mins
3. Interview result within 24 hr