Chicago, IL, USA
3 days ago
Data Engineer

LEGENDS & ASM GLOBAL

Two powerhouse companies have joined forces to redefine excellence in sports, entertainment, and live events. Together, we combine unmatched expertise with a global reach, offering end-to-end solutions – from venue development and event booking to revenue strategy and hospitality.

Legends brings a 360-degree, data-driven approach across Global Partnerships, Hospitality, Merchandise, and Attractions, working with top-tier clients to deliver exceptional experiences.

ASM Global, the world leader in venue management and live event production, oversees 350+ iconic venues stadiums, arenas, conventions centers and theaters.

Our organization is committed to building an inclusive, innovative environment where differences drive solutions that benefit our team members, guests, and partners. Guided by our values of respect, integrity, and accountability, we create a workplace where everyone can succeed. Are you ready to be part of the team that is transforming live entertainment? Join us to make legends happen!

THE ROLE

As a pivotal team member, the Data Engineer will support developing and managing tools and processes crucial for our data-driven decision-making. Your role encompasses end-to-end data management, pipeline development, storage, optimization, and governance across various verticals like food and beverage, e-commerce, digital marketing, event ticket sales, and consumer analytics. As a small and agile team, we take an "all hands on deck" approach, fostering an environment where you can take the lead on projects, provide and implement recommendations, and bring your own solutions to life.

ESSENTIAL FUNCTIONS

Develop performant and scalable data pipelines (ETL/ELT) using PL/SQL, Python, and data transformation/IaaS platforms (ex. SSIS, Azure Data Factory, Fivetran).Develop processes for data cleansing, matching name and address data, and data enrichment (ex., demographics, and firmographics).Deploy data storage solutions capable of handling structured and unstructured data effectively.Normalize and denormalize transactional data for integration into the data warehouse or data lake house architecture.Advocate for and implement best practices and SOPs in alignment with DevOps (CI/CD) principles.Adhere to change management and version control protocols (ex., Bitbucket, GitHub).Deliver solutions focusing on time-to-market, quality, accuracy, efficiency, and scalability.Translate business specifications into technical design specifications and code.

QUALIFICATIONS

Bachelor’s degree in computer science or related fieldOver three years of hands-on experience in data integration development.Data pipelines to and from relational databases (Azure/SQL Server, Postgres SQL, Oracle), CRMs (e.g., Salesforce, Hubspot), marketing automation (ex. Klaviyo, Salesforce Marketing Cloud), and e-commerce platforms (ex. Shopify, Big Commerce).A demonstrated proficiency with Microsoft data services including Azure Data Factory, Azure SQL Database, Azure Function, Azure Blob Storage, SQL Server and SSIS.Proven expertise in using Python for data pipelines, analysis, or transformations.Advanced skills in connecting to data sources using standard protocols such as HTTPS, ODBC/JDBC, sFTP, and S3, facilitating the ingestion of structured and unstructured data formats like CSV and JSON.Experience designing database structures for data science (ex. Python) and visualization (ex. Tableau)Experience with handling PII data and associated policies and compliance requirements (Preferred)Working knowledge of data governance best practices and data privacy policies (Preferred)

COMPENSATION

Competitive salary, commensurate with experience, and a generous benefits package that includes medical, dental, vision, life and disability insurance, paid vacation, and 401k plan.

WORKING CONDITIONS

Location: Hybrid (Chicago, IL or Dallas, TX)

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

NOTE:

The essential responsibilities of this position are described under the headings above. They may be subject to change at any time due to reasonable accommodation or other reasons. Also, this document in no way states or implies that these are the only duties to be performed by the employee occupying this position.

Legends & ASM Global is an Equal Opportunity/Affirmative Action employer, and encourages Women, Minorities, Individuals with Disabilities, and protected Veterans to apply. VEVRAA Federal Contractor.

Por favor confirme su dirección de correo electrónico: Send Email