Data Engineer

About the job

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

Barstool Sports is a company that will drive the way media is created and consumed for years to come. Working at Barstool Sports means being part of a team that is solutions-oriented, celebrates creativity, and supports one another.    Joining means having access to competitive and valuable benefits and perks, including but not limited to:

• 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

  What We Value

• 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

  Barstool Sports is for everyone. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender perception or identity, national origin, age, marital status, protected veteran status, or disability status.    Barstool Sports does not accept unsolicited headhunter or agency resumes. Barstool Sports will not pay any third-party agency or company that does not have a signed agreement.