BI Analyst
About the role
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
What you'll be doing
- Setting up and executing 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
- Enhancing and optimising 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
What you'll bring
- 3+ 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
- Strong knowledge with ETL data pipelines
- Strong knowledge of A/B Testing
- 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
Even better if
- Hands-on experience with machine learning
- Relevant knowledge or experience in the gaming industry
What’s in it for you
- Sporty is a remote first company in pursuit of sustainability
- A competitive salary + individual performance based bonuses every quarter
- 28 days paid annual leave
- Our core working hours are 10am-3pm in your local time zone with flexibility outside of this
- Referral bonuses & flash bonuses
- Top of the line equipment
- Annual company retreats to provide great internal networking opportunities
Interview Process
- Remote video screening with our Talent Acquisition Team
- Offline Take home assignment
- Remote video interview with Team Members (60 Mins)
- Final discussion with the hiring manager (60 mins)
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.
#LI-remote
Apply for this job
*
indicates a required field
