Live Events Careers

Data Warehouse Developer - YinzCam (Pittsburgh · PA)

YinzCam jobs
Sports Jobs in Pittsburgh · PA
Marketing: Database Marketing/Analytics
The Data Warehouse Developer is responsible for maintaining large-scale data warehouses that house terabytes of data from our 200+ team/league apps around the world. 

📊 This is an engineering-heavy and programming-heavy role. You will be responsible for maintaining, running, enhancing, and engineering large-scale data-intensive clusters and data warehouses based on Hadoop, Hive, and SQL. You will be writing Java code and advanced SQL queries on a daily basis to provide actionable business insights to sports teams in the NFL, NBA, LaLiga, MLS, NHL, AFL (Australia), South America, and more. 

🤩 The ideal candidate has 3+ years hands-on experience with SQL, 3+ years hands-on experience with Java, 3+ years hands-on experience with Hadoop, and is a subject-matter expert on data warehouses and relational databases. 

What you will be doing...
  • Running complex SQL queries on a daily basis, to support the business needs of sports teams
  • Building, architecting, upgrading, and running large-scale data warehouses used by sports teams
  • Provide daily/weekly/monthly analytics reports to our sports teams
  • Cleaning, organizing, and analyzing terabytes of data from mobile apps
  • Running custom complex SQL queries on very large data sets

Be our MVP if you have...
  • 3 years of hands-on experience with SQL
  • 3 years of Hadoop (Hive and MapReduce)
  • 3 years of programming in Java 
  • 3 years of hands-on experience with AWS cloud infrastructure (EC2, S3, EMR)
  • Experience with deploying and maintaining software on Linux systems
  • Experience with ETL pipelines, and ETL frameworks such as Airflow
  • Strong work ethic with the ability to get things done and meet deadlines
  • Can thrive in a high energy fast-paced digital environment
  • Master’s degree in Computer Science, Data Engineering, or related fields.