Senior Data Architect

Founded by a team of industry veterans, Underdog was born with the idea that bringing strategic innovation to sports gaming and entertainment is the key to success in an exceptionally competitive market. Underdog has quickly established itself as a leader in the space, and is committed to building the best sports gaming platform in the industry -- and supporting the most passionate community of sports fans while doing it!

At Underdog, we’re not only about creating these awesome products, but also about growing our culture of passion, ownership, and fun! We believe that great companies are made out of great people. Our continual aim is to create an inclusive environment for everyone, at all levels, to achieve their highest potential at work.

As a Senior Data Architect, you’ll be instrumental in improving and enhancing Underdog’s reporting layer by designing and developing analytics datasets and data models in BigQuery. In this role, you will work cross-functionally with both the Data Engineering and Business Intelligence teams, as well as other stakeholders across the business to understand the data needs; you will design solutions to meet those needs in a way that is supportable, flexible, and minimizes technical debt.

Please note, Underdog is a US based company and no sponsorship is available for this position at this time. 

• Acquire and maintain in-depth knowledge of all of Underdog's data models and data processes, along with business rules, contest rules, and product functionality
• Keep up with changes to Underdog's core data models and plan what changes might need to be made in the reporting layer
• Develop analytics datasets to meet the needs of the business, taking into account all relevant business rules,  existing reporting architecture, performance and efficiency inside BigQuery, defined requirements, and feedback from stakeholders and other Data team verticals
• Refactor existing datasets as needed to accommodate evolving business needs
• Work with the Data Engineering team to ensure the approach to and code for datasets are aligned with BigQuery best practices and Underdog standards
• 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
• Perform validation and data integrity checks on new datasets and load procedures before delivery to stakeholders
• Investigate and resolve data discrepancies, escalating to the engineering team or other teams as needed
• 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
• Create and maintain documentation about the reporting layer and architectural changes
• 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

• 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)
• Ability to be productive and engaged with minimal oversight
• You think like an architect (you want to 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, preferably as a Data Architect or Data Engineer
• At least 3 years of experience using BigQuery
• Familiarity with ETL/ELT concepts and best practices
• Advanced proficiency with SQL
• Intermediate or better proficiency with Python

• Experience with Airflow or Composer
• Experience with Looker and LookML
• Familiarity with concepts around dynamic SQL, particularly in BigQuery

Underdog Sports is firmly committed to equity, inclusion, and diversity. Our unique culture was built on the foundation of a safe and inclusive environment for people of all backgrounds. We highly value the mental, physical, and emotional health of our employees, and are continuously asking ourselves: what can we do better? Underdog is an equal opportunity employer and doesn't discriminate on the basis of creed, race, sexual orientation, gender, age, disability status or any other defining characteristic. Our targeted compensation rate for this position is between $125,000 and $155,000, depending on experience, plus equity. Think your skills are exceptional and warrant higher pay? Apply anyway! If we agree, we're willing to negotiate. Below you’ll find a few of our perks:

• Unlimited PTO (we're extremely flexible with the exception of the first few weeks before & into the NFL season)
• 16 weeks of fully paid parental leave
• Company paid Health, Dental, Vision plan option for employees and dependents
• 401k Match & FSA
• Remote, In-Person, or Hybrid Scheduling – we are 100% VIRTUAL FIRST!
• A $500 home office allowance
• $100 in UD credit
• Support for learning and development
• Book club – expense your books! 
• Monthly raffle to win a sports ticket reimbursement of up to $500 (including game day snacks!)
• Lastly, an extremely transparent, fun, and engaging culture where you will grow both personally and professionally!

#LI-REMOTE
#LI-DNI