Senior Data Warehouse Analyst, Vivid Seats
+ Bonus incentives
Ticket exchange and resale platform
Job no longer available
Ticket exchange and resale platform
501-1000 employees
Job no longer available
+ Bonus incentives
501-1000 employees
Company mission
To empower every fan to get to the live events that shape their most vivid moments and memories.
Role
Who you are
- The ideal candidate is technically advanced in SQL, comfortable writing and optimizing complex queries with the end game of developing a deep understanding of our data, how the business is performing and point of view on how to improve the status quo by effectively working with stakeholders
- We value individuals who take initiative, make informed decisions, and lead projects with minimal guidance
- 3+ years of professional experience as a Data Analyst, Business Analyst, or related position involving data analytics and structure
- Advanced SQL skills, especially in Snowflake, capable of optimizing complex data structures for performance and scalability
- Expertise in Looker, with a solid understanding of other visualization tools like Tableau, Spotfire, or Power BI are a plus
- Proven ability to work collaboratively across diverse teams, fostering an environment of mutual respect and goal alignment
- Highly motivated self-starter who is naturally curious and seeks out answers by diving into the data
- Exceptional analytical thinking and problem-solving skills, with a track record of innovative solutions to business challenges
- Ownership mindset and the confidence to make independent decisions and drive projects forward
- Eye for detail and demonstrated ability to solve problems logically and systemically while ensuring information is accurate and consistent across reporting
What the job involves
- As a Senior Data Warehouse Analyst you will have ownership over designing our data warehouse and reporting systems, maintaining data integrity and consistency across all reporting platforms and ensuring the our reporting remains accurate and performant with growing business needs
- You will operate as the primary liaison between business units, analytics, and data engineering
- Ownership of our data and how it is structured so it is accurate, consistent, performant and useful for the business to derive insights and make decisions
- Here, constant change fuels growth and innovation, offering a dynamic environment where your work will shape the future of the business
- Proactive in identifying and implementing improvements across our reporting and data processes
- Responsible for creating tables, views, caching processes, and coordinating with Data Engineering to get new data available for the business at large to use
- Influence our path to innovation and efficiency by making data more accessible and actionable
- Collaborate with thought leaders and cross-functional teams to bring forward-thinking solutions and insights to the table
- Touch every corner of the business from Product, Marketing, Finance to Operations and Supply Chain, impacting decision making up to the executive level
- 30 days in:
- Acquire an in-depth understanding of our business model, focusing on the marketplace dynamics and the analytics needs of different teams
- Build foundational relationships within cross-functional teams, understanding the interplay between analytics, product, engineering, operations, and supply chain
- Complete a comprehensive dive into our data and internal systems, aiming to master its structure, functionalities, and how teams interact with it
- Identify initial areas for quick wins in our current reporting and data handling practices
- Understand all essential tables in the production database & data warehouse, Looker/LookML and data structure/architecture
- 90 days in:
- Conduct a thorough evaluation and implement enhancements to our reporting data structure, focusing on performance and long-term scalability
- Present insights, findings, and progress to leadership, demonstrating early impacts
- Contribute to our approaches, methods, or technologies to support overall business goals and drive team efficiencies
- Independently manage data warehouse roadmap and ad hoc requests, producing work to be utilized by stakeholders
- Proactively build and refine the reporting infrastructure in Snowflake and Looker to preemptively meet future needs
- Collaborate with Data Engineering and business stakeholders to create a cohesive reporting and data strategy
- Collaborate with the broader team on best practices for reporting, analysis, and dashboards, learning from and sharing expertise with others and applying learnings to current and future work
- 180 days in:
- Independently identify and execute further areas of improvement, showcasing significant efficiency gains
- Establish yourself as a thought leader within the Analytics team and the organization, driving innovative practices
- Lead cross-functional projects with minimal oversight, directly contributing to strategic business outcomes
- Anticipate downstream impacts for changes, make necessary adjustments and proactively communicate to stakeholders
- Be recognized as a crucial analytical resource across the company, embodying a proactive approach to problem-solving
Our take
Founded in 2001, Vivid Seats is one of the leading online ticket marketplaces. The event tickets market is one of the biggest out there, expected to reach almost $85 billion by 2027, and the company has secured its place within it with partnerships with big players like ESPN, RollingStone, and the NBA.
The company's strategy has so far been based on massive public exposure through heavy spending on digital advertising, which has brought it great success to date. Its connects millions of buyers with thousands of ticket sellers each year, covering hundreds of thousands of different events.
Vivid Seats boasts high revenues and sustained growth, and went public in 2021. Following its listing on the NASDAQ, the company has been focusing on expanding operations and broadening its tech capabilities. A recent development is the company's Vivid Picks app, which combines live event and gaming experiences to target changing trends in the events ticket space.
Kirsty
Company Specialist at Welcome to the Jungle
Insights
42% employee growth in 12 months
Company
Funding (last 2 of 3 rounds)
May 2014
$5.2m
SERIES A
Mar 2012
$3.9m
ANGEL
Total funding: $9.7m
Company benefits
- The Basics: We’ve got you covered with a variety of health, dental and vision packages to meet your needs: BCBS PPO, HSA and HMO plans, mental health and telehealth programs.
- Your Future: We care about what’s ahead for you. From competitive retirement and savings programs, to continuing education opportunities, and rewarding performance incentives, our goal is to grow your future in meaningful and sustainable ways.
- Recharge: We know employees who refresh, restore, and take time for life’s significant moments enjoy their work and are more productive. PTO, mental health days, and maternity/paternity policies give you the flexibility to make the most of your planned time off.
- Winning Together: We celebrate wins and stay connected as a team. Our teams are recognized in company-wide town-halls, hackathons, and product demos and enjoy in-office happy hours, holiday and summer events, and company sponsored sports leagues and competitions.
- Health = Happy: We are committed to a healthy lifestyle. We cover gym membership fees, host wellness weeks, provide plenty of nutritious snacks, cater smart choice lunches, provide access to on-site treadmill desks, bike storage, fitness classes, and inspiring office spaces where mindfulness can thrive.
- Convenient: We make work a little easier, providing hybrid working arrangements at accessible office locations. When you are in the office, you’ll have the tools (company provided laptops, monitors, software), room for ideas (open floorplan with plenty of meeting rooms, quiet areas, and whiteboards), and coffee. We’re talking good coffee.
Company HQ
West Loop Gate, Chicago, IL
Leadership
Stan Chia
(CEO)Board Director at 1871, and Board Member at the Georgia Institute of Technology. Former COO of GrubHub.
Salary benchmarks
We don't have enough data yet to provide salary benchmarks for this role.
Submit your salary to help other candidates with crowdsourced salary estimates.
Share this job
View 11 more jobs at Vivid Seats