Consultant, Data Analyst, IT​/Tech

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.

The role will require the candidate to be responsible for:

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

• 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:
  Exper…