BI Analyst

About the BI Analyst Role at Sporty Group

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

Sporty Group leverages a robust technology stack including MySQL, Python, AirFlow, AWS, Metabase, Redshift, and Linux.

What You'll Be Doing as a BI Analyst

• 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 at Sporty Group

Sporty is a remote first company in pursuit of sustainability, offering a competitive salary + individual performance based bonuses every quarter, 28 days paid annual leave, and core working hours of 10 am-3 pm in your local time zone with flexibility. Additionally, you'll receive referral bonuses & flash bonuses, top of the line equipment, and annual company retreats for internal networking opportunities.

Interview Process

The interview process includes a remote video screening with the Talent Acquisition Team, an offline take-home assignment, a remote video interview with Team Members (60 Mins), and a final discussion with the hiring manager (60 mins). 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.

Key skills/competency

• SQL
• ETL
• Data Analysis
• Dashboarding
• Reporting
• Python
• AWS
• Redshift
• A/B Testing
• Airflow