We are hiring a Data Engineer for Barstool Sports, located in New York City or remote. As a Data Engineer, you will not only own, but also perform maintenance and enhancements across an array of projects. You will be tasked to work with the product & engineering team, as well as our data science team, to build and orchestrate data workflows that move data from our vast umber of 3rd party sources into our central data warehouse. You will be responsible for building and maintaining custom scraping solutions, ETL pipelines as well as managing out-of-the-box data ingestion products. You will need to utilize SQL for simple data retrieval to complex materialized views.
Languages, frameworks, and tools you should know….
- Python
- Snowflake / BigQuery / Redshift / DataBricks
- DBT
- Looker
Languages, frameworks, and tools you should be familiar with...
- Prefect
- AWS Lambda
- Node.js
- FiveTran, StitchData or other ETL tools
Requirements
- 3+ years of engineering experience in Javascript or Python with a strong grasp of SQL
- Ability to interact with 3rd party API’s at scale. Some workflows will query millions of rows.
- Strong understanding of data warehouses and how to efficiently store the data for optimal query performance.
- Excellent communication skills — you should be able to clearly articulate your decisions.
Range: $95,000 - $110,000
- Competitive medical, dental, and vision insurance; Flexible Spending Accounts and Commuter Benefits
- A 4% 401(k) employer match
- Unlimited vacation time, including Summer break in July and Holiday break in December
- Monthly employer contribution towards cell phone reimbursement
- Employee discount to the Barstool Sports store
- Financial wellness benefits through Origin
- A monthly stipend for UberEats
- Rep the brand as best you can
- We have lots of different brains, be open to them
- Never change who you are, that's who we hired
- Find the solution, don't be the problem
- Don't be afraid to try something new
- Common Sense. Use it.
- Be there for your audience
- Always think about how you can help
Similar Jobs
.png)
What We Do
Barstool Sports is one of the most influential lifestyle brands in America. With a rich history, Barstool Sports has one of the most highly coveted, fiercely loyal, and incredibly engaged audiences, which has put Barstool at the top of the charts.
Barstool Sports is the preeminent digital sports media brand that has established an extremely influential and deeply authentic voice. Barstool Sports creates innovative content with massive distribution on multiple platforms including web, apps, podcasts, radio, video, social, events, pay-per-view, subscription, and TV to an incredibly engaged audience.
Barstool steals the spotlight in cultural moments. Their presence at major sporting events drives more awareness, engagement, and viewership in younger demographics than any other media brand. Barstool Sports and its founder, Dave Portnoy, consistently ranks as the #1 most influential social media account at major sporting events like the Kentucky Derby, Super Bowl, PGA Championship, U.S. Open Golf, Stanley Cup Finals, NASCAR's Daytona 500, and more.
Gallery
