AI Summary
Join SeatGeek's Data team to develop data pipelines, communicate with stakeholders, and assist in troubleshooting. This Analytics Engineer role requires experience with DBT, SQL, Python, and data modeling.
Key Highlights
Develop data pipelines and ETL frameworks using SQL and Python
Communicate with stakeholders to understand data use cases and product requirements
Assist in troubleshooting and debugging data models
Key Responsibilities
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 product requirements for R&D teams
Architect and thoroughly QA performant data models that enable analysis in a data warehouse setting
Technical Skills Required
Benefits & Perks
Equity stake
Flexible work environment
Remote work stipend
Unlimited PTO
Paid family leave
401(k) matching
Student loan matching
Health insurance
Vision insurance
Dental insurance
Life insurance
Gender-affirming care
Family building assistance
Headspace subscription
One Medical subscription
Job Description
SeatGeek believes live events are powerful experiences that unite humans. With our technological savvy and fan-first attitude we’re simplifying and modernizing the ticketing industry.
We are looking for an Analytics Engineer to join SeatGeek’s Data team. You will join a high-performing team that partners closely with business stakeholders for their data management and insights generation needs. Analytics Engineers play a critical role in discovering, extracting, storing, cataloging, modeling, and processing our data. As a member of this team you will own our analytics data layer. You’ll work on extracting data from production databases as well as third party sources, architecting efficient data models, and orchestrating jobs in Airflow to produce clean, well-documented, and analysis-friendly datasets. This is a highly collaborative role; you will own relationships with both analysts and production engineers to discover the value of our data. By putting data at the heart of everything we do, your work will drive us toward our mission of making SeatGeek the top destination for live event goers.
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 has a strong opinion on how we should build and use data to fuel decision-making, you’re the right person for this role.
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 product requirements for R&D teams
- Architect and thoroughly QA performant data models that enable analysis in a data warehouse setting
- Assist in triaging and debugging on-call requests in a rotational on-call schedule with the Analytics Engineering team
- Enable AI-assisted stakeholder data analysis by designing LLM-friendly DWH schemas, creating domain guides, and enforcing canonical naming conventions across all tables to be consumed by the AI agent
- Partner with Analytics leadership to develop a strategy around BI tooling to ensure stakeholders have easy access to usable data
Searching for Development & Programming roles that provide visa sponsorship? Connect with international employers through Development & Programming Jobs with Visa Sponsorship opportunities actively seeking talented professionals.
- 3+ years of relevant experience in Analytics, Data, or Software Engineering
- Experience with DBT, databricks, or similar SQL-transformation tool is a must
- 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 cleaning data sets, developing new models and interfacing with stakeholders to understand business requirements
- Expert verbal and written communication skills. You are able to translate complex problems or concepts into clear frameworks and guides that all audience types can understand.
- Scheduling/Orchestration: Airflow
- ETL: Fivetran, Python, dbt, & Kafka
- Data Warehouse: Redshift
- Event Stream: mParticle
- Experimentation: Eppo
- BI: Looker, Hex, & Mixpanel
- Code versioning: Gitlab
- Required languages: SQL and Python
Explore our comprehensive directory of visa sponsorship jobs from employers worldwide who are ready to sponsor talented international professionals.
- 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
- Unlimited PTO
- Up to 16 weeks of fully-paid family leave
- 401(k) matching
- Student loan matching program
- Health, vision, dental, and life insurance
- Up to $25k towards family building, reproductive health services and Gender-affirming care
- $500 per year for wellness expenses
- Subscriptions to Headspace (meditation), Headspace Care (therapy), and One Medical
- $120 per month to spend on tickets to live events
- Annual subscription to Spotify, Apple Music, or Amazon music
Interested in opportunities specifically in United State? Discover our dedicated Visa Sponsorship Jobs in United State page featuring roles from top employers in this location.
SeatGeek is committed to providing equal employment opportunities to all employees and applicants for employment regardless of race, color, religion, creed, age, national origin or ancestry, ethnicity, sex, sexual orientation, gender identity or expression, disability, military or veteran status, or any other category protected by federal, state, or local law. As an equal opportunities employer, we recognize that diversity is a positive attribute and we welcome the differences and benefits that a diverse culture brings. Come join us!
To review our candidate privacy notice, click here.
Similar Jobs
Explore other opportunities that match your interests
Enterprise Architect
••••••
••••••
••••••
Job Type
••••••
Experience Level
••••••
Perficient
United State
Senior/Principal Embedded Software Engineer
••••••
••••••
••••••
Job Type
••••••
Experience Level
••••••
EVONA
United State
Visa Sponsorship
Relocation
Remote
Job Type
Full-time
Experience Level
Mid-Senior level
Gables Search Group
United State