BI Analyst - remote

SportyBet
Posted 1 year ago
Sporty's sites are some of the most popular on the internet, consistently staying in Alexa's list of top websites for the countries they operate in

As a BI Analyst at Sporty, you’ll be mining through petabytes of data to provide key insights that drive core business decisions. You’ll create dashboards that are used on a daily basis by product managers, traders, and executives, as well as provide in-depth reports on various areas of the business with complete freedom on your methodology.

Furthermore, our analysts play a key role in ensuring the stability of our reporting infrastructure. They are vital in maintaining our ability to deliver accurate and consistent reporting to the various stakeholders. 

Our Stack

MySQL
Python
AirFlow
AWS
Metabase
Redshift
Linux

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

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

Benefits

Quarterly and flash bonuses
We have core hours of 10am-3pm in a local timezone, but flexible hours outside of this
Education allowance
Referral bonuses
28 days paid annual leave
2 x annual company retreats (Lisbon + Dubai in 2022 / Phuket in Q2 2023 + 1 more TBC!)
Highly talented, dependable co-workers in a global, multicultural organisation
Payment via world class online wallet system DEEL
Top of the line equipment supplied by market leader Hofy
We score 100% on The Joel Test
Our teams are small enough for you to be impactful
Our business is globally established and successful, offering stability and security to our Team Members

Interview Process

HackerRank Test 
Remote video screening with our Talent Acquisition Team + live ID check
Remote 90 min video interview loop with 3 x Team Members (30 mins each)
Pre offer call with Talent Acquisition Team
ID check via Zinc
24-72 hour feedback loops throughout process