Junior Investment Data Analyst

Vanguard•Malvern, PA

17h•Hybrid

About The Position

Join Vanguard's Investment Data Operations team and become the trusted source behind the investment data that fuels critical business and investment decisions. Collaborate with global colleagues, drive modernization efforts, and solve complex problems in an environment that rewards curiosity and critical thinking. If you thrive in solving puzzles, driving continuous improvement, and collaborating across a broad network of partners, this is your opportunity to make a visible impact every single day.

Requirements

Undergraduate degree (preferably in Accounting, Finance, Economics, or related field) and a minimum of three years relevant work experience.
Strong analytical capabilities, research, problem solving, and time management skills
Demonstrated proficiency in SQL, with the ability to query, analyze, and manipulate complex datasets.

Nice To Haves

Financial and investment industry experience strongly preferred
Working knowledge Python, Github and Claude or other AI tools is a significant plus

Responsibilities

Complete complex tasks while working under tight deadlines, managing competing priorities, and analyzing multiple inputs to meet operational objectives.
Research and analyze data exceptions with internal/external data suppliers and partners.
Maintain system and business controls to ensure data integrity and approved data distribution to the enterprise.
Execute and analyze a wide variety of daily and periodical data reporting and quality control queries in a timely and accurate manner.
Provide advanced troubleshooting and problem resolution in identifying issues/trends in reports or source systems.
Provide ongoing reporting to fulfill the needs of both regulatory bodies and internal partners, as needed.
Recognize improvement opportunities based on process knowledge and recommend and implement proper solutions to gain efficiency and ensure quality.
Perform root cause analysis of data errors and provide short-term and long-term solutions for issues, elevating issues when appropriate.
Build a strong network and share knowledge and experience.
Proactively engage and work collaboratively with colleagues across the fund ecosystem and the enterprise to improve and sustain global operational processes.
Develop a strong and consistent knowledge of the funds and securities assigned and understands the details driving the global operational processes and the downstream impacts.
Leverage product and operational knowledge to aid in the production of gold-copy data.
Provide project support by participating in acceptance and regression testing, system monitoring, and other project-related activities as needed.
Monitor and ensures data quality by using existing business knowledge to create test cases and monitoring reports that ensure data accuracy and completeness.
Create, maintain, and improve procedures and workflows.
Identify and escalate potential control gaps in a timely manner to ensure resolution and to lessen impact.