remote
Sr Data Engineer I - Principal Financial Group
Data Engineer
Senior Data Engineer focused on building scalable, governed data pipelines that move transactional data into enterprise analytics platforms using Python, SQL, Airflow, Snowflake, and AWS, while ensuring data quality and supporting advanced analytics use cases.
About the role
Key Responsibilities
- Design, develop, and maintain end‑to‑end data pipelines that ingest, transform, and load transactional data into Snowflake for analytics and reporting.
- Implement robust data quality, lineage, and governance checks using Airflow DAGs and custom Python scripts.
- Collaborate with data scientists, analysts, and product teams to understand emerging data use cases and deliver scalable data products.
- Optimize pipeline performance and cost efficiency on AWS infrastructure, leveraging services such as S3, Glue, and Redshift.
- Document data models, architecture decisions, and best practices to support knowledge sharing across the engineering organization.
Requirements
- 5+ years of experience in data engineering, with a strong background in Python, SQL, and ETL development.
- Proven expertise building scalable pipelines on Snowflake and orchestrating workflows with Airflow.
- Hands‑on experience with AWS services (S3, Glue, Redshift, Lambda) and data governance tools.
- Solid understanding of data modeling, schema design, and performance tuning.
- Excellent communication skills and a collaborative mindset for cross‑functional teamwork.
Skills
pythonsqlairflowsnowflakeaws