Senior Data Engineer - Snowflake

August 8

Apply Now

Receive Emails with Similar Jobs

Varsity Brands

WebsiteLinkedInAll Job Openings

Sports • B2B • Education

Varsity Brands is a company dedicated to building school pride, student engagement, and community spirit through their two main divisions: BSN SPORTS and Varsity Spirit. They offer customizable products and programs for schools and sports organizations across North America, supporting elementary, middle, and high schools, as well as colleges, universities, and professional sports teams. As a leading marketer, manufacturer, and distributor of sporting goods, Varsity Brands partners with educational institutions to enhance the student experience, focusing on sports, cheer, dance, performing arts, and more. Headquartered in Dallas, Texas and Memphis, Tennessee, Varsity Brands strives to make a positive impact in communities by promoting personal and collective pride.

5001 - 10000 employees

⚽ Sports

🤝 B2B

📚 Education

📋 Description

• The Senior Data Engineer (Sourcing & Pipeline Management) will play an integral role within the growing Varsity Brands Data Center of Excellence team. • Architect + Implement: Design, build and launch efficient and reliable data pipelines to move data from source platforms, including front-end applications, back-end systems, and third-party analytics and data services, to our enterprise data hub. • In addition, design and build pipelines to supply downstream enterprise applications with prepared reference data from our enterprise data hub. • Orchestrate + Monitor: Manage data pipelines as an interdependent network, with proactive visibility into pipeline errors as well as costs over time. • Partner + Educate: Partner with stakeholders to understand business requirements, work with cross-functional data and products teams, and build efficient and scalable data solutions. • Use your data and analytics experience to identify gaps and propose improvements in existing systems and processes, as well as making your source data pipelines easily accessible to data stakeholders. • Working with data modelers and analysts to identify and prioritize data sourcing gaps. • Assessing best fit tool for any given data source. • Establishing pipeline cadences and timing based on analytics needs and use cases while being cost conscious. • Providing downstream data stakeholders visibility to pipeline scheduling and status. • Responsively troubleshooting errors or alerts in existing pipelines. • Tracking and summarizing current period pipeline costs and trends for business and IT stakeholders.

🎯 Requirements

• Familiarity with modern data stack tools and services employed to replicate data from source systems to cloud data warehouses or lakes particularly using Snowflake • Experience utilizing data replication tools and services like HVR, Fivetran, Airbyte, Meltano, & Matillion a MUST • Proficiency writing custom code to source data from APIs when needed • Ability to work collaboratively with product or application owners to tease out relevant raw data is available to source • Ability to identify source system data capture opportunities to unlock analytics capabilities • Strong knowledge in data architecture, data modeling, schema design, and software development principles. • 3+ years of experience in the data engineering/warehousing space, custom ELT/ETL design, implementation, and maintenance • 3+ years of experience writing SQL in an analytics or data pipeline context • 2+ years of experience in at least one language (Python, Scala, Java, etc) in a data engineering or analytics context • 1+ year of experience using an orchestration tool or service to coordinate ELT and downstream analytics pipelines • Experience using REST APIs to acquire and flow data from source to target systems • Experience working with cloud data analytics platforms and tools, particularly Snowflake, dbt, Tableau and Power BI a MUST • Experience standing up data pipelines from SAP ERP is a plus • Experience standing up data pipelines from Google Analytics 4 data is a plus.

🏖️ Benefits

• Comprehensive Health Care Benefits • HSA Employer Contribution/ FSA Opportunities • Wellbeing Program • 401(k) plan with company matching • Company paid Life, AD&D, and Short-Term Disability • Generous My Time Off & Paid Holidays • Varsity Brands Ownership Program • Employee Resource Groups • St. Jude Partnership & Volunteer Opportunities • Employee Perks including discounts on personal apparel and equipment!