Data Engineer, Business Strategy & Analytics

Nashville
Nashville, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Junior

Job location

Nashville, United States of America

Tech stack

JavaScript
Microsoft Excel
API
Amazon Web Services (AWS)
Amazon Web Services (AWS)
Data analysis
Software as a Service
Information Systems
Databases
Data Validation
Data Files
ETL
Dataspaces
Data Systems
Data Warehousing
Relational Databases
Digital Technology
R
Identity and Access Management
Python
PostgreSQL
Open Source Technology
Query Optimization
Rich Site Summary (RSS)
DataOps
SQL Stored Procedures
SQL Databases
Data Streaming
File Transfer Protocol (FTP)
Database Optimization
Amazon Web Services (AWS)
Information Technology
Webhooks
Data Pipelines
User Identification
Redshift

Job description

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., * 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.

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.

Benefits & conditions

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 [email protected] 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.

Apply for this position