Senior Data Engineer (SQL, Java, Redshift)

NOTE: This in an in-office role in Pittsburgh, PA, USA.

ABOUT YINZCAM

Our digital products are used by 200+ professional sports teams and leagues around the world, including clubs in the NFL, NBA, MLS, NHL, LigaMX, AFL (Australia), and more.

THE ROLE

As a Senior Data Engineer, you will be responsible for collecting, organizing and analyzing terabytes of mobile-app data on a daily basis. Your responsibilities will include:

• Building new Python-based ETL workflows, from scratch, to ingest data reliably into our data warehouse.
• Maintaining existing Java-based and Python-based ETL workflows, including enhancements, troubleshooting, and support.
• Building tools to monitor these ETL workflows, and performing problem-diagnosis for any faulty workflows.
• Running daily/weekly/monthly complex and custom SQL queries to create analytics reports for clients.
• Building data-export workflows to send data into externally-hosted data warehouses.
• Producing Tableau dashboards and reports for distribution to clients.

THE REQUIREMENTS

This is a programming-heavy role requiring advanced Python and SQL programming skills.

• 5+ years of experience in Python programming (a must)
• 5+ years of experience in writing complex SQL queries (a must)
• 5+ years of experience with DynamoDB, Redshift, Kinesis, serverless Lambda functions (a must)
• 5+ years of experience with Tableau(a must)
• Experience with building custom ETL pipelines from scratch, using ETL frameworks such as Airflow.
• Ability to jump into production code with little/no training, and the ability to deliver from day one.
• Appetite and ability to thrive in a high energy fast-paced digital environment.
• Willingness and ability to work the non-traditional hours of the sports industry.

THE BENEFITS

• Paid time off every year
• Paid maternity and paternity leave
• Full medical, dental and vision health insurance
• Paid gym membership in LA Fitness
• Paid Coursera plan to take 8000+ courses around the world
• Beverages and snacks
• Paid parking near the office
• Relocation assistance to Pittsburgh, if needed
• Building products for well-known sports teams