Create analytical frameworks, models, reporting structures, visualizations, analyses, and evidence-based tools and strategies to aid in empowering leadership’s ability to make decisions in a disciplined, intentional, and effective manner
Work closely with both the data warehouse provider (KORE) and the internal engineering team to ensure all data pipelines and ETLs are stable, information is aggregated appropriately, data quality standards are maintained, and reporting is accurate
While this role is not a Data Engineering role in the classic sense of that title, this individual will also be expected to maintain a working knowledge of technical coding (e.g. Python, R), and serve in a support capacity to those with that associated primary function
Lead full-lifecycle projects – from documentation of requirements through design, user testing and delivery – and define trackable and impactful KPI’s and success criteria that are digestible, defensible, and actionable for a given project, and associated regular status updates thereafter, with a few examples including:
Building and maintaining dashboards and other data visualizations that aid leadership in understanding high-level organization and project status
Constructing models that provide real-time pricing recommendations for key products (tickets, partnership assets, parking, etc.), and work with those departments to validate, implement, and track resultant proposed changes
Continuously analyze, and propose optimizations to, the organization’s technology stack while implementing research-based industry best practices
Maintain ‘first-pass’ responsibility for associated business-related artifacts, such as: slide decks, one-sheeters, analytical frameworks and models, data visualizations and dashboards, project ROI calculations, team status reports, product roadmaps, etc.
Cultivate strong stakeholder relationships with client department leads that foster effective cross-functional collaboration and alignment
Support other ongoing business projects and priorities within and involving client functions on an ad-hoc basis as needed
Requirements
Bachelor’s degree or higher in Computer Science, Computer Engineering, Information Technology, Mathematics, Management Information Systems, or related analytical field (or equivalent experience)
5+ years of sports, data analytics, finance, corporate strategy and/or management consulting experience, with a preference for roles in those industries that were highly technical and data-focused
Demonstrated understanding of ETL processes and relational databases in both normalized and de-normalized models; a broader understanding of complex digital ecosystems and metrics available for collection a strong plus
Ability to write and interpret complex SQL queries in support of ETL processes or BI reporting; strong SQL server development knowledge preferred
Experience with data analytics-related tools (e.g. R, Stata, Python, Excel Power Query) and data visualization platforms (e.g. Tableau, Microsoft PowerBI)
Experience with an ESP; e.g. Salesforce Marketing Cloud (or Eloqua, HubSpot, etc.)
Experience with a CRM application; Salesforce preferred (alternate experience such as Microsoft Dynamics also considered)
Experience augmenting any of the aforementioned platforms with tools such as Python, custom APIs, and advanced SQL to support complex use cases a plus.
Familiarity with AWS / Redshift (or similar database platforms) also a plus.
Experience with Ticketmaster Archtics, KORE, and/or similar platforms, and industry concepts related to ticket sales, pricing analytics, and dynamic pricing strongly preferred
Experience with Microsoft Office required; advanced Excel and PowerPoint skills strongly preferred
Excellent written and verbal communication skills, with high attention to detail
Highly resourceful and disciplined, with strong emotional intelligence and self-motivation
Experience and comfort with client-facing presentations and interaction
Comfort with and disciplined to manage highly sensitive confidential information
Willingness to work periodic nights and weekends –to support time-sensitive business needs, and travel