Junior Analytics Engineer

A global sports agency connecting fans with sport properties using data, working with major organizations like NFL, Premier League, Formula 1, Wimbledon and UEFA.
Data
Entry-Level Software Engineer
In-Person
501 - 1,000 Employees
Sports

Description For Junior Analytics Engineer

Two Circles, a four-time Sport Industry Agency of the Year, is seeking a Junior Analytics Engineer to join their growing team of over 950 professionals across 14 global cities. As part of the KORE Planning and Insights Team, you'll play a crucial role in delivering business intelligence and analytics solutions to some of the world's biggest sports organizations including the NFL, Premier League, Formula 1, and UEFA.

This position focuses on data engineering and analytics, where you'll be responsible for developing and optimizing ETL/ELT pipelines, creating SQL scripts, and maintaining data warehouse infrastructure. You'll work with cutting-edge technologies including AWS, SQL, and Python to build robust data solutions that power critical business decisions.

The ideal candidate should be self-motivated, detail-oriented, and possess strong technical skills in SQL, Python, and data warehousing concepts. You'll have the opportunity to work with both internal teams and external clients, requiring excellent communication skills to translate technical concepts to non-technical stakeholders.

This role offers a unique opportunity to combine technical expertise with a passion for sports, working on projects that directly impact how fans interact with major sporting events and organizations. You'll be part of a team that values innovation, collaboration, and technical excellence, while contributing to the continued growth of a globally recognized sports agency.

Working from our New York office, you'll be immersed in a dynamic environment where you can develop your skills in data engineering, analytics, and consulting while making a real impact in the sports industry. If you're passionate about data, sports, and building solutions that connect millions of fans with their favorite sports properties, this role presents an excellent opportunity to grow your career in a rapidly expanding global organization.

Last updated 6 days ago

Responsibilities For Junior Analytics Engineer

  • Assist in development and optimization of ETL/ELT pipelines using AWS and SQL technologies
  • Design and modify relational database structures and data flows within the data warehouse
  • Maintain DAGs to manage workflows
  • Support stakeholders with their data infrastructure
  • Integrate data from different sources to create unified views
  • Implement data quality checks and validation routines
  • Build and standardize optimized SQL scripts
  • Monitor performance of automations and integrations
  • Develop SQL scripts for CRM, Email Marketing, and other integrations
  • Investigate data discrepancies and troubleshoot client queries
  • Maintain documentation on processes

Requirements For Junior Analytics Engineer

Python
  • Proven command of SQL and relational databases
  • Working knowledge of 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
  • Familiarity of database marketing and the sports industry
  • Attention to detail and ability to work with deadlines

Interested in this job?

Jobs Related To Two Circles Junior Analytics Engineer

Data Engineer I - Licensing

Entry-level Data Engineer position at Spotify focusing on building and maintaining enterprise data products for industry partners.

Junior Data Engineer - Brazil/Remote

Entry-level remote data engineering position at MixRank, working with PostgreSQL, Python, and Linux to process petabytes of data for B2B SaaS products.

Data Conversion Programmer

Entry-level Data Conversion Programmer position at NISC, working with SQL and ETL tools in a hybrid work environment across multiple US locations.

(Fluent English) Junior Web Data Engineer (Python)

Remote Junior Web Data Engineer position requiring Python expertise, web scraping experience, and Linux knowledge at SupportYourApp.

Data Engineer I, Global Engineering Insights & Software Tools (GEIST)

Entry-level Data Engineer position at Amazon's GEIST team, focusing on building data platforms and ETL pipelines using AWS technologies.