Junior Investment Data Analyst

The Vanguard Group•Malvern, PA

4d•Hybrid

About The Position

Join a team that sits at the heart of Vanguard’s investment data ecosystem. We support both reference data and the book‑of‑record , ensuring our internal and external consumers receive accurate, high‑quality investment and accounting data. Our work spans daily operational responsibilities—where we validate and deliver critical data—as well as meaningful project work that shapes the future of how data flows across the enterprise. What makes this team exciting is the pace of innovation. We’re actively modernizing our processes and adopting new technology solutions, giving crew the opportunity to work with emerging tools, automation capabilities, and evolving data platforms. This keeps the work dynamic, future‑focused, and aligned to the latest trends in data and technology. The role is ideal for someone who enjoys variety: you’ll balance operational excellence with strategic project involvement, all while building strong technical skills. Team members regularly use or grow expertise in SQL, Python, Power Apps, and Power BI , giving you hands‑on experience with tools that enhance workflow automation, analytics, and data quality. This is a great opportunity for someone who wants to contribute immediately, learn continuously, and help influence how Vanguard manages and delivers critical investment data.

Requirements

Undergraduate degree (preferably in accounting, finance, economics, or related field)
Minimum of three years’ relevant work experience with financial and investments industry experience preferred
Strong analytical ability capabilities, research, problem solving, and time management skills required
Strong verbal and written communication skills.
Ability to work effectively in a team environment
Strong judgment and ability to analyze issues quickly
Strong, demonstrated problem identification, analysis, and resolution skills
Advanced knowledge and skills using current versions of the Microsoft Office Suite.
Strong work ethic and ability to work in a fast-paced environment to provide internal clients with critical deliverables in a timely manner.
Demonstrated flexibility and ability to prioritize work

Nice To Haves

Working knowledge of VBA and SQL is a significant plus
Finance industry exp., data management, fund accounting exp. helpful

Responsibilities

Produces timely and accurate gold-copy investment data per assigned data domain with a focus on operational efficiency and output quality.
Completes complex tasks while working under tight deadlines, managing competing priorities, and analyzing multiple inputs to meet operational objectives.
Researches and analyzes data exceptions with internal/external data suppliers and partners.
Maintains system and business controls to ensure data integrity and approved data distribution to the enterprise.
Executes and analyzes a wide variety of daily and periodical data reporting and quality control queries in a timely and accurate manner.
Provides advanced troubleshooting and problem resolution in identifying issues/trends in reports or source systems.
Ensures data feed services levels are met and accurately loaded into systems.
Escalates issues when needed to the appropriate support team, ensuring that data issues are resolved efficiently and quickly.
Provides ongoing reporting to fulfill the needs of both regulatory bodies and internal partners, as needed.
Recognizes improvement opportunities based on process knowledge and recommends and implements proper solutions to gain efficiencies and ensure quality.
Performs root cause analysis of data errors and provides short-term and long-term solutions for issues, elevating issues when appropriate.
Builds a strong network within the Data Management community and shares knowledge and experience.
Proactively engages and works collaboratively with colleagues across FFS, IMG, and the enterprise to improve and sustain global operational processes.
Develops a strong and consistent knowledge of the funds and securities assigned and understands the details driving the global operational processes and the downstream impacts.
Leverages product and operational knowledge to aid in the production of gold-copy data.
Provides project support by participating in acceptance and regression testing, system monitoring, and other project-related activities as needed.
Monitors and ensures data quality by using existing business knowledge to create test cases and monitoring reports that ensure data accuracy and completeness.
Creates, maintains, and improves Data Management's procedures and workflows.
Identifies and escalates potential control gaps in a timely manner to ensure resolution and to lessen impact.
Adheres to various control standards to ensure compliance.
Participates in special projects and performs other duties as assigned.