Data Architect

| Chicago

Who We Are:  Vivid Seats is the fastest-growing online marketplace for sports, theatre, and concert tickets.  We are dedicated to providing our customers with the best ticket buying experience in the industry. We offer the perks, culture, and opportunity of an entrepreneurial start-up, supported by the scale, stability, and resources of over a decade of profitable growth.

At Vivid Seats, you won't ever be a sub or sitting on the bench — we'll give you the opportunity to carry the rock or grab the mic starting day one.

If you enjoy continually looking for ways to make an impact on your team, organization, and industry, we’d like to hear from you.

Job Description:

Vivid Seats is looking for a Data Warehouse Architect to help drive the data warehouse strategy and power our product and analytics capabilities. As a Data Warehouse Architect, you’ll help set the direction for Vivid Seats evolving, scaling, high traffic marketplace with respect to data platform, pipeline, data model, reporting and visualization capabilities.

This role will be responsible for not only defining the technical direction of our data warehouse stack, but also plays a large role working with analysts and business stakeholders defining data systems that provide exceptional insights into the business.  You’ll work with a team of engineers to create data pipelines to capture and transform data, and with data analysts to drive who use that data through reports and visualizations.

If you are an expert at data warehouse technologies, skilled in architecting modern data pipelines, and passionate about unlocking the value of data, this position is for you.

Responsibilities:

  • Define the technical roadmap of Vivid Seats BI/Data Stack

  • Work with platform and data engineering to define, implement and improve our data pipeline and ETL processes and ensure consistency and quickness in delivery

  • Define SQL schemas for data driven insights, such as historical pricing, availability and member activities

  • Document the contents, format, and structure of databases and enhance data quality processes

  • Technical leadership and mentoring of Vivid Seats analysts and engineers

  • Identify and advocate the use of best tools, libraries, and processes for data warehouse, ETL and BI technologies

  • Participate in an agile development process

  • Pair with engineers, analysts and business stakeholders to deliver data that is insightful and impactful

Desired Skills and Experience:

  • 7+ years of experience working with large mission critical e-commerce data warehouses

  • Formal training with data-warehousing and modeling

  • Experience with commercial and open source modeling and data transformation tools

  • Experience with data analysis and visualization tools such as Business Objects, MicroStrategy, Looker and Tableau

  • Experience with AWS Redshift a plus

  • Familiarity with agile development cycles & rapid prototyping

  • A creative and organized data professional who thrives in both an independent and small team environment

  • A strong passion for enhancing the business value of data

What We Offer: Vivid Seats offers competitive compensation, individual and team-based bonus opportunities, aggressive promotion timelines, and a variety of workplace perks.  Specifically, staff has access to discounted event tickets, frequent in-office catered meals, office happy hours, team outings, free in-building gym membership, subsidized healthy meal and snack programs, and team sports leagues.  Standard benefits include medical/dental/vision/life insurance, paid family leave, 401(k) plan with employer match, flexible hours and paid time off, and transit plan discounts.

Vivid Seats is an equal opportunity employer. Vivid Seats prohibits discrimination and harassment of any type and affords equal employment opportunities to employees and applicants without regard to race, color, religion, sex, national origin, age, disability or genetic information.

Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • GolangLanguages
    • JavaLanguages
    • JavascriptLanguages
    • PerlLanguages
    • PythonLanguages
    • D3JSLibraries
    • FluxLibraries
    • jQueryLibraries
    • jQuery UILibraries
    • ReactLibraries
    • ReduxLibraries
    • Twitter BootstrapLibraries
    • Backbone.jsFrameworks
    • Node.jsFrameworks
    • PlayFrameworks
    • SpringFrameworks
    • Microsoft SQL ServerDatabases
    • MongoDBDatabases
    • MySQLDatabases
    • TeradataDatabases
    • Google AnalyticsAnalytics
    • IllustratorDesign
    • PhotoshopDesign
    • ConfluenceManagement
    • JIRAManagement
    • Pivotal TrackerManagement
    • 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
111 N. Canal, Chicago, IL 60606

Perks of working here

401(K) Matching
401(K)
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
Conferences & Training
Dental
Fitness Subsidy
Game Room
Happy Hours
Health Benefits
Onsite Gym
Generous Parental Leave
Recreational Clubs
Some Meals Provided
Stocked Kitchen
Unlimited PTO
Vision
More Jobs at Vivid Seats22 open jobs
All
Finance
Data + Analytics
Developer + Engineer
HR
Marketing
Operations
Product
Sales
Sales
new
Vivid Seats
Developer
new
Vivid Seats
Developer
new
Vivid Seats
Developer
new
Vivid Seats
Operations
new
Vivid Seats
HR
new
Vivid Seats
HR
new
Vivid Seats
Sales
new
Vivid Seats
Marketing
new
Vivid Seats
Developer
new
Vivid Seats
Developer
new
Vivid Seats
Developer
new
Vivid Seats
Developer
new
Vivid Seats
Developer
new
Vivid Seats
Finance
new
Vivid Seats
Operations
new
Vivid Seats
Developer
new
Vivid Seats
Developer
new
Vivid Seats
Data + Analytics
new
Vivid Seats
Data + Analytics
new
Vivid Seats