Data Engineer, Specialist

Vanguard is hiring a Data Engineer, Specialist to design and optimize ETL processes, data pipelines, and cloud-based data infrastructure that support reporting and analytics.

Responsibilities

• Design, develop, and optimize ETL processes, data pipelines, database solutions, and cloud-based data infrastructure for scalable and reliable data processing.
• Integrate large and complex datasets from multiple sources and troubleshoot data or software issues to ensure consistency, quality, availability, and integrity.
• Translate business and regulatory requirements into technical designs.
• Develop maintainable and reusable code, queries, and data solutions.
• Build and support AWS cloud capabilities, including AWS services such as Glue, Redshift, Step Functions, and Amazon Q Foundational Services like IAM, CloudWatch, CloudFormation, Lambda, Secrets Manager, and SageMaker.
• Develop Apache Spark data processing applications.
• Create and automate dashboards, reports, and data visualizations using Power BI (or similar platforms) to support business partners.
• 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, deliver solutions, and explain technical considerations.
• Collaborate with leadership and business partners to communicate data and analytical findings to both technical and non-technical audiences.
• Assess data quality, test solutions for intended use, and support implementation into production using established engineering and release practices.
• Act as a subject matter expert in data engineering and analytics, mentor less-experienced professionals, and help define engineering standards and reusable practices.
• Participate in special projects and complete other duties as assigned.

Requirements

• 8+ years of experience in data engineering, programming, database development or administration, data management, or related data-focused disciplines.
• 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.
• SQL experience for querying, transforming, troubleshooting, and data-quality analysis.
• Python (or other programming languages) experience for building data solutions and automating workflows.
• Experience building reports, dashboards, or data visualizations using Power BI or similar tools.
• 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).

Key Technologies

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

Additional Information

• Role supports data and reporting capabilities related to Financial Crimes and regulatory compliance.
• Visa sponsorship: Vanguard is not offering visa sponsorship for this position.

Location

• Malvern, PA (hybrid)