Senior Data Warehouse Analyst

2 months ago

Chicago, Illinois, United States Vivid Seats Full time

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's top places to work in 2024, 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:

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. 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. Here, constant change fuels growth and innovation, offering a dynamic environment where your work will shape the future of the business.

How your role contributes to the success of Vivid Seats:

· 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.

· 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.

How your role expectations will progress as a Sr. Data Analyst in the first 30, 90, and 180 days:

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.

What You'll Bring:

· 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.

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; 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.

Location: Chicago, IL

We believe in a hybrid working model which provides employees the flexibility to take advantage of in-person and remote collaboration. Check out our brand new HQ office, bursting with the energy of live events fandom and the vibrancy of Chicago's rising tech scene.


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.

  • Senior Analyst, Warehouse Operations

    2 months ago

    Chicago, Illinois, United States Kraft Heinz Full time

    Senior Analyst of Warehouse Operations at Kraft HeinzRole / Title: Senior Analyst of Warehouse OperationsThe Senior Analyst of Warehouse Operations is responsible for overseeing the daily metrics and performance of warehouse operations. In this role, you will identify and support efficiency and KPI improvement initiatives. Managing the warehouse team's...

  • Senior Data Analyst

    1 month ago

    Chicago, Illinois, United States United Airlines Full time

    Job overview and responsibilitiesThere's never been a more exciting time to join United Airlines We're on a path towards becoming the best airline in the history of aviation. Our shared purpose – Connecting People, Uniting the World – is about more than getting people from one place to another. It also means that as a global company that operates in...

  • Senior Data Architect

    1 month ago

    Chicago, Illinois, United States Bounteous Full time

    Bounteous x Accolite makes the future faster for the world's most ambitious brands. Our services span Strategy, Analytics, Digital Engineering, Cloud, Data & AI, Experience Design, and Marketing. We are guided by Co-Innovation, our proven methodology of collaborative partnership. Bounteous x Accolite brings together 5000+ employees spanning North America,...

  • Financial Data Strategist

    3 days ago

    Chicago, Illinois, United States 1872 Consulting Full time

    Senior Financial Data AnalystWe are seeking a highly skilled Senior Financial Data Analyst to play a key role in driving business growth through data-driven insights at 1872 Consulting.About the RoleDesign and develop advanced tools, techniques, metrics, and dashboards for business intelligence and data visualization to support major financial planning and...

  • Senior Marketing Data Analyst

    3 weeks ago

    Chicago, Illinois, United States Vivid Seats Full time

    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's top...

  • Senior Financial Data Analyst

    3 days ago

    Chicago, Illinois, United States 1872 Consulting Full time

    Senior Financial Data AnalystWe are seeking a highly skilled Senior Financial Data Analyst to play a key role in driving business growth through data-driven insights at 1872 Consulting.About the RoleDesign and develop tools, techniques, metrics, and dashboards for insights/data visualization to support major financial planning and analysis processes.Work...

  • Senior Data Protection Analyst

    16 hours ago

    Chicago, Illinois, United States United Airlines Full time

    About the RoleWe are seeking a highly skilled Senior Data Protection Analyst to join our Cybersecurity and Digital Risk (CDR) team at United Airlines. As a key member of our team, you will play a critical role in helping us become the leading cyber-safe airline in the industry.Key ResponsibilitiesLead the implementation of our Data Protection strategy and...

  • Senior Data Analyst

    1 month ago

    Chicago, Illinois, United States Blue Cross Blue Shield Association Full time

    The hiring range for this role is: 92, ,145.00This is the lowest to highest salary we, in good faith, believe we would pay for this role at the time of this posting. We may ultimately pay more or less than the hiring range andthis hiringrange may also be modified in the future. A candidate's position within the hiring range may be based on several factors...

  • Lead Analyst for Warehouse Performance

    1 week ago

    Chicago, Illinois, United States Heinz Full time

    Position Overview:As a Senior Analyst for Warehouse Operations, you will oversee the daily metrics and performance of warehouse activities. This role involves identifying and supporting initiatives aimed at enhancing efficiency and improving key performance indicators (KPIs). Your responsibilities will also encompass managing critical metrics that contribute...

  • Senior Data Analyst

    1 month ago

    West Chicago, Illinois, United States Epsilon Full time

    Job DescriptionSummary:The Analytic Consulting Group partners with internal and external clients and data providers, leveraging predictive analytics and advanced statistical techniques to drive strategic thought and effective decision making. The Senior Data Analyst helps support all aspects of analytic initiatives from conception to completion....

  • Business Data Analyst

    2 months ago

    Chicago, Illinois, United States Clear Street Full time

    About Clear Street:Clear Street is modernizing the brokerage ecosystem. Founded in 2018, Clear Street is a diversified financial services firm replacing the legacy infrastructure used across capital markets. We started from scratch by building a completely cloud-native clearing and custody system designed for today's complex, global market. Our platform is...

  • Senior Analyst

    3 weeks ago

    Chicago, Illinois, United States SRAM, LLC Full time

    Overview Based in the former warehouse district of Fulton Market, Chicago's lively West Loop area, which is now a hip corporate and entertainment area known for creative global and modern American restaurants, we have easy access to public transport, great restaurants, and an awesome office roof deck. You will join a highly effective, caring team in an...

  • Senior IT Data Analyst

    5 days ago

    Chicago, Illinois, United States GTT, LLC Full time

    Job SummaryWe are seeking a highly skilled Senior IT Data Analyst to join our team at GTT, LLC. As a key member of our AML team, you will be responsible for supporting the delivery of projects related to transaction monitoring, customer risk rating systems, and reporting systems.Key ResponsibilitiesSupport the development of test cases and execute testing...

  • Senior Product Manager

    3 days ago

    Chicago, Illinois, United States Tempus Labs, Inc. Full time

    About the RoleWe are seeking a highly skilled Senior Product Manager to join our team at Tempus Labs, Inc. as a key member of our Data Integrations and Platform team. As a Senior Product Manager, you will be responsible for owning the product roadmap for a subset of our Real-World Data (RWD) products, partnering with other Product Managers and the Director...

  • Senior Data Engineer

    1 month ago

    Chicago, Illinois, United States Belvedere Trading Full time

    Belvedere Trading is a leading proprietary trading firm proudly headquartered in downtown Chicago. Our traders work hard to provide liquidity to the market through their market-making activities and are the masters of a diverse set of commodities, interest rates, exchange-traded funds (ETF), and equity index options. From the beginning, we began iteratively...

  • Operations Data Analyst

    2 months ago

    Chicago, Illinois, United States Labelmaster Full time

    Labelmaster is an established and growing company that takes the complexity out of shipping Dangerous Goods (Hazmat), making the world a safer place.We are looking for an intuitive Operations Data Analyst who:Does not want to work in Corporate AmericaWants to make a difference every day at workWants to have true work/life balanceLoves to learn new thingsHas...

  • Senior Manager, Data Product Strategist

    3 days ago

    Chicago, Illinois, United States AMADA Senior Care Mesa Full time

    About the RoleWe are seeking a highly skilled Senior Manager, Data Product Manager to join our team at AMADA Senior Care Mesa. This is a pivotal role in advancing our growth strategy through the effective use of data.Key ResponsibilitiesOversee data integrations for a customer data platform to ensure real-time and accurate data for our marketing team.Lead a...

  • Senior Data Architect

    4 weeks ago

    Chicago, Illinois, United States AbbVie Full time

    Company DescriptionAbbVie's mission is to discover and deliver innovative medicines and solutions that solve serious health issues today and address the medical challenges of tomorrow. We strive to have a remarkable impact on people's lives across several key therapeutic areas immunology, oncology, neuroscience, and eye care and products and services in our...

  • Senior Analyst- Technical Operations Master Data

    1 month ago

    Chicago, Illinois, United States United Airlines Full time

    There's never been a more exciting time to join United Airlines. We're on a path towards becoming the best airline in the history of aviation. Our shared purpose – Connecting People, Uniting the World – is about more than getting people from one place to another. It also means that as a global company that operates in hundreds of locations around the...

  • Experienced Logistics Analyst

    1 week ago

    Chicago, Illinois, United States The LaSalle Group Full time

    The LaSalle Group is pleased to present an exciting opportunity for a qualified Senior Logistics Analyst to become part of a leading Consumer Packaged Goods (CPG) firm. We are in search of a proficient individual with a solid analytical foundation and logistics knowledge to enhance transportation and distribution processes. Key Responsibilities of the...