Consultant, Two Circles

• 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

Desirable

• 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
• 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
• 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
• 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
• 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