DBT Developer / Redshift Developer

A Sports & Entertainment Marketing business that grows audiences and revenues by understanding fan behavior, working with over 900 clients globally including Premier League, Red Bull, UEFA, and NFL.
Data
Mid-Level Software Engineer
Hybrid
501 - 1,000 Employees
3+ years of experience
Enterprise SaaS · Sports

Description For DBT Developer / Redshift Developer

Two Circles is a leading Sports & Entertainment Marketing business that leverages data to grow audiences and revenues for over 900 global clients including the English Premier League, Red Bull, UEFA, VISA, the NFL, Nike, and Amazon. With nearly 1000 employees across 14 offices, we're seeking a DBT/Redshift Developer to join our technology team.

The role focuses on building and maintaining data warehouses using DBT and Redshift, requiring expertise in big data handling and performance optimization. You'll be responsible for implementing DBT projects, creating robust data pipelines, and ensuring high-quality development through comprehensive testing.

The ideal candidate should have strong experience with Amazon Redshift architecture, SQL optimization, and DBT implementation. Knowledge of AWS technologies, Python, and Pyspark is highly valued. We're looking for someone who can thrive in our fast-paced environment while maintaining attention to detail.

Working at Two Circles offers unique opportunities for professional growth, allowing you to work on diverse projects that directly impact the sports and entertainment industries. You'll join a collaborative team that values innovation and continuous learning, contributing to solutions that shape the future of fan engagement and stakeholder relationships.

Our hybrid work environment provides flexibility while maintaining strong team connections. If you're passionate about data engineering and sports, and want to be part of a company that's revolutionizing how sports and entertainment businesses understand and engage with their audiences, this role offers an exciting opportunity to make a significant impact.

Last updated a month ago

Responsibilities For DBT Developer / Redshift Developer

  • Create and maintain data warehouses and 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
  • Develop and enforce best practices for data modelling with big data sets
  • Ensure high quality development by building robust tests into each model

Requirements For DBT Developer / Redshift Developer

Python
  • Hands-on experience designing and implementing DBT models, tests, and documentation
  • Strong knowledge of Amazon Redshift architecture, SQL, and performance optimization
  • Familiarity with Git and CI/CD workflows
  • Excellent communication skills
  • Experience with AWS technologies (Step function, AWS Glue, Lambda, Athena)
  • Experience in Python and Pyspark development

Benefits For DBT Developer / Redshift Developer

  • Professional Growth opportunities
  • Impactful Work in sports and entertainment industries
  • Collaborative Environment
  • Innovative Culture

Interested in this job?

Jobs Related To Two Circles DBT Developer / Redshift Developer

Data Engineer

Data Engineer position at Two Circles, working on sports marketing technology and fan engagement platforms using AWS, Python, and big data technologies.

Business Intelligence Engineer, Prime Video Sports Finance

Business Intelligence Engineer role at Amazon Prime Video Sports, focusing on data analysis, reporting automation, and strategic planning for major sports properties.

Data Engineer, Prime Video Personalization and Discovery Data Platform

Data Engineer role at Amazon Prime Video focusing on building and maintaining large-scale data platforms for personalization and discovery features.

Business Intelligence Engineer, Global Realty

Business Intelligence Engineer role at Amazon's Global Realty team, focusing on data analytics and insights for worldwide fulfillment network operations.

Data Engineer, GMAC FP&A

Data Engineer position at Amazon's GME Finance team, building scalable data solutions and analytics platforms for financial reporting and forecasting.