BI Analyst

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 We welcome applications from different locations of Europe