Associate Data Engineer

Spotlight Sports Group; Greater London; On-site; GBP 45,000 - 65,000; Full time

Benefits offered by this job

Private medical insurance

Pension scheme

Birthday off

25 days holiday

Job summary

Spotlight Sports Group is seeking an Associate Data Engineer to help build a cloud-based data framework that turns raw data into actionable insights for decision making. You will work under the lead Data Engineer and collaborate with data analysts and stakeholders to ensure data is accessible and efficiently delivered.

You will contribute to the design and deployment of data pipelines, ETLs and a self-serve data platform, while applying best practice data modelling and cloud architecture

Qualifications

• Degree in computer science or a related technical discipline.
• 1.5+ years experience with SQL and data warehousing in a relational DBMS.
• Strong 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 (AWS/Azure).
• Experience using Git and version control tools.
• Experience in working in an Agile methodology.
• Willingness to work with stakeholders to translate requirements into actions.
• Excellent problem solving and attention to detail.
• Strong written and verbal communication.

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 back-end infrastructure for a self-serve platform.
• Assist with the management of ETLs and Data Warehouse performance.
• Provide efficient ways for Data Analysts to access and manipulate data.
• Assist with decision making about data storage and data models.
• Iterate on processes to drive incremental improvements.
• Work to automate processes and improve efficiency of data workflows.
• Troubleshoot and optimise data processes to improve business outcomes.

Skills

SQL

Data warehousing

Data modelling

ETL workflows

Snowflake

AWS/Azure

Git

Agile

Stakeholder communication

Python basics

Education

Degree in computer science or related

Tools

Git

Dbt Cloud

Job description

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.

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.