Demo
Salary Resume Critique Job Openings

Analytics Engineer

TwoCircles Inc
Los Angeles, CA Full Time
POSTED ON 1/16/2025
AVAILABLE BEFORE 4/13/2025

We are Two Circles. We grow audiences and revenues. We do that by knowing fans best. We work with clients to help them understand & influence what their fans are doing – the way fans spend their money, the events that fans attend, the channels fans respond to, the content fans watch and more. And we use the understanding this gives us to help our clients grow. Grow their audiences and grow their revenues - both direct to consumer and business to business revenues. Our platforms and services are trusted by over 900 clients globally, including the English Premier League, Red Bull, UEFA, VISA, the NFL, Nike and Amazon. We are almost 1000 people, based out of 14 offices, and we deliver work for sports and entertainment businesses of all shapes and sizes all over the world

Kore is a fan, partnership and revenue intelligence platform for the sports & entertainment business.

This role will mainly assist in SQL script writing, creating and monitoring automated processes, optimizing databases, and ETL processing.

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.  This role will also ask the candidate to collaborate both with internal and external teams.

Duties and Responsibilities

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 :

ETL Processing

  • 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

SQL Script Writing

  • 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

    • Communication & Consultation

  • 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

    • Requirements

    Skill Requirements

  • 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

    • If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Analytics Engineer?

    Sign up to receive alerts about other jobs on the Analytics Engineer career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $92,929 - $122,443
    Income Estimation: 
    $122,257 - $154,284
    Income Estimation: 
    $68,745 - $88,154
    Income Estimation: 
    $87,428 - $116,878
    Income Estimation: 
    $91,609 - $116,575
    Income Estimation: 
    $129,640 - $165,363
    Income Estimation: 
    $151,182 - $194,086
    Income Estimation: 
    $91,609 - $116,575
    Income Estimation: 
    $115,838 - $142,817
    Income Estimation: 
    $114,981 - $143,201
    Income Estimation: 
    $114,981 - $143,201
    Income Estimation: 
    $129,640 - $165,363
    Employees: Get a Salary Increase
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at TwoCircles Inc

    Fan Data & Analytics Manager
    TwoCircles Inc
    Hired Organization Address Los Angeles, CA Full Time
    We are Two Circles. We grow audiences and revenues. We do that by knowing fans best. We work with clients to help them u...
    TwoCircles Inc is hiring: Lead Consultant - Content in New York
    TwoCircles Inc
    Hired Organization Address New York, NY Full Time
    We are Two Circles. We grow audiences and revenues. We do that by knowing fans best. We work with clients to help them u...
    View More Jobs at TwoCircles Inc

    Not the job you're looking for? Here are some other Analytics Engineer jobs in the Los Angeles, CA area that may be a better fit.

    Quality Assurance Engineer

    ShiftCode Analytics, Los Angeles, CA

    Analytics Engineer

    AXS Group, Los Angeles, CA

    View More Jobs

    AI Assistant is available now!

    Feel free to start your new journey!