Data Engineer, Business Strategy & Analytics
On-siteNashville, Tennessee, United States
Job Summary
Contribute to operational strategy on database architecture and design while optimizing reporting datasets through normalization, indexing, and query performance tuning. Design and manage ETL/ELT pipelines, data migrations, and validation processes for flows across APIs, RSS feeds, webhooks, SFTP servers, and SaaS platforms. Develop modeled datasets for automated reporting on ticketing, partnerships, digital marketing, and customer journey mapping, alongside identity resolution and golden record systems. Support CRM and analytics teams to deliver reliable solutions and grow the scope of the analytics team within the Business Strategy & Analytics function. Execute analytical approaches to transform complex data into actionable insights and maintain comprehensive documentation of data processes, schemas, and workflows.
Required Qualifications
- 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)
- 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
- 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
- Strong organization and prioritization skills
- 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
Desired Qualifications
- Familiarity with Amazon Redshift related AWS Services (S3, RDS, IAM, Glue, DMS) a plus
- Understanding of ticket operations (Ticketmaster/TM1/Archtics) a plus
- Understanding of CRM systems data a plus
- Experience in the Sports and Entertainment industry is a strong plus
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.