Skip to content
Talento
Sign inGet started

Talento

Upload your CV, set your preferences, and find jobs that fit.

PrivacyTermsCookiesAccessibility

← All roles

Consultant

at Twocircles

New York, United States, mid, full time, USD 70,000–95,000 / year, 3–5 years

seen 4d ago

Apply for this roleSign in to track your application
  • S3
  • Business Intelligence
  • Power BI
  • AWS Redshift
  • PostgreSQL
  • AWS Athena
  • AWS Glue
  • Tableau
  • SQL Server
  • Microsoft Dynamics
  • ELT
  • Looker
  • SQL
  • R
  • Relational Databases
  • MySQL
  • Data Visualization
  • Data Modeling
  • ETL
  • AWS
  • Python
  • Salesforce

About the role

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.

Read from twocircles.com, last seen 4d ago.

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.

What they are looking for

* 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

Apply now

GET IN Touch

See our offices

would you like to visit your regional two circles site?

go to \ site dismiss