Ottawa Senators Hockey Club

Data Engineer, Business Strategy & Analytics

Ottawa Senators Hockey Club  •  Nashville, TN (Onsite)  •  3 hours ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

Job Title: Data Engineer, Business Strategy & Analytics
Department: Business Strategy & Analytics
Job Reports To: Sr. Director, Business Strategy & Analytics
Status: Exempt

The Data Engineer will be a key contributor in the overall business supporting the Organization’s NHL, Arena, and Sabertooth Sports & Entertainment business units.
The Data Engineer will play a key role supporting the organization’s data ecosystem, contributing to the development, maintenance, and optimization of data pipelines and systems that power sales, marketing initiatives, fan engagement, and analytics efforts.
The ideal candidate possesses a comprehensive engineering skillset along with experience in building and managing ETL/ELT data pipelines; writes and manages complex SQL scripts, stored procedures, views, has experience managing the datasets that support statistical modeling, visualizations, and overall is someone who thrives in a collaborative environment, is detail-oriented, and is passionate about building data solutions that drive business value.
Responsibilities:
• Contribute to operational strategy on database architecture and design for the business strategy & analytics function of the business.
• Optimize reporting and analysis datasets for improved performance and expanded resourcing capabilities through normalization, indexing strategies, and query optimization.
• Design and manage ETL/ELT pipelines, data migrations, and data validation processes including data flows available over API’s, RSS feeds, webhooks, SFTP servers, and SaaS platforms.
• Develop modeled data sets designed for automated reporting across ticketing, partnerships, digital marketing, and customer journey mapping.
• Experience with identity resolution/golden record systems creation and management.
• Support CRM and Analytics teams to understand data needs and deliver reliable solutions.
• Grow the scope of responsibility and impact of the analytics team and the overall Business Strategy & Analytics department.
• Execute techniques to identify, extract and analyze data to support business decisions.
• Execute analytical approaches to transform complex data into thoughtful, actionable
insights.
• Contribute to documentation of data processes, schemas, and workflows.

Minimum Requirements:
• Bachelor's degree with a consistent track record of professional and personal achievement. Preferred degree concentration: computer science, information systems, business analytics, or statistics.
• 0-1 year professional experience building ETL/ELT pipelines, relational database design/management, and data operations.
• Expert-level understanding of SQL (PostgreSQL preferred).
• Familiarity with Amazon Redshift related AWS Services (S3, RDS, IAM, Glue, DMS) a plus.
• Proficient in R, Python, Javascript, or any other open-source tool for data pipeline building/management.
• Deep understanding of dimensional data modeling concepts and practical experience building star schemas, including the definition of facts, dimensions, and slowly changing dimensions.
• Exceptional Microsoft Excel skills.
• Understanding of ticket operations (Ticketmaster/TM1/Archtics) a plus.
• Understanding of CRM systems data a plus.
• Must be able to identify problems, their sources, and their potential solutions while continuing to successfully conduct day-to-day operations without interruption.
• Excellent interpersonal and communications skills, with strong critical thinking and attention to detail.
• Experience in the Sports and Entertainment industry is a strong plus.
• Strong organization and prioritization skills.

Essential Physical Functions:
• Ability to sit for extended periods of time.
• Ability to stand in an upright position for continuous period of time.
• Excellent speaking and listening skills, requiring the perception of speech.
• Accessing, typing, and processing records via digital systems.

Note: Nothing in this job description restricts management’s right to assign or reassign duties and responsibilities to this job at any time. Employees will be required to follow any other job-related instructions and to perform any other job-related duties requested by any person authorized to give instructions or assignments.

Preds Perks: In addition to medical, dental, vision, and life insurance, all full-time employees of the Nashville Predators and entities are eligible for Preds Perks. These currently include the following: Competitive pay, referral bonuses, 401K eligibility, priority access to event presales, tickets to events (when available), Nashville Locker Room (pro shop) discount, premium pay for overnight shifts, 19+ days of paid time off each year, Ford Ice Center programming discount, on demand pay, and bonus potential.

Equal Opportunity Employer: Nashville Predators is an equal opportunity employer. The organization does not discriminate on the basis of race, color, religion, sex (including pregnancy), sexual orientation, gender identity, national origin, age, veteran status, or disability status, genetic information, or any other applicable federal or state protected classification. The organization celebrates diversity and is committed to an inclusive environment for all employees.

In order to ensure reasonable accommodation for individuals protected by the Americans with Disabilities Act, as amended, applicants that require accommodation in the job application process may contact our Recruitment Team at recruiter@teamsmashville.com to request an accommodation

Preds Perks: In addition to medical, dental, vision, and life insurance, all full-time employees of the Nashville Predators and entities are eligible for Preds Perks. These currently include the following: Competitive pay, referral bonuses, 401K eligibility, priority access to event presales, tickets to events (when available), Nashville Locker Room (pro shop) discount, premium pay for overnight shifts, 19+ days of paid time off each year, Ford Ice Center programming discount, on demand pay, and bonus potential.

Equal Opportunity Employer: Nashville Predators is an equal opportunity employer. The organization does not discriminate on the basis of race, color, religion, sex (including pregnancy), sexual orientation, gender identity, national origin, age, veteran status, or disability status, genetic information, or any other applicable federal or state protected classification. The organization celebrates diversity and is committed to an inclusive environment for all employees.

In order to ensure reasonable accommodation for individuals protected by the Americans with Disabilities Act, as amended, applicants that require accommodation in the job application process may contact our Recruitment Team at recruiter@teamsmashville.com to request an accommodation.
Ottawa Senators Hockey Club

About Ottawa Senators Hockey Club

Vision -- Celebrate a Stanley Cup win in Hockey Country.

Our mission -- Deliver memorable entertainment experiences, build a stronger community and create fans for life.

Our values -- We believe in:

- Integrity ... forms the basis for everything we do, by building character on the ice, in the community, with our fans and partners.

- Commitment ... to each other, our partners and most importantly to put our fans first every day.

- Innovation ... generate new ideas, embrace change and deliver creative solutions.

- Passion ... for Canada's game, Ottawa's rich history and our home team.

- Community ... we inspire and unite the entire Ottawa-Gatineau region as one 'Sens Army'​. We are the heart of Hockey Country.

- Perseverance ... our drive for excellence is based on a 'hard-work-conquers-all'​ attitude and is fueled by our hunger to the Stanley Cup.

Industry
Arts & Entertainment
Company Size
201-500 employees
Headquarters
Ottawa, CA
Year Founded
1989
Website
nhl.com
Social Media