Senior Data Engineer - El Segundo

Tickets.com, an MLB company, delivers innovative, cutting-edge technologies to enable frictionless and unforgettable fan experiences in venues across the globe. Together with MLB, Tickets.com is changing the landscape of the live sports and entertainment industry, delivering new digital venue and ticketing experiences to millions of fans. Our Technology team builds platforms and products that provide a new smart ticketing solution and venue experience. Using cutting-edge technology, our platform and applications are consumed by fans, stadiums, and MLB teams

We are assembling a world-class team to build on these experiences, to scale platforms and products that anticipate emerging opportunities, including dynamic pricing and offers and digital, contactless ticketing. Our mission is to provide premium, innovative live experiences for our clients and their patrons.

Tickets.com is looking for a Senior Data Engineer passionate about building engaging products for our fans. 

The Opportunity: The Data Engineering team at Tickets.com builds and maintains data pipelines to integrate baseball fan interaction and transaction data from hundreds of sources into our Data Warehouse for use by our Business Intelligence, Data Science, Analytics, Marketing, Ticketing, Finance, and other internal business teams. In addition, we share this data with all 30 MLB Clubs, and interact with Club staff on a regular basis to ensure they are able to better understand and interact with their fans as well as run ticketing operations using this data.

We leverage modern, real-time data-streaming solutions for all of our new data pipeline development, and we love it! We are moving towards Google BigQuery as our Data Warehouse platform. We’re Pythonistas, and regularly develop complex Python scripts to interact with APIs and data stores. And SQL is the lingua franca across all of the teams in our organization that interact with our Data Warehouse, so we speak it fluently.

The Senior Data Engineer will be responsible for accelerating and solidifying the Data Engineering team’s development, deployment, and operational support practices by building tools leveraged by the entire Data Engineering team. In addition, the Senior Data Engineer will build new data pipelines and enhance and troubleshoot existing ones.

The Senior Data engineer will report directly to the Director, Ticketing Data Engineering and interact regularly with our team of Senior, Mid, and Junior Data Engineers.

Essential Job Functions:

• High Impact - You’ll develop tools and processes leveraged by the entire Data Engineering team, and work on data sets leveraged to measure fan behavior, enhance our products, optimize marketing pipelines, and directly impact our business’ bottom line.
• Broad Range of Technology - You’ll have the freedom to use the right tools for the job, whether it’s vanilla SQL or a distributed processing framework such as Apache Spark. We run our processes within Google Cloud Platforms ecosystems, so we can take advantage of their managed services such as Oracle and BigQuery database administration to help us get the job done better or faster.
• Diverse Data Sources - You’ll work with hundreds of fan engagement data sources, including: Ticket sales from TicketMaster, Tickets.com, StubHub and other ticket brokers; additionally you will help construct data pipelines and analytics solutions to support the buildout of an enhanced MLB-controlled ticketing eco-system that supports broker-to-fan and fan-to-fan ticket exchanges.
• Diverse Data Sizes - Sure, we’ve got “Big Data” - but we also have plenty of valuable small and mid-size data sets too. You won’t be forced to use complex distributed technologies on small but valuable data sets where using them would be overkill - you’ll get to make decisions on the proper framework for each particular use case.
• Lead and Coach – You’ll mentor junior Data Engineers, and review design and code produced by them.
• Build and Support – You’ll embrace the DevOp mentality to build and support data applications in the cloud. You’ll deploy using infrastructure as code, ensuring that servers are treated like cattle, and not pets. You will help define processes that support CI/CD

Requirements:

• 7+ years of experience working on cloud data warehouses and data pipelines with a focus on data engineering and providing technical leadership building scalable and secure data platforms and systems powering intelligent applications.
• Expertise in Python, specifically interacting with data APIs and automating tasks.
• Expertise in SQL.
• Experience working with large (Terabyte-scale) data sets
• Experience with an MPP Data Warehouse such as BigQuery, Oracle Exadata, Redshift, or Teradata
• Experience with GCP, OCI, AWS, or Snowflake.
• Comfort in a Linux environment and with basic server administration tasks.
• Significant previous experience in a Data Engineering or ETL Engineering role.
• Experience with GitHub.

Preferred Qualifications:

Experience with any/all of the following:

• Apache Airflow
• Google BigQuery
• Oracle RDBMS
• DevOps - Jenkins/Ansible/Terraform
• Docker / Kubernetes
• Informatica PowerCenter, Mulesoft, RabbitMQ (used for legacy data pipelines)
• Tableau and Jaspersoft (for operational reporting)

Required Education:

Bachelor’s degree or better in Computer Science or a related technical field or equivalent job experience

 Pay Range: $165-185K

We offer an Outstanding Benefits Package that includes:

• Medical
• Dental
• Vision
• STD & LTD
• 401K Retirement Plan
• Basic Life & AD&D
• Supplemental Life Insurance
• Paid Time Off (PTO, STO, Holidays including Year-End Holiday Break)
• HSA & FSA
• Pet Insurance
• Tuition Reimbursement
• Flexible Hybrid Work Environment
• MLB Tickets
• com is an Equal Opportunity Employer. Please click hereto view our CCPA.