Senior Technical Analyst

Role Overview

• 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

Tech Stack

• Amazon Redshift
• AWS
• Cloud
• ETL
• Python
• SQL
• Tableau

Benefits

• Access to health benefits
• Professional development opportunities
• Flexible working arrangements
• Paid time off