Vanguard is hiring a Data Engineer, Specialist to help design, build, and optimize ETL processes, data pipelines, and cloud-based data infrastructure. This hybrid role in Malvern, PA focuses on delivering scalable and reliable data processing, plus reporting and automation that support business and regulatory needs. If you enjoy turning requirements into maintainable data solutions, contributing to engineering standards, and mentoring others, this role aligns well.
What you’ll do
- Design, develop, and optimize ETL processes, data pipelines, database solutions, and cloud-based data infrastructure to support scalable and dependable analytics.
- Integrate large and complex datasets from multiple sources, troubleshoot data and software issues, and maintain data consistency, quality, availability, and integrity.
- Translate business and regulatory requirements into technical designs, building maintainable and reusable code, queries, and data solutions.
- Build and optimize AWS cloud support services and technologies including Glue, Redshift, Step Functions, and Amazon Q Foundational Services such as IAM, CloudWatch, CloudFormation, Lambda, Secrets Manager, and SageMaker.
- Create Spark data processing applications.
- Build and automate dashboards, reports, and data visualizations using Power BI or similar platforms.
- Automate recurring data analysis and reporting workflows using Python, SQL, and other programming tools to improve efficiency and reduce manual effort.
- Partner with business, compliance, analytics, and technology teams to understand data needs, develop solutions, and communicate technical considerations.
- Assess data quality, test solutions for intended purpose, and support production implementation using established engineering and release practices.
- Act as a subject matter expert across data engineering and analytics, mentoring less-experienced data professionals and helping shape engineering standards and reusable practices.
- Participate in special projects and complete other duties as assigned.
What you’ll need
- 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 multi-source data integration solutions.
- Strong SQL experience for querying, transformation, troubleshooting, and data-quality analysis.
- Experience using Python or other programming languages to build data solutions and automate workflows.
- Experience building reports, dashboards, or data visualizations using Power BI or similar tools.
- Ability to translate business requirements into technical solutions and communicate 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.
Tools and technologies
AWS, Glue, Redshift, Step Functions, Amazon Q Foundational Services, IAM, CloudWatch, CloudFormation, Lambda, Secrets Manager, SageMaker, Spark, Power BI, Python, SQL
Special focus
This role supports data and reporting capabilities associated with Financial Crimes and regulatory compliance.
Visa sponsorship
Vanguard is not offering visa sponsorship for this position.
