Job Type: Full Time

Job Category: IT

Job Description

Role: AWS Python Data Engineer
Location: Malvern, PA (Onsite)
FTE

Job Description

We are looking for an experienced AWS Python Data Engineer to design, develop, and support scalable data pipelines and data solutions. The ideal candidate will have strong hands-on experience with Python, SQL, AWS, ETL/ELT processes, and large-scale data processing. Candidates with prior Vanguard experience are highly preferred.

Key Responsibilities

• Design, develop, and maintain scalable ETL/ELT data pipelines.
• Build and optimize AWS-based data solutions and data architectures.
• Develop data processing and automation solutions using Python and PySpark.
• Work with AWS services such as Glue, S3, Lambda, Redshift, EMR, Athena, and Step Functions.
• Integrate data from APIs, databases, files, and other internal and external sources.
• Write and optimize SQL queries and support data modeling and data warehousing initiatives.
• Implement data quality checks and ensure data accuracy, integrity, and reliability.
• Troubleshoot data pipeline and production issues.
• Collaborate with data analysts, data scientists, and business stakeholders.
• Support CI/CD, version control, testing, and deployment processes.

Required Skills

• Strong hands-on experience with Python.
• Strong experience with AWS Data Services.
• Strong SQL development experience.
• Experience with ETL/ELT and data pipeline development.
• Experience with PySpark/Apache Spark.
• Experience with AWS Glue, S3, Lambda, Redshift, EMR, Athena, and Step Functions.
• Experience with data lakes, data warehouses, and large-scale data processing.
• Knowledge of data modeling and data integration.
• Experience with APIs, JSON, and cloud-based data platforms.
• Experience with CI/CD and version control tools such as Git.

Preferred Skills

• Prior Vanguard experience is highly preferred.
• Experience with Apache Airflow.
• Experience with Apache Iceberg and Parquet.
• Knowledge of streaming technologies such as Kafka or Kinesis.
• Experience with data governance, security, and IAM.
• Financial services or investment management domain experience.

Required Skills