Data Engineer, Business Strategy & Analytics
$150,000–$200,000 year
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 data flows from APIs, RSS feeds, webhooks, SFTP servers, and SaaS platforms. Develop modeled datasets for automated reporting across ticketing, partnerships, digital marketing, and customer journey mapping, including identity resolution and golden record systems. Support CRM and analytics teams to deliver reliable solutions and execute analytical approaches to transform complex data into actionable insights. Grow the scope of responsibility for the analytics team and document data processes, schemas, and workflows.
Required Qualifications
- Bachelor's degree
- 0-1 year professional experience building ETL/ELT pipelines, relational database design/management, and data operations
- Expert-level understanding of SQL
- 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
- Strong critical thinking and attention to detail
- Strong organization and prioritization skills
Desired Qualifications
- Preferred degree concentration: computer science, information systems, business analytics, or statistics
- 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
- 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.