Data Engineer
Who we are: Founded in 2001, Vivid Seats (NASDAQ: SEAT) is a leading online ticket marketplace committed to becoming the ultimate partner for connecting fans to the live events, artists, and teams they love. We believe in the power of experiences and are fiercely dedicated to building products that inspire human connections. Named as one of Built In Chicago's top 10 places to work in 2021, we believe that our People are our greatest competitive advantage. To support our People, we have built a company culture that empowers our employees to embrace challenges, encourages unity through collaboration, and seeks to constantly evolve by leveraging data and inspiring innovation.
The Opportunity:
Our Data team is looking for a Software Engineer, Data to support our overall data infrastructure to meet and anticipate the growing data needs that support our business growth. Our software and business teams depend on the data team to deliver robust, performant, and secure data products and solutions to enable every aspect of our business. As this critical area of our infrastructure grows, we are looking to expand our current offerings into more robust data products that can empower our applications and operations.
As a Software Engineer, Data you will operate as a partner to our business stakeholders to deliver data as a product; based upon their delivery needs (e.g., dashboards, reports, standard queries) meaningful data insights in a manner that is appropriate for the business. You'll partner with engineering and business teams to ingest and transform data sources into our data warehouse, build clean/abstracted data models, and implement BI tooling as necessary. You'll mature operational stability and performance of the data reporting platform through best practices, automation and monitoring while staying up to date on new and emerging technologies, planning accordingly to incorporate valuable concepts to enhance our data schema and capabilities.
How your role expectations will progress as a Software Engineer, Data in the first 30, 90, and 180 days:
30 days in
- Complete new hire orientation, gaining the resources you need to be successful.
- Learn how ticket marketplaces operate and how you'll contribute to providing great experiences for our customers.
- Acclimate to the team and company norms, business objectives, and Vivid Seats values.
- Develop basic understanding of applications, tech stack, and development process.
- Collaborate with other data engineers on projects currently in place to improve our data operations and understand projects in flight.
90 days in
- Contribute to our approaches, methods, or technologies to support overall business goals and drive team efficiencies.
- Maintain, harvest and aid internal and external relationships to achieve progress and advance objectives.
- Contribute to team planning, estimations, and design sessions.
- Deliver clear code and/or queries and support a stable and scalable code for our platform
- Understand the core challenges we face as a data organization and propose solutions or technologies based on your experience.
180 days in
- Apply methods to execute individual tasks that positively impacts the team.
- Play an active role in continued learnings to advance skill sets necessary for team goals.
- Have self-sufficiency in all applications touched by the team.
- Actively contributes into larger team and engineering group objectives.
- Produce and deliver clean, correct code that drives team and company tech goals forward.
- Design and implement process improvements that positively impact the team.
What You'll Bring:
- Positive energy, a desire to contribute and mentor others, and a love for collaboration.
- A pragmatic view of technology and understanding of what tools are right for the job, not just fun to use.
- Understanding of cloud-based relational databases and approaches towards performance optimization.
- Experience in either modeling transaction or data warehousing with an interest in learning both methodologies.
- Experience working with business and product leaders to define data reporting and dashboard requirements
- Background supporting and developing data access tools and dashboards (Tableau, Power BI, Looker, others)
- ETL pipeline and tooling experience; including troubleshooting
- Strong SQL query experience
- Scripting experience using Java, Python or Bash
- A willingness to participating in an on-call rotation
Additional Experience of Interest:
- Experience with configuration as code tools such as Ansible, Terraform etc.
- Familiarity with containerization and orchestration e.g. Docker, Kubernetes
- Experience with ETL pipelines with tools like Airflow and scripting using Java, Python or Bash.
- Experience with continuous integration, testing, and deployment using tools such as Jenkins
- of workplace perks.
- Experience managing data/metadata with cloud data warehouse platforms (preferably Snowflake, Amazon Redshift)
Our Commitment:
We are an equal opportunity employer that values the critical importance of a diverse workforce and sense of belonging. Many of our roles have flexible requirements and we encourage you to apply regardless of whether you meet every qualification.
Vivid Seats provides competitive compensation; bonus incentives and equity for all employees; FLEX PTO; mental health days; medical, dental, and vision insurance; 401K matching; monthly credits and discounts for attending live events; remote work and snack allowances; and a variety of additional workplace perks.