Hybrid Role (in office Tues-Wed-Thurs) is based in Malvern, PA (HQ)
Responsibilities- Designs, develops, and optimizes ETL processes, data pipelines, database solutions, and cloud-based data infrastructure to support scalable, reliable data processing and analytical needs.
- Integrates large and complex datasets from multiple sources and troubleshoots data and software issues to maintain data consistency, quality, availability, and integrity.
- Translates business and regulatory requirements into technical designs and develops maintainable, reusable code, queries, and data solutions.
- Expert building AWS cloud supporting services and technologies (Eg: Glue, Redshift, Step Functions, Amazon Q Foundational Services like IAM, Cloud Watch, Cloud formation, Lambda, Secrets Manager, Sagemaker).
- Expert in building Spark data processing applications.
- Builds and automates dashboards, reports, and data visualizations using Power BI or similar platforms to make data and insights accessible to business partners.
- Automates recurring data analysis and reporting workflows using Python, SQL, and other programming tools to improve efficiency, reliability, and reduce manual effort.
- Partners with business, compliance, analytics, and technology teams to understand data needs, develop solutions, and communicate technical considerations.
- Collaborates with leadership and business partners to translate data and analytical findings into clear insights for technical and non-technical audiences.
- Assesses data quality, tests solutions for their intended purpose, and supports implementation into production using established engineering and release practices.
- Serves as a subject matter expert across data engineering and analytics, mentoring less-experienced data professionals and contributing to engineering standards and reusable practices.
- Participates in special projects and performs other duties as assigned.
Education & Experience- 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.
- Experience using SQL for data 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.
.
Special Factors- Supports data and reporting capabilities associated with Financial Crimes and regulatory compliance.
Special FactorsSponsorshipVanguard is not offering visa sponsorship for this position.
About Vanguard At Vanguard, we don't just have a mission-we're on a mission.
To work for the long-term financial wellbeing of our clients. To lead through product and services that transform our clients' lives. To learn and develop our skills as individuals and as a team. From Malvern to Melbourne, our mission drives us forward and inspires us to be our best.
How We WorkVanguard has implemented a hybrid working model for the majority of our crew members, designed to capture the benefits of enhanced flexibility while enabling in-person learning, collaboration, and connection. We believe our mission-driven and highly collaborative culture is a critical enabler to support long-term client outcomes and enrich the employee experience.
