Data Engineer, Specialist

Vanguard is hiring a Data Engineer, Specialist for a hybrid role in Malvern, PA. In this position, you will help design and optimize ETL processes, data pipelines, and cloud-based data infrastructure that support scalable and dependable analytics.

Working across business, compliance, analytics, and technology teams, you will translate business and regulatory requirements into technical solutions, build reporting and visualizations, and automate recurring data workflows to reduce manual effort.

What you will do

• Design, develop, and optimize ETL processes, data pipelines, database solutions, and cloud-based data infrastructure for reliable, scalable data processing.
• Integrate large, complex datasets from multiple sources, and troubleshoot data and software issues to maintain data consistency, quality, availability, and integrity.
• Translate business and regulatory requirements into technical designs and develop maintainable, reusable code, queries, and data solutions.
• Build and support AWS cloud capabilities, including AWS Glue, Amazon Redshift, Step Functions, and Amazon Q Foundational Services such as IAM, CloudWatch, CloudFormation, Lambda, Secrets Manager, and SageMaker.
• Develop Spark data processing applications.
• Create and automate dashboards, reports, and data visualizations using Power BI (or similar platforms) to support business stakeholders.
• Automate recurring data analysis and reporting workflows using Python, SQL, and other programming tools to improve efficiency and reliability.
• Collaborate with partners across business, compliance, analytics, and technology to understand data needs, shape solutions, and communicate technical considerations.
• Assess data quality, test solutions for their intended purpose, and support production implementation using established engineering and release practices.
• Act as a subject matter expert across data engineering and analytics by mentoring less-experienced professionals and contributing to engineering standards and reusable practices.
• Participate in special projects and perform other duties as assigned.

What you bring

• 8+ years of experience in data engineering, programming, database development or administration, data management, or related data-focused disciplines.
• An undergraduate degree or an equivalent combination of education, training, and relevant experience.
• Experience developing and optimizing ETL processes, data pipelines, and solutions that integrate data from multiple sources.
• Experience using SQL for querying, transformation, troubleshooting, and data-quality analysis.
• Experience using Python or other programming languages to develop data solutions and automate workflows.
• Experience developing reports, dashboards, or data visualizations using Power BI or similar platforms.
• Experience translating business requirements into technical solutions and communicating with technical and non-technical stakeholders.
• Experience with cloud-based data platforms or large-scale data-processing environments (preferred).
• Experience supporting Financial Crimes, SEC regulatory reporting, regulatory compliance, or financial services data (preferred).

Technology stack

• AWS, Glue, Redshift, Step Functions, Amazon Q Foundational Services, IAM, CloudWatch, CloudFormation, Lambda, Secrets Manager, SageMaker
• Spark, Power BI, Python, SQL

Additional information

• Special focus: Supports data and reporting capabilities associated with Financial Crimes and regulatory compliance.
• Visa sponsorship: Vanguard is not offering visa sponsorship for this position.