Associate Data Engineer

Spotlight Sports Group is a global media and technology company with a clear purpose, to set the standard for trusted, customer-driven experiences across global racing and sports betting. Guided by our mission to create experiences that fans love, we combine more than 40 years of heritage with bold innovation to deliver award-winning content, data and digital products. With over 400 employees worldwide, our portfolio includes Racing Post, Pickswise, myracing and Free Super Tips, as well as the international marketing agency ICS-digital and ICS-translate. Together, we partner with leading operators, affiliates and media groups to power growth and engagement across the industry. As an associate data engineer, you will support the data engineering function, within the Data Intelligence Unit at SSG, to plan and build a cloud-based data framework and architecture that enables the collection, management and conversion of raw data into something more insightful in order to drive a data-driven approach to decision making. Under the guidance of the lead Data Engineer, you will assist with the overall set-up, management and optimisation of the Spotlight Sports Group’s Data Warehousing and self-serve platform requirements. Working closely with the group’s data analysts, and key stakeholders you will help to ensure that data is both available upon request, and delivered in the most efficient manner possible. By applying best practice principles you help ensure that data accessibility is never an issue. Role Responsibilities: Assist with the delivery of a first in class data infrastructure to support the needs of the Group.Contribute to scaling and enhancing the current data infrastructure.Build custom automations and manage the Group’s approach to automation via Python or an equivalent.Assist with the design, implementation and deployment of data pipelines/structure across the Group. Help manage the back end infrastructure requirements needed for a Group Self Serve platform.Assist with the management of ETLs and Data Warehouse performance. Provide efficient ways for Data Analysts and other team members to access and manipulate data in a timely manner.Assist with the decision making about data storage and data models.Iterating on anything and everything to make incremental improvement.Work to automate processes and improve efficiency of existing and new data processes.Help troubleshoot and optimise data processes to solve and improve business outcomes.Requirements Essential A degree in computer science or a related technical discipline.Minimum 1.5 years experience with SQL, data warehousing in a RDBMS (e.g. SQL Server, MySQL).Good understanding of Data Modelling concepts and techniques. Experience building and scheduling ETL workflows.Experience with a cloud database management system like Snowflake.Good experience writing high quality, maintainable SQL on large datasets.Experience with cloud-based architecture (e.g. AWS, Azure).Experience using Git and version control tools (e.g. Github, Sourcetree, Bitbucket)Experience in working in an agile methodology. Positive team player who is keen to learn new technologies and progress.Willingness to work directly with stakeholders to understand requirements and translate them into clear actions.Excellent problem solving skills with good attention to detail. Strong communication skills both written and verbal.Ability to work independently when required. Desirable Python programming skills, any experience developing python-based data engineering solutions. Experience working with Dbt Cloud.Experience with a data data visualisation tool (e.g. Tableau, Looker, Thoughtspot). Benefits We offer a range of well-being initiatives, including private medical insurance, excellent parental leave, a working globally policy, mental health support, assistance programs, and social gatherings. We also provide a pension scheme and various other benefit schemes. Plus, we all get our birthdays off work and enjoy 25 days of holiday per year. We’ve also got you covered with life assurance and exclusive perks like the Star card and our Step Further Awards (our employee recognition program) to recognise your dedication. For those working via the hybrid model (in the office and at home) we’ve made commuting easier with our Season Ticket Loan and Cycle to Work Scheme. You can also take advantage of complimentary access to our Racing Post Members Club, complete with an Ultimate Membership. We believe in making a positive impact beyond the workplace, and you'll have the chance to volunteer two days per year with our charity partner.