DBT Developer

About Us:

We are Two Circles. We are a Sports & Entertainment Marketing business. We grow audiences and revenues. We do that by knowing fans best. We work with clients to help them understand & influence what their fans are doing – the way fans spend their money, the events that fans attend, the channels fans respond to, the content fans watch and more. And we use the understanding this gives us to help our clients grow. Grow their audiences and grow their revenues - both direct to consumer and business to business revenues. Our platforms and services are trusted by over 900 clients globally, including the English Premier League, Red Bull, UEFA, VISA, the NFL, Nike and Amazon. We are almost 1000 people, based out of 14 offices, and we deliver work for sports and entertainment businesses of all shapes and sizes all over the world.

Role Profile

As a DBT Developer at Two Circles, you will play a key role in our team of engineers configuring and supporting data and BI solutions for the largest sporting & entertainment organisations in the world. Using your keen eye for detail, logical and analytical mindset, and engineering experience, you implement Two Circles’ industry leading data solutions for our clients and projects. You collaborate with multiple internal teams to understand requirements, thoroughly planning and testing changes before accurately implementing them to a high standard of client and colleague satisfaction. You are a natural problem solver managing multiple proactive and reactive tasks and assignments, effectively prioritising your work, identifying risks and clearly communicating these to stakeholders. You thrive in a fast-paced, constantly changing environment and are equally comfortable discussing technical concepts with your Engineering peers as you are explaining them to less technical colleagues.

When you are not delivering against specific projects or contributing to effective maintenance and operations activities, you are spotting opportunities to add value or realise improvements or sharing knowledge with and mentoring other Two Circlers.

This role will be part of the Data & BI Engineering Chapter.

Requirements

Your main duties & responsibilities:

Create and maintain data warehouses and associated ETL processes using DBT models in Redshift

Implement and maintain DBT projects, including creating macros, tests, and documentation for data pipelines.

Conduct performance tuning for Redshift queries and DBT models to optimize resource utilization.

Develop and enforce best practices for data modelling with big data sets, version control, and CI/CD pipelines.

Ensure high quality development by building robust tests into each model developed.

The ideal background and skills we are looking for include:  

• Hands-on experience designing and implementing DBT models, tests, and documentation in a data warehousing environment.
• Strong knowledge of Amazon Redshift architecture, SQL, and performance optimization techniques.
• Expertise in data modelling techniques in with big data volumes
• Familiarity with version control systems like Git and CI/CD workflows
• Excellent communication skills with an ability to clearly articulate both end user value and technical implementation..
• Passion for technology and an eagerness to learn
• Ability to work in a fast-paced, constantly-changing environment while maintaining a strong eye for detail 

Experience with the following would also be beneficial:

• AWS technologies such as Step function, AWS Glue jobs & Data Catalogues, Lambda Functions (Python based) and Athena.
• Azure technologies such as ADF, Logic Apps, Function Apps, Snowflake and Databricks
• Experience in development using Python and Pyspark
• Experience of, or a keen interest in, the business of sport

Benefits

We have a list of flexible benefits that we offer; as a taste:

• Performance planning: potential to have a salary increase every 6 months and progress your career
• Discretionary company bonus
• Tickets to sporting events
• Renowned Team Days and events
• Lunch once a week, breakfast and continuous supply of snacks
• Private healthcare schemes
• Cycle to work scheme
• Learning and Development opportunities, including certification in certain areas