Senior Data Warehouse Analyst

1 month ago

Chicago, United States Vivid Seats Full time
Job DescriptionJob Description

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, Data, Performance, and Operations

    3 months ago

    Chicago, United States Senior Analyst, Data, Performance, and Operations Full time

    Seeking to hire a Senior Analyst, Data, Performance, and Operations for a direct hire opportunity in Chicago for one of the nation's largest independent foundations. Organizations supported by the Foundation work in about fifty countries. Will support our client’s Investment Department’s data management infrastructure. Will provide support for the...

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

  • Senior Financial Data Analyst

    7 days ago

    Chicago, United States 1872 Consulting Full time

    Senior Financial Data Analyst Chicago, IL (hybrid WFH 2 days, onsite 3 days in Willis Tower in the loop) Summary The Senior Financial Data Analyst role will be supporting major FP&A processes by designing and developing tools, techniques, metrics, and dashboards for insights/data visualization. You'll be working with data in Snowflake to build Power BI...

  • Senior Systems Engineer

    3 months ago

    Chicago, United States VetsEZ Full time

    **Senior Systems Engineer (Data Warehouse)** * Chicago, IL * Full-Time * Senior Systems Engineer (Data Warehouse) VetsEZ (Veterans EZ Info, Inc.), a verified Service-Disabled Veteran-Owned Small Business (SDVOSB), is a leading provider of information technology services to commercial and Government markets. VetsEZ is a company of Subject Matter Experts...

  • Senior Data Analyst

    2 months 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 Analyst, Data and Analysis

    1 month ago

    Chicago, United States Digitas Full time

    Digitas is the Networked Experience Agency, built on the vision that we create magnetic experiences that earn the right for brands to exist in human networks. Today, and tomorrow. We deliver Networked Experiences by leveraging comprehensive data, technology, creative, media and strategy capabilities. Digitas delivers ambitious outcomes via unique solutions...

  • 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,...

  • Senior Analyst, Data and Analysis

    3 weeks ago

    Chicago, United States Digitas Full time

    Job DescriptionJob DescriptionCompany DescriptionDigitas is the Networked Experience Agency, built on the vision that we create magnetic experiences that earn the right for brands to exist in human networks. Today, and tomorrow. We deliver Networked Experiences by leveraging comprehensive data, technology, creative, media and strategy capabilities. Digitas...

  • Financial Data Strategist

    6 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 Data Analyst

    2 weeks ago

    Chicago, United States Hexaware Technologies Full time

    What Working at Hexaware offers:Hexaware is a dynamic and innovative IT organization committed to delivering cutting-edge solutions to our clients worldwide. We pride ourselves on fostering a collaborative and inclusive work environment where every team member is valued and empowered to succeed.Hexaware provides access to a vast array of tools that enhance,...

  • Senior Data Analyst

    7 days ago

    chicago, United States Hexaware Technologies Full time

    What Working at Hexaware offers:Hexaware is a dynamic and innovative IT organization committed to delivering cutting-edge solutions to our clients worldwide. We pride ourselves on fostering a collaborative and inclusive work environment where every team member is valued and empowered to succeed.Hexaware provides access to a vast array of tools that enhance,...

  • Senior Data Analyst

    2 weeks ago

    Chicago, United States Hexaware Technologies Full time

    What Working at Hexaware offers:Hexaware is a dynamic and innovative IT organization committed to delivering cutting-edge solutions to our clients worldwide. We pride ourselves on fostering a collaborative and inclusive work environment where every team member is valued and empowered to succeed.Hexaware provides access to a vast array of tools that enhance,...

  • Senior Data Analyst

    7 days ago

    chicago, United States Hexaware Technologies Full time

    What Working at Hexaware offers:Hexaware is a dynamic and innovative IT organization committed to delivering cutting-edge solutions to our clients worldwide. We pride ourselves on fostering a collaborative and inclusive work environment where every team member is valued and empowered to succeed.Hexaware provides access to a vast array of tools that enhance,...

  • 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 Data Analyst IV

    3 weeks ago

    Chicago, United States Tek Ninjas Full time

    Job DescriptionJob DescriptionPosition : Senior Data Analyst IVLocation : Chicago, IL (Hybrid)Duration : 6 Months with EXT or hire Top 5 Skill setsData Analysis and ExplorationGathering Business Requirements, Building metadata schema by doing data profilingStructured Query Language and Database ManagementProblem-SolvingCommunication and Stakeholder...

  • Senior HRIS Data/Technical Analyst

    4 weeks ago

    Chicago, United States PCG INTERNATIONAL INC Full time

    Job DescriptionJob DescriptionDescription: PCG Consulting group is a dynamic and innovative technology-driven organization that partners with health, education, and human services agencies to improve lives. We have partnered with Deloitte and are looking for a Senior HRIS Data Analyst to join our team and play a key role in advancing our HR Technology...

  • Senior Logistics Analyst

    4 weeks ago

    Chicago, United States The LaSalle Group Full time

    LaSalle Network is excited to announce a compelling opportunity for a skilled Senior Logistics Analyst to join a prominent Consumer Packaged Goods (CPG) organization in downtown Chicago. We are seeking a talented individual with a strong analytical background and logistics expertise to optimize transportation and distribution operations. Senior Logistics...

  • Senior Financial Data Analyst

    6 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 Marketing Data Analyst

    1 month ago

    Chicago, United States Vivid Seats Full time

    Job DescriptionJob DescriptionWho 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....

  • Senior IT Data Analyst

    7 days ago

    Chicago, IL, United States GTT, LLC Full time

    Senior IT Data AnalystContract Duration 3+ MonthsPay range - $55 to 60/hrHybrid, three times a week to officeShift: Monday to Friday, 9 am -5 pmJob Summary:Test and/or support the execution of projects/implementations related to transaction monitoring, screening, customer risk rating systems, and/or reporting systemsSenior IT Data Analyst supports the...