onsite
Data Engineer - Data & Analytics Technology - PNC
Data Engineer
Data Engineer responsible for designing, building, and maintaining scalable data pipelines and warehouses using Python, SQL, Snowflake, and AWS services to enable analytics and reporting across the organization.
About the role
Key Responsibilities
- Design, develop, and maintain robust ETL pipelines to ingest, transform, and load data from multiple sources into Snowflake.
- Collaborate with data analysts, scientists, and business stakeholders to understand data requirements and deliver reliable data models.
- Implement data quality checks, monitoring, and alerting using tools such as Apache Airflow and AWS CloudWatch.
- Optimize SQL queries and data warehouse structures for performance and cost efficiency.
- Participate in code reviews, documentation, and best‑practice adoption for data engineering standards.
Requirements
- 3+ years of hands‑on experience building data pipelines with Python and SQL.
- Strong knowledge of cloud platforms, preferably AWS (S3, Redshift/Snowflake, Lambda, Glue).
- Experience with workflow orchestration tools like Apache Airflow or similar.
- Proficiency in data modeling concepts and designing scalable data warehouses.
- Solid understanding of version control (Git) and CI/CD practices for data workloads.
Skills
pythonsqlsnowflakeaws