Data Engineer - AWS, Spark & Analytics (Hybrid)

The Vanguard Group; Pennsylvania; Híbrido; USD 140.000 - 190.000; Jornada completa

Descripción de la vacante

Vanguard Group is seeking a senior data engineer to design, develop, and optimize ETL processes and data pipelines within a hybrid role in Malvern, PA. The position focuses on building scalable data infrastructure, integrating diverse data sources, and ensuring data quality for analytics and regulatory reporting.

You will leverage AWS services (Glue, Redshift, Lambda, IAM, CloudWatch) and Spark for large-scale processing, while delivering dashboards and insights with Power BI.

Formación

• 8+ years of experience in data engineering, programming, database development or related data-focused disciplines.
• Undergraduate degree or equivalent education/experience.
• Experience developing and optimizing ETL processes and data pipelines 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 or dashboards using Power BI or similar platforms.
• Experience translating business requirements into technical solutions and communicating with stakeholders.
• Experience with cloud-based data platforms or large-scale data-processing environments, preferred.

Responsabilidades

• Designs, develops, and optimizes ETL processes, data pipelines, and cloud-based data infrastructure.
• Integrates large datasets from multiple sources and ensures data quality, availability, and integrity.
• Translates business and regulatory requirements into technical designs and develop maintainable code.
• Builds AWS cloud services (Glue, Redshift, Step Functions, IAM, CloudWatch, CloudFormation, Lambda, Secrets Manager, SageMaker).
• Expert in building Spark data processing applications.
• Builds dashboards and visualizations using Power BI or similar platforms.
• Automates recurring data analysis and reporting workflows using Python, SQL, and other tools.
• Partners with business, compliance, analytics, and technology teams to meet data needs and communicate technical considerations.
• Translates findings into clear insights for both technical and non-technical audiences.
• Assesses data quality and supports production deployment with established engineering practices.
• Mentors data professionals and contributes to engineering standards and reusable practices.
• Participates in special projects and other duties as assigned.

Conocimientos

ETL design

Data pipelines

SQL

Python

Power BI

AWS

Spark

Data visualization

Data quality

Stakeholder collaboration

Educación

Undergraduate degree

Herramientas

AWS Glue

Amazon Redshift

SageMaker

CloudWatch

Descripción del empleo

Vanguard Group is seeking a senior data engineer to design, develop, and optimize ETL processes and data pipelines within a hybrid role in Malvern, PA. The position focuses on building scalable data infrastructure, integrating diverse data sources, and ensuring data quality for analytics and regulatory reporting.

You will leverage AWS services (Glue, Redshift, Lambda, IAM, CloudWatch) and Spark for large-scale processing, while delivering dashboards and insights with Power BI.