remote
Data Engineer I - PrizePicks
Data Engineer
Entry‑level Data Engineer responsible for designing, building, and maintaining scalable data pipelines and warehouses using Python, SQL, AWS, Airflow, and Snowflake to support analytics and machine‑learning workloads.
About the role
Key Responsibilities
- Design, develop, and maintain robust ETL pipelines that ingest and transform high‑volume sports and user data.
- Build and optimize data models and warehouse structures in Snowflake to enable self‑service analytics.
- Implement workflow orchestration using Apache Airflow, ensuring reliable scheduling and monitoring of data jobs.
- Collaborate with data scientists, analysts, and product teams to understand data requirements and deliver timely solutions.
- Monitor data quality, performance, and cost efficiency on AWS, applying best practices for security and scalability.
Requirements
- 2+ years of hands‑on experience with Python and SQL for data processing.
- Proficiency in AWS services (S3, Redshift/Snowflake, Lambda, IAM) and cloud‑based data pipelines.
- Experience building and maintaining Airflow DAGs or similar orchestration tools.
- Strong understanding of data modeling, schema design, and ETL best practices.
- Ability to troubleshoot complex data issues and communicate solutions to cross‑functional teams.
Skills
pythonsqlawssnowflake