Business Intelligence Engineer - Seattle Kraken (Seattle · WA)

Salary Range: $80 - $100k + Bonus

Position: Business Intelligence Engineer

Department: Strategy and Business Intelligence

Reporting to: VP of Business Intelligence

Our Commitment to Diversity, Equity, and Inclusion in Hiring:

The Seattle Kraken aspire to write a new playbook in sports and entertainment that includes everyone. In alignment with this vision, if you don’t meet every job requirement listed—or if you haven’t played ice hockey before or are still learning about the sport—we still encourage you to apply. We understand you may bring other relevant experiences and expertise to help us become the highest performance organization we can be. One of our core values is ‘Make Us Better’ and we recognize diversity, equity, and inclusion as a critical business strategy.  

If you’d like to request an accommodation in the application or interview process, please let us know by emailing: [email protected].

Our Purpose:

We are building a championship organization that serves our fans, community and business partners through world class sports and entertainment. We believe that Winning Matters, our Fans come first, with risk comes reward, great teams can achieve unimaginable results, honoring the Pacific Northwest is our duty and driving the business is our responsibility.

On December 4, 2018, the NHL granted the 32nd NHL franchise to Seattle Hockey Partners.  As the newest addition to the Pacific Division in the Western Conference, the team continues to prepare for its first puck drop in the 2021-2022 NHL season. In addition to the redevelopment of the New Arena at Seattle Center, Seattle Hockey Partners are consecutively building its front office headquarters, training center and three NHL regulation rinks at Northgate. This development represents not only further investment in making Seattle the epicenter of the Pacific Northwest but establishing a skating presence within the city for the first time in more than 40 years.

Climate Pledge Arena, a $1 Billion redevelopment of the facility formerly known as Key Arena and built originally for the 1962 Seattle World’s Fair, will be transformed into a world class, state-of-the-art City jewel and destination. Located at Seattle Center in the heart of Seattle’s Uptown Neighborhood, the new venue will offer a truly unique and intimate experience for the NHL, WNBA, concerts and other entertainment events, while preserving the historic nature of Seattle Center and its surroundings. This project will be a completely new arena beneath its existing historic-landmark roof that will remain in place. Climate Pledge Arena is under construction now, projected opening 2021. The 32nd NHL franchise, the Seattle Kraken will begin play in the 2021-2022 season. 

Position Summary:

The Business Intelligence Engineer will be responsible for developing the reporting layers within the Data Warehouse for the Seattle Kraken, Climate Pledge Arena (CPA), and Kraken Community Iceplex (KCI).  We are looking to grow this team with a strong candidate that can help implement reporting and business logic in our Data Warehouse. 

This employee will be working closely with business users and Business Intelligence Analysts (BIAs) to build out tables within the Data Warehouse to enhance and optimize our reporting and analytics capabilities. The ideal candidate will have a passion for creating data layers that drive continuous and reliable business value. 

Essential Duties & Responsibilities:

• Work with the Data Engineer and Business Intelligence team to create Reporting and Modeled (relational) layer of Data Warehouse
• Generate views using SQL within the Data Warehouse to support the reporting initiatives of the Business Intelligence team
• Own and operate Customer Data Platform (Amperity) that supports automated data flows and delivery to business units
• Develops monitoring scripts/templates to gather metrics, look for patterns & events and to generate alarms
• Build and Maintain Tableau Reports when necessary
• Own end-to-end development of data resources for BI team and business

Required Experience & Qualifications:

•  Bachelor’s degree in Computer Science or equivalent work experience
• 2+ years strong SQL experience
• 2+ years working with a Data Warehouse and creating Pipelines using SQL
• A keen interest in new technologies and open source
• Willingness to research and self-study to keep technical skills relevant in a highly complex environment
• Ability to work independently and as part of a team
• Excellent verbal and written communication skills with great attention to detail and accuracy
• Experience working in an Agile/Scrum environment
• Innovative and ability to think outside the box for creative problem solving

Preferred Experience & Qualifications:

•  Experience with AWS Redshift and PostgreSQL
• Experience with Database Tools (DBT)
• Experience with Customer Data Platforms (CDPs), specifically Amperity

Working Conditions:

• Minimal Travel (<10% travel): May be required to travel. Trips may require air travel and/or overnight stay away from home for one or more nights
• Must be able to work a flexible schedule inclusive of weekends, nights and holidays required
• Frequent bending, lifting 15-20 pounds, sitting, exposure to multiple external elements, extensive walking through the building including inclines and stairs
  
  

Total Rewards Package:

• Compensation:
  • In accordance with Washington’s Equal Pay and Opportunity Act, the expected salary range for this position is $80-$100K. Actual base pay will depend on employee’s experience and other job-related factors permitted by law.
  • Bonus eligibility
  • Monthly cell phone stipend
    
    
• Benefits & Perks:
  • Company-paid medical, dental, and vision insurance, including premiums for eligible dependents enrolled in the plans
  • Company-paid life insurance and short & long term disability insurance
  • Company-paid employee assistance program and Headspace subscription
  • Flexible spending accounts and voluntary accident, critical illness, and hospital indemnity insurance available
  • Company-paid Orca card
  • 401k (pre-tax and Roth) with Company match up to 4%
  • 10 vacation days, 3 personal holidays, and accrued sick time
  • Minimum 11 paid holidays per year
  • Paid parental leave
  • Kraken ticket stipend and employee only pre-sale opportunities to non-Kraken events
  • Discounts at the Kraken Team Stores, Kraken Community Iceplex, 32 Bar & Grill, and other partners
  • Company-wide recognition platform
  • Corporate office located at the Kraken Community Iceplex in Northgate; within walking distance of the Northgate Light Rail Station and Northgate Transit Center; free parking

Seattle Hockey Partners, LLC and Seattle Arena Company, LLC are proud to be an equal opportunity workplace. We do not discriminate on basis of race, color, religion, sex (including pregnancy and gender identity), national origin, political affiliation, sexual orientation, marital status, disability, genetic information, age, membership in an employee organization, parental status, military service, or any protected category prohibited by local, state or federal laws.

Experience

• 3