Key skills
PythonSQLRAILLMETLAnalyticsBIDatabricksdbtLeadershipCommunication
About this role
SeatGeek is a company that believes in the power of live events and is modernizing the ticketing industry. They are seeking an Analytics Engineer to join their Data team, where the role involves developing data pipelines, collaborating with stakeholders, and owning the analytics data layer to drive data-driven decision-making.
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
- 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
Requirements:
- 2+ 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