Senior Data Engineer

WORK TYPE: Hybrid applicants can be located in Texas Indiana Tennessee and Kansas

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

Applicants must be authorized to work in the U.S. without sponsorship. No sponsorship offered for this role. 

TRAVEL REQUIREMENT: Less than 5%

BASE PAY RATE:    $110000 - $130000

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) 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 particularly using Snowflake  and solid understanding of when and where a given tool is appropriate.
• 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.

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

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.  

What We Do

Varsity Brands elevates the student experience- in Sport Spirit and Achievement. We are BSN SPORTS the recognized leader in athletic gear; Varsity Spirit the driving force in spirit; and Herff Jones the most trusted name in celebrating student milestones. We partner with educators coaches and students to build school pride student engagement and community spirit. With a mission to inspire achievement and create memorable experiences for young people Varsity Brands elevates the student experience promotes participation and celebrates achievement through three unique but interrelated businesses: BSN SPORTS a Varsity Sport Brand; Varsity Spirit; and Herff Jones A Varsity Achievement Brand. Together these assets promote personal school and community pride through their customizable products and programs to elementary and middle schools high schools and colleges and universities as well as church organizations professional and collegiate sports teams and corporations. Through its dedicated employees and independent representatives Varsity Brands reaches its individual and institutional customers each year through competitions camps and sales.