DBT Developer / Redshift Developer, Two Circles

Salary not provided
SQL
AWS
Python
Athena
Redshift
Git
dbt
Junior, Mid and Senior level
Vancouver
Two Circles

Data-driven sports marketing

Job no longer available

Two Circles

Data-driven sports marketing

501-1000 employees

B2BMarketingContentAnalyticsAdvertisingSportsData AnalysisMediaSales

Job no longer available

Salary not provided
SQL
AWS
Python
Athena
Redshift
Git
dbt
Junior, Mid and Senior level
Vancouver

501-1000 employees

B2BMarketingContentAnalyticsAdvertisingSportsData AnalysisMediaSales

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

Share this job

View 15 more jobs at Two Circles

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

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 headshot

Freddie

Company Specialist at Welcome to the Jungle