Senior Data Analyst

The Vanguard Group•Malvern, PA

2d•Hybrid

About The Position

BSRG serves as the global owner for enterprise bank relationships across Vanguard’s Fund, Treasury, and corporate organizations. Within BSRG, PPFA helps drive financial value, control costs, and optimize provider performance through fee analytics, invoice and contractual oversight, dashboards, scorecards, and performance-metric tracking and trending. The Senior Data Analyst applies financial and business acumen to evaluate banking-service costs, contractual terms, budgets, forecasts, and performance results. The role identifies trends, variances, risks, efficiencies, and cost-saving opportunities; turns business requests into analytical projects; and leads work through completion. It partners with internal business teams to ensure recommendations account for financial, accounting, procurement, contractual, supplier, and operational impacts. The role compiles and validates structured and unstructured data, performs advanced analysis, and uses tools such as Excel, Power BI, Tableau, and SQL to develop scalable reporting solutions, models, dashboards, and scorecards. It also owns recurring analytical and reporting processes, improves and documents workflows and controls, communicates insights through visualizations and presentations, and mentors junior data analysts.

Requirements

Minimum of five years of related work experience in data analytics, finance, accounting, procurement, supplier management, or a comparable discipline.
Undergraduate degree or an equivalent combination of training and experience.
Strong analytical, problem-solving, project-management, and communication skills.
Ability to translate complex information into business recommendations.
Demonstrated ability to manage analytical work from requirements gathering and research through implementation and recurring process ownership.
Ability to build effective cross-functional relationships and communicate clearly with business partners and senior leaders.

Responsibilities

Evaluate banking-service costs, contractual terms, budgets, forecasts, and performance results to identify trends, variances, risks, efficiencies, and cost-saving opportunities.
Engage internal partners to understand business strategy, questions, and goals.
Structure business requests, translate requirements into analytical project approaches, and lead projects through completion.
Delegate tasks and provide tactical and strategic guidance to peers.
Partner with Corporate Accounting, FP&A, ESM, Accounts Payable, relationship management, and other business teams to account for financial, accounting, procurement, contractual, supplier, and operational impacts.
Acquire and compile structured and unstructured data and verify its quality, accuracy, and reasonableness.
Analyze historical data using advanced analytical methods to surface trends and insights.
Validate analytical techniques used by other analysts.
Use advanced tools, including Excel, Power BI, Tableau, SQL, and similar technologies, to analyze complex data and develop scalable reporting solutions, models, dashboards, and scorecards.
Prepare and deliver visualizations and internal presentations that translate analytical insights into actionable business solutions.
Develop, own, and manage recurring analytical or reporting processes.
Standardize and automate analytical and operational workflows; strengthen controls and transparency; document methodologies; and promote scalable, consistent, repeatable practices.
Mentor, coach, train, and develop junior data analysts.
Expand knowledge of the business and analytics, share it with team members, and document best practices.
Participate in special projects and perform other duties as assigned.