Analytics Engineer

Key Skills

Business Intelligence, Data Analytics, Data Biuld Tool - dbt, Data pipelines, Data science techniques, ETL frameworks, Large data sets, Looker, Python Programming, SQL

Job Description

SeatGeek's data warehouse has been at the core of our Data team for the better part of a decade, and as early adopters of Redshift, Looker, and dbt, our business intelligence stack is technically mature and easy to work with. The live event industry continues to boom and the future is up for grabs. Operators across SeatGeek will need clean, actionable metrics and feedback loops to make company-defining decisions. If you're somebody who knows that you optimize what you measure, if you believe in the unreasonable effectiveness of data, if you get delight from helping your coworkers do their jobs better, and if you have strong opinions on how data can make that happen, then you're the right person to take our solid foundation and build to the stars.

Our stack

• Scheduling/Orchestration: Airflow
• ETL: Fivetran, Python and dbt
• Data Warehouse: Redshift
• Event Stream: mParticle
• Experimentation: Optimizely
• Dashboarding: Looker & Hex 
• Code versioning: Gitlab
• Required languages: SQL and Python

What you’ll do

• Join a team of Analytics Engineers that will develop data pipelines and use SQL- and python-based ETL frameworks to acquire, process, and deliver data to consumers around SeatGeek.
• Communicate and collaborate with different stakeholders, like Data Scientists, Analysts, Data Platform Engineers, and Software Engineers to understand data use cases and produce requirements R&D teams.
• Implement cataloging best practices and lead the definition, collection, documentation of our data sources. Invest in end-user data literacy through hands-on training with folks around the company.
• Develop performant data models and schemas that enable analysis in a data warehouse setting.
• Own third party BI vendor management, e.g. Looker

 Who you are

• 3+ years of relevant experience in Analytics, Data, or Software Engineering. Experience with dbt required.
• A bachelor’s degree or higher in economics, psychology, computer science, statistics, mathematics or another quantitative discipline
• Expert-level knowledge of SQL. Proficiency in programming with Python. 
• Experience developing new metrics and performing analysis with large datasets
• Experience building reports and dashboards using business intelligence tools

Perks

• Equity stake
• Flexible work environment, allowing you to work as many days a week in the office as you’d like or 100% remotely
• A WFH stipend to support your home office setup
• Flexible PTO
• Up to 16 weeks of paid family leave
• 401(k) matching program
• Health, vision, dental, and life insurance
• Annual subscriptions to Headspace, Ginger.io, and One Medical 
• $120 a month to spend on tickets to live events
• Annual subscription to Spotify, Apple Music, or Amazon music

The salary range for this role is $130,000-$240,000. Actual compensation packages within that range are based on a wide array of factors unique to each candidate, including but not limited to skill set, years and depth of experience, certifications, and specific location.