Remote EU 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 inAs 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 StackMySQLPythonAirFlowAWSMetabaseRedshiftLinuxResponsibilitiesSet up and execute extract, transformation and load (ETL) functions to build a data pipelineExtraction and analysis of large data sets from MySQLPerformance tuning for current and newly added queries to the databases, ensuring the database resources are fully utilizedDelivering clear analysis and reporting of core business metrics to shareholdersCreation and management of reports and dashboardsData managementEnhance and optimize existing reporting processesAd hoc analysis and reporting to clients and shareholdersAid in reconfiguring existing architecture and database structure to address our shareholder's evolving needsDaily maintenance and monitoring of all BI related databases and dashboards, including proficient handling of emergenciesProviding actionable insight to drive growth of core productsRequirements3+ years experience in a similar data-driven roleExcellent working knowledge of SQLFamiliarity with Python and a range of BI and data visualization toolsStrong knowledge with ETL data pipelinesStrong knowledge of A/B TestingFamiliarity with AirflowUnderstanding of principles of relational databases and data warehouseStrong understanding of sports and gaming will be beneficialProactive and self-driven with excellent analytical skillsAbility to thrive in a fast paced and dynamic environmentGreat communication skillsRelevant knowledge or experience in the gaming industryNice to have hands-on experience with machine learningBenefitsQuarterly and flash bonusesWe have core hours of 10am-3pm in a local timezone, but flexible hours outside of thisTop-of-the-line equipmentReferral bonuses28 days paid annual leaveAnnual company retreat - we all went to Thailand & Dubai together in 2023 and we aim to have 2 more trips in 2024!Highly talented, dependable co-workers in a global, multicultural organisationPayment via DEEL, a world class online wallet system Our teams are small enough for you to be impactfulOur business is globally established and successful, offering stability and security to our Team MembersInterview Process30 min HackerRank Test Remote video screening + ID check with our Talent Acquisition Team Remote video interview loop with 3 x Team Members (45 mins each)ID Check Via Zinc & 2 references from previous employers24-72 hour feedback loops throughout process