Senior Data Engineer

Varsity Brands; Farmers Branch (TX); Remote; USD 110,000 - 130,000; Full time

Job summary

A leading company in sports and spirit is looking for a Senior Data Engineer to join their Data Center of Excellence team. This role involves architecting efficient data pipelines to integrate data from multiple sources, ensuring data quality and accessibility for business stakeholders. The ideal candidate will have significant experience in data engineering, SQL, and modern data tools, thriving in a collaborative environment.

Benefits

Comprehensive Health Care Benefits

401(k) plan with company matching

Generous My Time Off & Paid Holidays

Employee Resource Groups

Employee discounts on apparel and equipment

Qualifications

• 3+ years of experience in data engineering with custom ELT/ETL design.
• Strong SQL skills in analytics context with experience in orchestration tools.
• Ability to work with data replication tools and writing custom code.

Responsibilities

• Design and build data pipelines for efficient data movement.
• Collaborate with stakeholders to refine data sourcing needs.
• Monitor and troubleshoot existing data pipelines.

Skills

Data architecture

Data modeling

SQL

Python

Data replication tools

Education

Bachelor's degree in Computer Science or related field

Tools

Snowflake

Tableau

Power BI

HVR

Fivetran

Job description

JOIN THE BEST TEAM IN SPORT & SPIRIT

At Varsity Brands, we believe every student deserves the opportunity to succeed and every educator wants to make a difference. It takes a team to make a real impact, and through our two divisions – BSN SPORTS and Varsity Spirit – and our network of 6,000+ employees and independent representatives, we are proud to partner with a wide range of educational institutions and club and professional sports to transform the student journey in SPORT and SPIRIT.

WORK TYPE: Remote

LOCATION DETAILS:14460 Varsity Brands Way, Farmers Branch, TX 75244

WORK HOURS: Monday – Friday; 8am-5pm CST

TRAVEL REQUIREMENT: Less than 5%

BASE PAY RATE:$110,000 - $130,000

The base salary will vary based on criteria such as education, experience and qualifications of the applicant, location, internal equity, and alignment with the market.

HOW YOU WILL MAKE AN IMPACT

The Senior Data Engineer (Sourcing & Pipeline Management) to the HR team will play an integral role within the growing Varsity Brands Data Center of Excellence team.

The role’s key elements are:

• 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

WHAT YOU WILL DO

• 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.

QUALIFICATIONS

KNOWLEDGE/ SKILLS/ ABILITIES

• Familiarity with modern data stack tools and services employed to replicate data from source systems to cloud data warehouses or lakes, and a solid understanding of when and where a given tool is appropriate. Experience utilizing data replication tools and services like HVR, Fivetran, Airbyte, Meltano, Matillion, as well as 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 as well as to identify source system data capture opportunities to unlock analytics capabilities.
• Strong knowledge in data architecture, data modeling, schema design, and software development principles.

EDUCATION/ EXPERIENCE

• 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.
• Experience standing up data pipelines from SAP ERP is a plus.
• Experience standing up data pipelines from Google Analytics 4 data is a plus.

PHYSICAL REQUIREMENTS

This job operates in a professional office environment. Largely a sedentary role with some filing requiring the ability to lift files, open filing cabinets and bending or standing on a stool as necessary. The ability to sit or stand for long periods through meetings and while operating office equipment, PC’s, laptop, telephone will be required.

While performing the duties of this Job, the employee is regularly required to sit; use hands to finger, handle, or feel; reach with hands and arms and talk or hear. The employee is occasionally required to stand; walk; drive, climb, balance, stoop, kneel, crouch, or crawl.

The ability to stand and walk for long periods of time (5 hours plus) is required. The ability to communicate with customers and colleagues using the following but not limited to radio, walkie talkie, text message and email is required. The ability to lift, bend, push, pull and manipulate equipment that is a minimum of 30 lbs. is required.

#LI-MC1

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities required of the employee for this job.

OUR VALUES

Service - We lead with heart. We champion community.

Passion - We love what we do. It fuels our purpose.

Integrity - We do what we promise. We own our actions and decisions.

Respect - We earn it by giving it. Because everyone deserves it.

Innovation - We never stop striving to be better. For ourselves and our community.

Transparency - We are committed to openness and honesty in everything we do.

OUR BENEFITS

We are committed to putting you and your families first. For benefits eligible roles, we offer a variety of choices and costs as well as program enhancements that align with our responsibility to elevate the employee experience. Some of our offerings include:

• 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!

Varsity Brands companies are equal opportunity employers. Qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, citizenship, gender, sexual orientation, gender identity, veteran’s status, age or disability.