Junior Investment Data Analyst
Job Description
Vanguard is hiring a Junior Investment Data Analyst to help deliver reliable, high-quality investment data through disciplined reporting, controls, and continuous improvement. Based in Scottsdale, AZ with a hybrid working model, this role supports daily and periodic data production for assigned domains, while investigating exceptions and strengthening data integrity across systems and downstream processes.
What you’ll do
- Produce timely and accurate gold-copy investment data for assigned data domains, prioritizing operational efficiency and output quality.
- Complete complex tasks under tight deadlines by managing competing priorities and analyzing multiple inputs to meet operational objectives.
- Research and analyze data exceptions with internal and external data suppliers, partners, and stakeholders.
- Maintain system and business controls to support data integrity and ensure approved distribution of data across the enterprise.
- Execute and analyze daily and periodical reporting and quality control queries accurately and on schedule.
- Provide advanced troubleshooting and problem resolution by identifying issues and trends in reports or source systems.
- Ensure data feed services levels are met, including accurate loading into the appropriate systems.
- Escalate issues to the appropriate support team to ensure resolution is handled efficiently and quickly.
- Deliver ongoing reporting as needed to support regulatory bodies and internal partners.
- Identify improvement opportunities from process knowledge, recommend solutions, and help implement changes to increase efficiency and quality.
- Perform root cause analysis of data errors and recommend short-term and long-term solutions, elevating issues when appropriate.
- Build and use a strong network within the Data Management community, sharing knowledge and experience.
- Collaborate across the Fund Ecosystem, Investment Management Group, and the enterprise to improve and sustain global operational processes.
- Develop a consistent understanding of assigned funds and securities, including details that drive global operational processes and downstream impacts.
- Leverage product and operational knowledge to support the production of gold-copy data.
- Support projects through acceptance and regression testing, system monitoring, and other project-related activities as needed.
- Monitor data quality by creating test cases and monitoring reports that validate accuracy and completeness.
- Create, maintain, and improve Data Management procedures and workflows.
- Identify and escalate potential control gaps in a timely manner to support resolution and reduce impact.
- Adhere to applicable control standards to support compliance.
- Participate in special projects and perform other duties as assigned.
What you bring
- 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, research, problem solving, and time management skills.
- Strong verbal and written communication skills.
- Ability to work effectively in a team environment.
- Strong judgment and ability to analyze issues quickly.
- Demonstrated problem identification, analysis, and resolution skills.
- Advanced knowledge and skills using current versions of the Microsoft Office Suite.
- Working knowledge of VBA and SQL is a significant plus.
- Strong work ethic and ability to deliver critical internal client outcomes in a fast-paced environment.
- Flexibility and ability to prioritize work effectively.
Tools and technologies
- Microsoft Office Suite
- VBA
- SQL
Location and work model
- Scottsdale, AZ (hybrid)
- Vanguard uses a hybrid working model for the majority of crew members to balance flexibility with in-person learning, collaboration, and connection.
Visa sponsorship: Vanguard is not offering visa sponsorship for this position.