200+ applicants

This job has closed.

Company

Underdog Fantasy · 1 day ago

Senior Data Engineer

United States

Full-time

Remote

Senior Level

$150K/yr - $180K/yr

5+ years exp

Maximize your interview chances

Fantasy SportsGaming

Insider Connection @Underdog Fantasy

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

As a Senior Data Engineer on the Transformation team, you’ll be instrumental in the development of Underdog’s reporting layer by designing models in DBT

In this role, you will work cross-functionally with Data Scientists, Product Managers, and other stakeholders across the business to understand data needs to design performant, flexible, and low-technical-debt solutions

Using BigQuery and DBT, design and execute scalable reporting models that minimize technical debt, make efficient use of BQ resources, keep data fresh, adhere to Underdog best practices, and allow stakeholders to access the data they need

Create and maintain tests and documentation about the reporting layer inside the DBT models, to enable Data Scientists to quickly find what they need

Perform validation and data integrity checks on new datasets and load procedures before delivery to stakeholders, investigating and resolving data discrepancies and escalating to the engineering team or other teams as needed

Stay abreast of all of Underdog's Fantasy data models, processes, business rules, contest rules, and product functionality, including compliance and regulatory considerations; plan/execute needed changes in the reporting layer

Assist Data Scientists in developing analytics datasets to meet the needs of the business

Meet with stakeholders as needed to discuss existing and upcoming data projects and deliverables; stakeholders include, but are not limited to: Product Managers, Engineers, other members of the Data team, third-party vendors, and other team members throughout the organization who are involved in data projects

Communicate continuously about progress, blockers, and anything else related to assigned tasks

Document and report issues with source data and follow up with owners on resolution/path forward

Use Jira proactively to manage tasks and deliverables; participate in regular sprint planning and retrospective meetings

Periodically present your work at team lunch-and-learn meetings

Proactively look for ways we can continuously improve our architecture in the reporting layer, as well as our team processes

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

SQLBigQueryDBTData ArchitectureAnalytics EngineeringData EngineeringBI toolsETL/ELT conceptsPythonInterest in sportsFantasy sports experienceSportsbetting experience

Required

Curious and inquisitive nature (you want to know how things work and you ask good questions)

Proactive problem-solver (you notice and act on problems we already have; you anticipate problems we might have in the future and try to solve for those now)

Strong attention to detail (you have the ability to get 'in the weeds' to investigate, understand, and resolve data issues)

Actively accountable (you own and learn from your mistakes; you care about getting things right; you actively solicit feedback)

Comfortable working in a fast-paced environment

Productive and engaged with minimal oversight

You think like an architect (you build solutions that are supportable, minimize technical debt, comprehensive enough to meet most future needs yet flexible enough to adapt when necessary)

Comfortable collaborating and communicating with other architects, engineers, and other diverse groups of stakeholders, sometimes needing to explain technical concepts in a way that's accessible to non-technical users

At least 5 years of experience writing SQL and working with databases in a Data Architecture, Analytics Engineering, or Data Engineering capacity

At least 3 years of experience using BigQuery

At least 2 years of experience using DBT for data transformations and architecture development

Experience or strong familiarity with BI tools such as Sigma or Looker

Familiarity with ETL/ELT concepts and best practices

Advanced proficiency with SQL

Intermediate or better proficiency with Python