Data Engineer

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 holder of the Data Engineer position is responsible for building data systems and developing and managing infrastructure and data pipelines that collect and process data according to AEG and AEG Sports needs and business goals. Having a high attention to detail and a desire to learn and develop are essential attributes as AEG and AEG Sports look to develop their data strategy and become support data driven decision making. The role will support the AEG and AEG Sports teams developing the pipelines for ingesting new data sources, preparing data to support analytics and visualization teams and working with the other team members to QA and monitor all elements of the data environments.

Essential Duties

• Work with the Manager, Data Platforms, other members of the data team and AEG Sports Business Ops and Strategy team to manage and support all existing data related requests related to the AEG, AEG Sports and other data environments.
• Engineer, manage and monitor ETL (Extract, Transform, and Load) and data pipeline tasks using available tools as required to consume new sources of data into the respective data environments.
• Support the development of data models and provide guidance for optimizations and improvements to improve performance of data infrastructure and related products.
• Proactively monitor and remediate issues with the data held and processed within the AEG and AEG Sports data ecosystem, including the development and publication of data quality and hygiene reports and the identification of new sources of data and validation methods.
• Ensure that all data flows and the data environment as a whole are documented, including creating ERDs, and that source control policies are followed
• Engage with and build relationships with internal customers, including business leaders within AEG Sports, other entities and with external suppliers to ensure that data is made available and exposed to support business requirements
• Provide support as required to data analysts and ML specialists as regarding data environments as required.
• Ensure that all data protection, security and governance policies and implemented and adhered to, particularly in relation to PII and other sensitive data

Required Qualifications

• BA/BS Degree (4-year) Computer Science, Engineering, or a related technical area
• 4-6 Years Related technical experience
• Experience of working with Big Data Technologies such as Hadoop, Spark or Databricks
• Experience of Azure SQL Database, Azure Synapse, Azure Data Factory and other Azure services, including NoSQL technologies.
• Experience of creating and managing database objects (tables, views, indices, stored procedures, UDFs, triggers, etc.)
• Strong understanding of ETL, Big Data technologies and/or programming languages such as Python, Pyspark, Scala and experience using these languages to develop reliable and robust data pipelines and data solutions
• Knowledge of SQL Server components
• Strong attention to detail and commitment to data quality
• Must be able to prioritize workload and manage complex requirements from diverse stakeholders.
• Strong communication skills and ability to work with all levels of employees; must be able to communicate technical aspects to non-technical team members
• Ability to work independently to accomplish work objectives, as well as in a team environment.
• Experience of or interest in Sports (specifically Hockey) and/or the Live Entertainment industry.

Paycale: $112,444 - $147,583

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 their normal description.