Data Engineer, Specialist
Vanguard Open At a glance
Mid-level Data Engineering role at Vanguard. Malvern · full-time · no salary stated · we estimate $112,439–$160,000 across the United States.
Vanguard has not published a salary for this role. The figure below is our estimate, not theirs.
dataroles summary, based on the employer's posting.
What you'll do
- Build and tune ETL workflows, data pipelines, databases and cloud infrastructure for reliable analytics and data processing
- Combine complex data from multiple sources, then investigate issues that affect its quality, consistency or availability
- Turn business and regulatory needs into reusable code and technical solutions, and automate reporting with Python and SQL
- Create Power BI dashboards and visualizations, and explain findings to business partners and technical teams
- Test data solutions before production, advise on engineering practices and mentor less-experienced data professionals
What you bring
- At least eight years in data engineering, programming, database work, data management or another related discipline
- An undergraduate degree, or an equivalent mix of education, training and relevant experience
- Experience building ETL and multi-source data pipelines, querying and checking data with SQL, and automating work with Python or another language
- Experience creating dashboards with Power BI or a comparable platform and translating business needs into technical solutions
Who this fits
This mid-level role suits someone with substantial data engineering experience who can work across technical and business teams and mentor less-experienced colleagues. The position is hybrid, with office attendance Tuesday through Thursday in Malvern, Pennsylvania. It supports Financial Crimes and regulatory compliance reporting, and visa sponsorship is unavailable.
From the employer
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 Factors
Sponsorship
Vanguard 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 Work
Vanguard 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.
Data Engineering work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Engineering
Find me workBy the team behind dataroles.