LA Kings - Associate Data Engineer at Aegworldwide

Company Information 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! JOB DESCRIPTION: The Associate Data Engineer will build and maintain the data systems, infrastructure, and pipelines that power analytics across the LA Kings and AEG Sports. This role is responsible for developing reliable data ingestion processes, preparing and transforming data for use by analytics and visualization teams, and ensuring all data environments are properly monitored, tested, and quality controlled. The Associate Data Engineer will work closely with team members across the organization to support new data sources, enhance existing workflows, and enable data driven decision making. ESSENTIAL FUNCTIONS: • Engineer, manage, and monitor ETL (Extract, Transform, Load) and data pipeline tasks; use available tools as required to consume new sources of data into the respective data environments. • Work with other members of the engineering and analytics teams to manage and support all existing data-related requests for the LA Kings, Ontario Reign, AEG Sports, and other data environments. • Provide support as required to data analysts and data scientists regarding data availability, production, and dashboard needs. • Support the development of data models and provide recommendations for optimizations and improvements to the data infrastructure and related products. • Proactively monitor and remediate issues with the data held and processed within the LA Kings and AEG Sports ecosystem, including the development and publication of data quality and hygiene reports. • Ensure all data flows, and the data environment, are documented, including ERDs. • Engage with and build relationships with internal customers, including business leaders, other entities, and external partners, to ensure data is available and accurate to support business requirements. • Ensure that all data protection, security, and governance policies are implemented and adhered to, particularly in relation to PII and other sensitive data. SPECIFIC JOB KNOWLEDGE, SKILL AND ABILITY: The Associate Data Engineer must possess the following knowledge, skills and abilities and be able to explain and demonstrate that he or she can perform the essential functions of the job, with or without reasonable accommodation, using some other combination of skill and abilities: • Strong understand of ETL, and programming languages such as Python, Pyspark, • Strong attention to detail and commitment to data quality • 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, while also thriving in a team environment QUALIFICATION STANDARDS: Education: • BA/BS Degree (4-year) mathematics, engineering, physics, or related quantitative field Experience: • 0-2 years related experience • Experience as a data engineer, analytics engineer, or equivalent • Prior experience with Databricks, Spark, Hadoop, or other big data technologies • Prior experience with Azure SQL Database, Azure Data Factory, and other Azure services, including NoSQL technologies • Prior experience creating and managing database objects (including tables, views, indices, UDFs, triggers, etc.) • Experience or interest in sports/live entertainment a plus Payscale: $40.00 - $45.00/hr Bonus: This position is not eligible for a bonus under the current bonus plan requirements. Benefits Full-time: We offer a comprehensive benefits package that includes: medical, dental and vision insurance, paid holidays, vacation and sick time, company paid basic life insurance, voluntary life insurance, parental leave, 401k Plan (with a current employer match of 3%), flexible spending and health savings account options, and wellness offerings. 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. AEG's policy is to hire the most qualified applicants, and we comply with all applicable federal, state and local employment laws in making hiring and employee decisions. We are an equal opportunity employer and do not discriminate against applicants or employees on the basis of race, color, marital status, disability, religion, age, sex, sexual orientation, national origin, genetic information, veteran status, or any other legally protected status recognized by applicable federal, state or local law. Employer does not offer work visa sponsorship for this position. #LI-LAKings #LI-Onsite