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 workflow s, 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
