Senior Data Engineer

December 16, 2023

Apply Now

Receive Emails with Similar Jobs

Underdog Fantasy

WebsiteLinkedInAll Job Openings

sports • gaming • fantasy

201 - 500

Description

• 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 • 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

Requirements

• 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 • Even better if you have: Interest in sports, Experience with fantasy sports or sportsbetting

Benefits

• Unlimited PTO • 16 weeks of fully paid parental leave • Monthly raffle to win a sports ticket reimbursement of up to $500 • A $500 home office allowance • Underdog credits to play on our platform • A connected virtual first culture with a highly engaged distributed workforce • 5% 401k match, FSA, company paid health, dental, vision plan options for employees and dependents • 5.0 rating on Glassdoor and a 100% CEO Approval rating • A+ culture score on Comparably • Recognized as Best Place to Work by Front Office Sports • Recognized by Comparably under the following awards: Best CEOs for Women, Best CEOs for Diversity, Best Company for Career Growth, Best Company in New York, Best Company Outlook • Underdog Sports is firmly committed to equity, inclusion, and diversity. We built our unique culture on the foundation of a safe and inclusive environment for people of all backgrounds. We highly value our employees' mental, physical, and emotional health and continuously ask ourselves: what can we do better?