The company runs live events across music, sports and entertainment, and its music division, AEG Presents, operates tours, concerts and music festivals. The business is based in Los Angeles.
This Data Analyst role sits mainly in the Digital department and reports to the Director of Consumer Analytics. The work touches data across the whole company.
Current work includes improving data quality, functionality and strategy across several in-house products used for marketing, booking, accounting and other functions, plus restructuring datasets and making the database more relational.
You will turn analysis into insights that help the marketing side of the business. Strong puzzle-solving, careful attention to detail, teamwork and a drive to keep learning are expected.
Responsibilities
Review current data models and consolidation work, and find ways to improve them.
Set up processes to monitor, track and trend department data.
Build marketing analytics reports across business units that support targeted experiences based on personal preferences, spending power and other consumer traits.
Work with the Email and Paid Media teams to build specific segmented affinity audiences.
Research, develop and document new standard reports and processes for internal, external and enterprise clients.
Expand the data warehouse by indexing existing datasets and adding new ones.
Pull and combine large datasets from several systems, and analyze them to spot outliers.
Explore user behavior, segmentation, cohorts and conversion funnels on your own initiative.
Apply analytics software and systems to meet department and company goals for marketing live events.
Run financial and operational analysis using in-house and third-party operational, transactional and financial data, and build visual business performance reports for AEG Presents management across departments such as festivals, venues and touring.
Requirements
A 4-year bachelor's degree (BA or BS).
2-4 years of related work experience.
Strong quantitative skills to draw insights from large datasets, with close attention to detail and a habit of solving hard problems creatively.
Clear written and verbal communication, including presenting technical findings to non-technical audiences.
Solid general business sense, with the ability to assess the live events industry and suggest improvements.
Quick learning and the ability to manage projects independently.
Working knowledge of Python and/or R.
Proficiency in SQL and experience with visualization tools such as Domo, Tableau or Power BI.
Experience in music or other entertainment is a plus. Passion for music and familiarity with artists and industry trends is preferred.
Basic understanding of financial statements, such as profit and loss and balance sheets, is preferred.
Conditions
Full-time role with a pay range of $81,000 - $109,785.00.
This position is not eligible for a bonus under the current bonus plan requirements.
The employer does not offer work visa sponsorship for this position.
The company may change or modify the job description at any time, orally or in writing, and may ask you to perform duties outside your normal description.
The company is an equal opportunity employer and makes hiring decisions in line with applicable employment laws.
Benefits
Medical, dental and vision insurance.
Paid holidays, vacation and sick time.
Company-paid basic life insurance and optional voluntary life insurance.
Parental leave.
401k plan with a current employer match of 3%.
Flexible spending and health savings account options.