Data Modeling Analyst, Sr. jobs in Long Beach, CA

For more than 20 years, AEG has played a pivotal role in transforming sports and live entertainment. Annually, we host more than 160 million guests, promote more than 10,000 shows and present more than 22,000 events around the world. We are committed to innovation, artistry, and community, and leverage the power of our 300 venues, leading sports franchises, marquee music brands, integrated entertainment districts, premier ticketing platform and global sponsorship activations, to create memorable moments that give the world reason to cheer. 

Our business is interwoven with the human mind and heart, and we strive to build a diverse and inclusive company that reflects the artists, athletes, and fans that we host; reach beyond traditional boundaries to support the communities in which we operate; and minimize our impact on the environment by adopting sustainable practices throughout our business operations. 

If you want to be challenged to up your game and make a difference, then join us in giving the world reason to cheer!

Position Summary:

The Sr. Data Analyst is in responsible for aggregating and analyzing data across business units to provide actionable insights for our organization through the creation of reports, dashboards, and analysis. This role collaborates with all departments to aid in finding ways to utilize data to improve revenue and efficiency within our organization. Responsibilities include prototyping new impactful data visualizations, deploying analytic solutions, and enhancing existing reports and dashboards.

The Sr. Data Analyst will work for the LA Galaxy with dotted line reporting to the LA Kings BI team.

Essential Functions:

• Create, manage and enhance reports across all departments to effectively communicate results of business strategies by using analytical tools such as PowerBI, SQL, SAS, R, or Python
• Collaborate with ticketing team to ensure all needed reports are delivered to sales team and leadership including sales standings, daily sales reports; Validate data, identity trends to improve sales efforts.
• Work with the Data Engineer to ensure data is structured properly for analysis to ensure the data desired is received. Effectively communicate with leadership team to understand issues/discrepancies and work with Data Engineer to correct any issues.
• Build profiles of the team and venue customers (demographic, geographic and psychographic) to help sales, marketing and sponsorship efforts; Work with teams to ensure reports are delivering needed data and expectations are being met and surpassed.
• Support the CRM/Email team in analyzing data to provide recommendations on improving teams use of platforms.
• Assist with market research efforts and providing insights to business leaders including surveys and focus groups.
• Work with Global Partnerships team to track effectiveness of sponsor activations, specifically regarding all measurable aspects of agreements by aggregating data and identifying trends in digital platforms.
• Support the digital media team with routine reports, summaries and insight into all digital media metrics, including website, social media and video.
• Present reports and analysis to the business stakeholders.

Required Qualifications:

• BA/BS Degree (4-year) Mathematics, Computer Science, Statistics or Analytics
• 4-6 years Related work experience
• Experience with working with ticketing or transactional data
• Experience with ticketing systems such as Veritix preferred
• Experience with database systems such as AWS preferred
• Experience using BI tools (PowerBI/Tableau/Looker) to create interactive data visualizations and reports.
• Experience, proficiency, and working knowledge of SQL and data warehousing

Pay Scale: $75,000 - $90,000

AEG reserves the right to change or modify the employee’s job description whether orally or in writing, at any time during the employment relationship. AEG may require an employee to perform duties outside his/her normal description.