DBT Developer / Redshift Developer, Two Circles
Data-driven sports marketing
Be an early applicant
Data-driven sports marketing
501-1000 employees
Be an early applicant
501-1000 employees
Company mission
To use data to grow the value of sports.
Role
Who you are
- Redshift Experience is essential for this role
- 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
- 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
Desirable
- AWS technologies such as Step function, AWS Glue jobs & Data Catalogues, Lambda Functions (Python based) and Athena
- Experience in development using Python and Pyspark
- Experience of, or a keen interest in, the business of sport
What the job involves
- 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
Our take
Two Circles is a digital sports marketing agency that develops and executes marketing strategies for sports-based companies, supplying the means to maximise sponsorship rights fees, increase commercial performance, engage the right audiences, and use data to inform future strategy.
As well as delivering front-running marketing tech and services for the sports industry, the company also dedicates itself to improving diversity and inclusion in sports, including its "Diversity in Sports" mentoring program that aims to accelerate the growth of under-represented talent across the industry.
Two Circles works with more than 300 sports rights holders including the likes of the NFL, UEFA, F1, and the ICC as well as $1bn sponsorship revenues. A series of acquisitions have contributed to the expansion of the business - for example, that of Australia-based digital specialist Codeware, which came alongside the opening of a Melbourne office, has enabled it to grow its presence in the Oceania region and bolster its tech offering
Freddie
Company Specialist at Welcome to the Jungle
Insights
18% employee growth in 12 months
Company
Company benefits
- Renowned Team Days often throughout the year
- Discretionary Bonus based on company performance
- Performance Reviews every 6 months with discretionary salary increases
Company HQ
Holborn, London, UK
Articles
Leadership
Gareth Balch
(Chief Executive)Previously worked in Commercial Strategy at Manchester City Football Club. Also a Former Director at Goodform.
Salary benchmarks
We don't have enough data yet to provide salary benchmarks for this role.
Submit your salary to help other candidates with crowdsourced salary estimates.
Diversity, Equity & Inclusion at Two Circles
- Two Circles strives to be a leader in D&I, and though as a business we are by no means the finished product, we are committed to being an agent for change across sports. This means challenging the status quo, giving voices to those previously voiceless, and being an advocate for inclusion.
- Two Circles is committed to creating and maintaining a work environment that is welcoming, and where Two Circlers feel safe and free to be themselves. How we do this is led by our People, Diversity & Inclusion Manager – a full-time role created within the business in 2022.
- Two Circler-led Forums – which currently include Change the Game (dedicated to women in sport), the Ethnicity Network, and the LGBTQ+ Network – provide a safe and welcoming space to address key topics affecting our society today, and meet regularly to influence Two Circles commitments, both internally and externally. Recently these have included our leadership structure, language used across the company and clients we work with.
- Across the year, we use internal and experts to educate and upskill our business in creating and maintaining an inclusive work environment, while we are audited annually against global multi-national corporations on the Global DEI benchmarks Commentary. In our last audit we were rated as “better developed than many larger and more-resourced organisations”, something we are very proud of!
- All our recruitment processes ensure applicants are judged on their suitability without discrimination, and we work with every Two Circler on an individual basis to design roles and career pathways that align with their interests.
- We also run Diversity in Sports, a six-month mentoring programme that accelerates the growth of under-represented talent across the industry. Launched in 2019, the programme offers opportunities and resources to develop well-rounded skills to help pave a career in the sports industry – and it is open to anyone who has faced career barriers.
- In the UK, our internship opportunities have also been established as a Positive Action Scheme, meaning they are open only to applicants from underrepresented or disadvantaged groups.
- Two Circles works with a range of charitable organizations who are using sports to represent, and improve the lives of, people who have faced exclusion. This includes our pro bono charity partnership with Special Olympics GB, the sports organization for children and adults with intellectual disabilities. We are also proud shirt sponsors of Surrey Cerebral Palsy, the football club that is on the charge to the Cerebral Palsy National League, while we have a number of client projects driving the growth and inclusivity of Paralympic and women’s sport globally.
Share this job
View 14 more jobs at Two Circles