Consultant

Two Circles · New York City · $70,000–$95,000 (stated in the posting)

Apply on the company website

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.  

Scope of Role 

This role will focus on delivering custom Business Intelligence and Advanced Analytics solutions to clients, including data integration, database management, data modeling, data visualizations, automation, and predictive analytics utilizing fan data. The role requires strong technical proficiency in SQL, relational databases, and business intelligence tools, with opportunities to leverage technologies such as AWS and Python. 

The ideal candidate is technically proficient, self-driven, detail-oriented, and highly collaborative, with strong analytical and problem-solving skills. They should be comfortable independently working with complex datasets, troubleshooting technical challenges, and developing scalable analytical solutions. Strong communication skills, a consultative mindset, and a customer service-oriented approach are essential for effectively collaborating with internal teams and external clients. 

Job Description 

The role will require the candidate to be responsible for: 

Analyzing Business Needs and Providing Data-Driven Solutions 

• Work closely with clients to understand their business objectives, technical requirements, and data challenges. 

• Translate business needs into technical solutions, identifying opportunities to leverage data, analytics, and automation to optimize processes, improve performance, and drive growth. 

• Independently develop and implement tailored analytical solutions that align with client objectives and technical environments. 

SQL Development, Database Management & Data Integration 

• Develop, optimize, and troubleshoot complex SQL queries, database views, and data models to support reporting, business intelligence, and advanced analytics. 

• Work with large datasets across relational databases and cloud-based data warehouses, ensuring efficient data structures, query performance, and data integrity. 

• Integrate, transform, and validate data from multiple sources, supporting data quality initiatives and collaborating with technical teams on data pipelines and ETL/ELT processes. 

Conducting Advanced Data Analysis and Modelling 

• Collect, clean, transform, and analyze complex datasets from multiple sources to identify trends, patterns, and actionable insights. 

• Apply analytical techniques to support business use cases such as customer segmentation, fan engagement analysis, lead scoring, and customer lifetime value. 

• Support the development of predictive models and statistical analyses, leveraging SQL and, where applicable, Python or other analytical tools to develop repeatable and scalable solutions. 

Business Intelligence, Data Visualization & Communication 

• Design, develop, and maintain dashboards, reports, and data visualizations using Tableau, Power BI, or similar business intelligence platforms. 

• Develop underlying data models, SQL queries, and calculations to support accurate reporting, while identifying opportunities to automate and optimize analytical processes. 

• Translate complex analytical findings into clear, actionable insights and strategic recommendations, effectively communicating results to technical and non-technical stakeholders. 

Essential Skills 

• Experience: 3–5 years of hands-on analytics experience, preferably in the sports and entertainment industry. 

• SQL and Data Querying: Advanced SQL proficiency required, including independently writing, optimizing, and troubleshooting complex queries involving joins, CTEs, window functions, aggregations, and data transformations across multiple data sources. 

• Database Management: Strong understanding of relational database systems such as MySQL, PostgreSQL, SQL Server, or AWS Redshift, including database structures, data modeling, table relationships, and query performance optimization. 

• Data Integration and Transformation: Experience integrating, cleaning, transforming, and validating data from multiple sources. Familiarity with database views, stored procedures, and ETL/ELT processes. 

• Business Intelligence and Visualization: Strong proficiency in Tableau, Power BI, Looker, or similar tools, including developing dashboards, underlying data models, and automated reporting solutions. 

• Data Analysis: Strong analytical skills with experience working with large datasets, identifying trends, and applying analytical methodologies to solve business challenges. 

• Data Storytelling: Ability to translate complex datasets and analytical findings into clear, compelling narratives that influence decision-making and communicate insights to technical and non-technical stakeholders. 

• Technical Problem-Solving: Ability to independently investigate data discrepancies, troubleshoot SQL and reporting issues, and identify opportunities to improve data quality and analytical processes. 

• Business Acumen: Ability to translate business requirements into technical solutions and align analytical approaches with organizational objectives. 

• Collaboration: Ability to work independently and collaboratively across technical and non-technical teams while effectively managing deliverables and communicating with stakeholders. 

• Attention to Detail: Commitment to accuracy, consistency, and reliability in data analysis, reporting, and database management. 

Preferred Skills 

• Programming and Scripting: Experience with Python, R, or similar languages for data manipulation, automation, and advanced analysis. 

• Cloud Technologies: Familiarity with cloud-based data environments, preferably AWS, including services such as Redshift, S3, Glue, or Athena. 

• Advanced Analytics: Exposure to statistical modeling, predictive analytics, machine learning, customer segmentation, lead scoring, or customer lifetime value modeling. 

• Data Engineering: Experience developing or maintaining ETL/ELT pipelines, stored procedures, and automated data workflows. 

• CRM and Marketing Technologies: Understanding of CRM systems, preferably Salesforce or Microsoft Dynamics, and experience working with customer, ticketing, or marketing automation data. 

• Industry and Platform Knowledge: Experience in sports and entertainment analytics and knowledge of the KORE Intelligence Platform or similar customer data platforms. 

The range below represents the low and high end of the base salary someone in this role may earn as an employee of Two Circles in the United States. Salaries will vary based on various factors including but not limited to professional and academic experience, training, associated responsibilities, and other business and organizational needs. The range listed is just one component of our total compensation package for employees. Salary decisions are dependent on the circumstances of each hire. 

• $70,000-$95,000 

More jobs at Two Circles · Marketing & Comms jobs in New York