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