405 Senior Data Engineer (Python, Java, Redshift) Jobs in Pittsburgh, PA
YinzCam, Inc. is Hiring a Senior Data Engineer (Python, Java, Redshift) Near Pittsburgh, PA
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
Job Summary
Full Time
$114k-140k (estimate)
06/23/2024
07/12/2024
yinzcam.com
Pittsburgh, PA
200 - 500
Business Services
Related Companies
The following is the career advancement route for Senior Data Engineer (Python, Java, Redshift) positions, which can be used as a reference in future career path planning. As a Senior Data Engineer (Python, Java, Redshift), it can be promoted into senior positions as a CAE Designer IV that are expected to handle more key tasks, people in this role will get a higher salary paid than an ordinary Senior Data Engineer (Python, Java, Redshift). You can explore the career advancement for a Senior Data Engineer (Python, Java, Redshift) below and select your interested title to get hiring information.
If you are interested in becoming a Senior Data Engineer, you need to understand the job requirements and the detailed related responsibilities. Of course, a good educational background and an applicable major will also help in job hunting. Below are some tips on how to become a Senior Data Engineer for your reference.
Step 1: Understand the job description and responsibilities of an Accountant.
Quotes from people on Senior Data Engineer job description and responsibilities
The Senior Data Engineer builds data processing frameworks that handle the business’s growing database.
03/09/2022: Billings, MT
The Senior Data Engineer owns and extends the business’s data pipeline through the collection, storage, processing, and transformation of large data-sets.
01/05/2022: Melbourne, FL
Create architecture for real-time, big data applications with minimal maintenance effort.
03/23/2022: Benton Harbor, MI
Work with both structured and unstructured data, with focus on ETL (Extract, Transfer, Load) and stabilizing pipelines and code.
01/22/2022: Greenville, MS
Provides successful deployment and provisioning of data solutions to production or other required environments.
01/12/2022: Dothan, AL
Step 2: Knowing the best tips for becoming an Accountant can help you explore the needs of the position and prepare for the job-related knowledge well ahead of time.
Career tips from people on Senior Data Engineer jobs
Apply for an entry-level data engineer role and gain experience.
02/06/2022: Providence, RI
Earn a bachelor’s degree related to data engineering and begin working on projects.
02/16/2022: Denver, CO
Consider pursuing additional professional engineering or big data certifications.
03/06/2022: Raleigh, NC
Gain knowledge with new data architecture principles and concepts, thorough understanding of layered systems architectures.
01/24/2022: Abilene, TX
Senior data engineers should also have an understanding of other programming languages that help with statistical analysis and modeling, such as Python.
01/02/2022: New York, NY
Step 3: View the best colleges and universities for Senior Data Engineer.
