Analytics Engineer, Two Circles
Salary not provided
SQL
AWS
Python
Tableau
Excel
Power BI
Azure
Redshift
Junior and Mid level
Los Angeles
Data-driven sports marketing
Open for applications
Data-driven sports marketing
501-1000 employees
B2BMarketingContentAnalyticsAdvertisingSportsData AnalysisMediaSales
Open for applications
Salary not provided
SQL
AWS
Python
Tableau
Excel
Power BI
Azure
Redshift
Junior and Mid level
Los Angeles
501-1000 employees
B2BMarketingContentAnalyticsAdvertisingSportsData AnalysisMediaSales
Company mission
To use data to grow the value of sports.
Role
Who you are
- The ideal candidate for this position will be self-motivated, a solutions-provider, detail-oriented, data-focused, and have a strong ability to work well in a team-based setting
- Proven command of SQL and relational databases
- Working knowledge of programming languages such as Python
- Understanding of data warehouse and ETL tools like Amazon Redshift
- Familiarity with cloud computing tools such as AWS and Azure
- Experience in automation and scripting
- Familiarity with basic data visualizations in Excel, Tableau, or PowerBI
- Strong organizational, analytical, and technical skills
- Excellent interpersonal, verbal, and written communication skills – must be able to communicate completes ideas to both technical and non-technical individuals
- Familiarity of database marketing and the sports industry
- Ability to communicate professionally in both a written and verbal context with external end-users and internal colleagues
- Attention to detail, ability to work with deadlines, and ability to coordinate across multiple departments
What the job involves
- KORE Planning and Insights Team consults with clients on a variety of business intelligence, strategy, and reporting initiatives
- While understanding Enterprise Clients business objects, this team member will work with the clients to offer the best solutions and accomplish their technical goals
- This role will report to the Consultant, Enterprise Data & Analytics and be responsible for collaborating with other members of the KPI team
- This role will mainly assist in SQL script writing, creating and monitoring automated processes, optimizing databases, and ETL processing
- This role will also ask the candidate to collaborate both with internal and external teams
- This position will devote their time writing custom scripts to power standardized views, automations, and data warehousing. Although we expect this role to expand as skills and experience grow, the following is an estimated breakdown of where we expect this individual’s time to be allocated in main categories of tasks:
- Assist in development and optimization of ETL/ELT pipelines from various data sources using AWS and SQL technologies
- Design, development, and modify relational database structures, relationship, and data flows within the data warehouse
- Understand and maintain DAGs to manage workflows
- Working with stakeholders to support their data infrastructure
- Integration data from different sources to create a unified view of the data
- Implement data quality checks and validation routines to ensure accuracy, consistency, and completeness of data
- Support in the development of machine learning models by combining data from multiple data sources
- Build and standardize optimized SQL scripts
- Proactively monitor performance of automations and integrations
- Develop SQL scripts to be used in automations for CRM, Email Marketing, and other integrations
- Investigate data discrepancies and troubleshoot client queries
- Help maintain the quality of data used in day-to-day analysis or scripts
- Maintain documentation on processes developed
- Communicating via phone, email, face-to-face and virtual meetings with customers
- Analyze and define tasks, data flows, and dependencies in relation to project deliverables
- Work cross-departmentally to continue to develop KORE’s reporting products
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
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
- Tickets to sporting 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
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 15 more jobs at Two Circles