Data Analyst

| Chicago

The Opportunity:

Vivid Seats is the largest independent online ticket marketplace, sending tens of millions of fans to live events every year. Experiences Matter- which is why we continue to grow year over year. Working at Vivid Seats puts you front and center at the opportunity to scale our best in class platform that allow our fans to sit closer and experience more.

At Vivid Seats, you will have the opportunity to work with the flexibility and speed of a startup; while operating at massive, profitable scale. We keep our teams lean, allowing each and every employee direct accountability to creating a positive ticket buying experience. We are relentless and move quickly to release new features and content to our applications. Good ideas are heard and implemented, and hard work rewarded. Being a part of our team means having the ability to drive impact and own the innovation that connects our tens of millions of unique monthly users to the memorable experiences that only live events create.

As a Data Analyst you will work closely with end business users to determine data needs of the business area and discuss the meaning of the data coming from the transactional systems and 3rd party systems. You'll also identify additional data needs which aren't met and work with the development teams or 3rd parties to acquire the needed data.

You must be willing to take a deep dive in the data and understand the meaning, understand idiosyncrasies and communicate at both a technical and business level. You'll partner with a Data Modeler to create data structures which are useful for multiple internal stakeholders. It's important you get consensus to the approach, document the meaning, and serve as a coach to others who use the data.

Key Responsibilities

  • Develop a deep understanding of existing data in at least one system, including how the data is produced and used by the application. This will involve examining the data by writing SQL, talking to developers, examining the data for anomalies and patterns, and confirming popular opinion
  • Have knowledge of creating a data abstraction layer which is different than the transaction system or the incoming system
  • Document and map the existing data structures to the new data structures so Business Intelligence (BI) developers can use it for high level ETL (Exact, Transform, Load) work.
  • Work with various business groups to understand their short and long-term business needs and create a plan to deliver the data using the existing system or requesting new data be produced
  • Drive the governance process of ensuring all stakeholders are congruent on the meaning of the data and it's well documented
  • Build the BI layer of abstraction, providing the meaning created for BI reporting; ensure BI access is considered when providing access to data and reporting
  • Build BI reports when needed and train others in the ability to build BI reports, teaching them the concepts and complexities
  • Ability to explain technical concepts to a business audience including verbally, in writing, and by creating visual diagrams
  • Keeping up a data dictionary of the definitions of tables, columns and possible values

In order to be successful, you will:

  • Understand relational databases, tables, columns, and data types
  • Be fluent in SQL
  • Demonstrate proficiency in setting up reports in a BI tool like PowerBI, Looker, Tableau, or similar
  • Be curious and skeptical by examining the data to ensure it makes sense and adheres to popular opinion
  • See the perspective of many business stakeholders and understand dimensional modeling
  • Use excellent communication skills to work well with a wide range of stakeholders
  • Facilitate meetings with multiple stakeholders with the ability to drive consensus

What We Offer:

We are passionate about creating memorable experiences for our fans… and the best in class experience for our employees. Vivid Seats offers competitive compensation levels, individual and team-based bonus opportunities, generous benefits package and Flex PTO policy plus a variety of workplace perks. The most exciting one: We offer our employees $100 worth of credits each month to spend on Vivid Seats tickets along with promotional discounts. At the heart of it, we are all fans of great live events. We want to help you get there more often.
Location
111 N Canal St #800
Chicago, IL 60606
#LI-TA1

Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • JavaLanguages
    • JavascriptLanguages
    • KotlinLanguages
    • PythonLanguages
    • SqlLanguages
    • SwiftLanguages
    • ReactLibraries
    • ReduxLibraries
    • Node.jsFrameworks
    • SpringFrameworks
    • JSPFrameworks
    • DockerFrameworks
    • KubernetesFrameworks
    • AWSFrameworks
    • AuroraFrameworks
    • SpringbootFrameworks
    • Elasticsearch Frameworks
    • RedshiftFrameworks
    • PandasFrameworks
    • JuliaFrameworks
    • MySQLDatabases
    • Google AnalyticsAnalytics
    • IllustratorDesign
    • PhotoshopDesign
    • ConfluenceManagement
    • JIRAManagement
    • Constant ContactEmail
    • MailChimpEmail

Location

Located in the Loop near major transportation lines including Ogilvie and Union stations, as well as the Brown, Purple, Green, and Blue CTA lines
An inside look at Vivid Seats, where engineers solve tech problems at massive scale
Watch

What are Vivid Seats Perks + Benefits

Vivid Seats Benefits Overview

We make it easier for you to give it your all. While you are transforming the live event industry, we will take care of you and people who matter to you.
We've got you cover with a variety of Health, Dental and Vision packages to help fit your needs; 100% Employer Paid Life Insurance, AD&D and EAP; STD and LTD.
One of the most competitive 401 (k) programs on the market.
Continuing education opportunities and rewarding performance incentives
PTO, Maternity and Paternity policies that afford you the flexibility to take planned time off as needed.
In-office happy hours, holiday and summer events, company-sponsored sports leagues, catered lunches.
Stocked kitchen with healthy snacks!

Culture
Volunteer in Local Community
Committed to partner with organizations and causes that are important to our employees and our communities.
Partners With Nonprofits
Corporate Social Responsibility is important to us - we have a team dedicated to leading these efforts both in a local and national scope.
Friends Outside of Work
Eat lunch together
Intracompany Committees
Vivid Cares, Vivid Cleats, the FUN Committee are just a few examples of how we partner to execute initiatives that are important to our employees!
Daily Stand Up
Open Door Policy
Team-Owned Deliverables
Team-Based Strategic Planning
Group Brainstorming Sessions
Open Office Floor Plan
Diversity
Dedicated Diversity/Inclusion Staff
Highly Diverse Management Team
Unconscious Bias Training
Employees trained on best practices supporting data-driven decisions - starting with recruiting and hiring.
Health Insurance & Wellness Benefits
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Wellness Programs
Onsite Gym
Team Workouts
Acme Co.'s team fitness initiatives include Sponsored race teams.
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Acme Co. provides employees with a flexible work schedule that includes Flexible start and end times.
Remote Work Program
Vacation & Time Off Benefits
Unlimited Vacation Policy
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
Game Room
Stocked Kitchen
Some Meals Provided
Happy Hours
Recreational Clubs
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
Diversity Program
Lunch and Learns
Acme Co. hosts lunch and learn meetings on occasion.
Cross-Functional Training Encouraged
Promote From Within
Online Course Subscriptions Available

Additional Perks + Benefits

We offer discounts on tickets to attend your favorite events along with great health insurance plans with healthy employer subsidies, and pre-tax commuter benefits. . We host catered lunches and regular happy hours to recognize birthdays and celebrate successes. Our corporate office provides a fully paid in-building gym membership for your morning yoga or lunchtime run. For those with strong balance skills, we also have treadmill and bike desks!

More Jobs at Vivid Seats16 open jobs
All Jobs
Finance
Data + Analytics
Dev + Engineer
HR
Marketing
Operations
Product
Project Mgmt
Sales
Finance
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Project Mgmt
new
Chicago
HR
new
Chicago
Product
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Sales
new
Chicago
Marketing
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Sales
new
Chicago