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
  • 30+ days ago
Related jobs
Promoted
Canonical - Jobs
Pittsburgh, Pennsylvania

Python and Kubernetes Specialist Engineers focused on Data, AI/ML and Analytics Solutions. Our platform, Ubuntu, is very widely used in breakthrough enterprise initiatives such as public cloud, data science, AI, engineering innovation and IoT. As a software engineer on the team, you'll collabora...

Promoted
Latitude AI LLC
Pittsburgh, Pennsylvania

Bachelor's degree in Computer Engineering, Computer Science, Electrical Engineering, Robotics or a related field and 4+ years of relevant experience (or Master's degree and 2+ years of relevant experience, or PhD). When you join the Latitude team, you’ll work alongside leading experts across machine...

Promoted
Aurora
Pittsburgh, Pennsylvania

Software Engineer - Autonomy Data: Labels Platform. We also provide data models and service interfacing supporting a variety of autonomy data consumers. Our team is responsible for production services supporting high volume data labeling operations. Autonomy performance is directly dependent on data...

Promoted
Insight Global
Pittsburgh, Pennsylvania
Remote

Design, develop, and maintain scalable and efficient data pipelines for extracting, transforming, and loading (ETL) data from various sources into our data warehouse leveraging AWS, Databricks, Python and SQL technologies. Python, Java, Scala) for data processing and scripting. Stay updated on indus...

Promoted
YinzCam, Inc.
Pittsburgh, Pennsylvania

This is a programming-heavy role requiring advanced expertise in Java, C#, and SQL. SQL queries and using relational databases. RESTful APIs using both XML and JSON data formats. DynamoDB, Hadoop, Spark, Hive, Redshift. ...

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...

Wounded Warrior Project
Pittsburgh, Pennsylvania

The Wounded Warrior Project (WWP) Senior Data Engineer is a member of the Web, Data, and Analytics team responsible for data engineering and programming to build systems that collect, manage, and convert raw data into usable information for business analysts. Build required infrastructure for optima...

SSi People
Pittsburgh, Pennsylvania

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

Ectobox Inc.
Pittsburgh, Pennsylvania

Senior Data Integration Engineer in Manufacturing. Systems Integrator and we love solving difficult problems with data and information in manufacturing. If you're an ENGINEER in MANUFACTURING that is smart and can get things done…then answer these question...

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...