Search jobs > Pittsburgh, PA > Senior data engineer

Senior Data Engineer (Python, Java, Redshift)

YinzCam, Inc.
Pittsburgh, PA, United States
Full-time

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
  • 20 days ago
Related jobs
Promoted
Comcast Corporation
Millvale, Pennsylvania
Remote

Powered by premium video content, robust data, and advanced technology, we’re making it easier for buyers and sellers to transact across all screens, data types, and sales channels. ...

Promoted
Comcast Corporation
Pittsburgh, Pennsylvania
Remote

As the team grows, we are looking for a savvy Senior Software Engineer to join the team and help build the next generation of Audience & Identity data platform that handles data at scale and uses state-of-the-art technologies to unlock the data’s business value. If you’re excited to work with a tigh...

Promoted
Comcast Corporation
Pittsburgh, Pennsylvania
Remote

Powered by premium video content, robust data, and advanced technology, we’re making it easier for buyers and sellers to transact across all screens, data types, and sales channels. ...

Promoted
ConsultUSA
Pittsburgh, Pennsylvania

Bachelor's degree in computer science/software engineering/relevant field is a plus. Occasional presentations to senior management, strategy and roadmaps and solutions. ...

Promoted
The PNC Financial Services Group, Inc
Pittsburgh, Pennsylvania

Partners with Data Architects, Data Analysts, Data Engineers and Visualization Experts to develop data-driven solutions for the business. Directs the data gathering, data processing and data mining of large and complex datasets. Data Architecture, Data Mining, Disruptive Innovation, Information Capt...

Promoted
PDF Solutions
Pittsburgh, Pennsylvania

Collaborate with data engineers to architect big data systems that support AI/ML workloads, ensure data quality, and guide optimization for model requirements. If you possess deep expertise in both AI/ML and large-scale data engineering, and you find excitement in architecting transformative analyti...

Promoted
Accenture
Pittsburgh, Pennsylvania

Key Responsibilities:Utilize strong SQL & Python skills to engineer sound data pipelines and conduct routine and ad hoc analysis to assess the performance of legacy products and the saliency of new features. Interface with other data engineering, product, and data science teams to implement client n...

Techstra Solutions
Pittsburgh, Pennsylvania

Responsibilities:  Data Collection and Integration: Collect, clean and integrate data from various sources into Azure data services such as Azure Data Lake Storage, Azure Synapse Analytics and Azure SQL Database Data Modeling and Analysis: Design and implement data models to support business re...

Serigor Inc.
Pittsburgh, Pennsylvania

Position: Senior Data Center Network Engineer (with Cloud exp) Location: Hybrid- Multiple locations Pittsburgh, PA, Strongsville, OH, Birmingham, AL, Farmers Branch, TX, Cincinnati, OH, Miamisburg, OH, Downers Grove, IL, Overland Park, KS, Philadelphia, PA, Columbus, OH, Little Rock, AR, Jacksonvill...

SSi People
Pittsburgh, Pennsylvania

Java, Collections, Multithreading, design patterns. ...