Senior Data Engineer - Cloud Pipelines & Financial Analytics

Vanguard; Malvern (Chester County); Hybrid; USD 150,000 - 190,000; Full time

Job summary

Vanguard in Malvern, PA, is seeking an experienced Senior Data Engineer to design and optimize data pipelines supporting financial compliance, analytics, and reporting. This hybrid role requires in-office Tues-Wed-Thurs at HQ in Malvern.

You will build scalable AWS-based data infrastructure, develop Spark jobs, and create dashboards with Power BI to deliver actionable insights to business partners. 8+ years in data engineering and strong SQL/Python skills are expected.

Qualifications

• 8+ years of experience in data engineering or related data-focused disciplines.
• Experience using SQL for data querying, transformation, and data-quality analysis.
• Experience developing reports and dashboards using Power BI or similar platforms.
• Experience translating business requirements into technical solutions and communicating with stakeholders.

Responsibilities

• Designs, develops, and optimizes ETL processes, data pipelines, and cloud data infrastructure.
• Integrates large datasets from multiple sources and ensures data quality and availability.
• Translates requirements into technical designs and reusable code.
• Builds AWS-based data infrastructure and Spark data processing applications.
• Automates dashboards and data visualizations for business users.

Skills

ETL design

SQL

Python

Power BI

Data quality

Cloud AWS

Spark

Stakeholder comms

Education

Bachelor's degree

Tools

AWS Glue

Redshift

Step Functions

IAM

CloudFormation

Lambda

Secrets Manager

Sagemaker

Job description

Vanguard in Malvern, PA, is seeking an experienced Senior Data Engineer to design and optimize data pipelines supporting financial compliance, analytics, and reporting. This hybrid role requires in-office Tues-Wed-Thurs at HQ in Malvern.

You will build scalable AWS-based data infrastructure, develop Spark jobs, and create dashboards with Power BI to deliver actionable insights to business partners. 8+ years in data engineering and strong SQL/Python skills are expected.