Data Analyst, Specialist

Vanguard; Malvern (Chester County); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Vanguard in Malvern is seeking a Data Analyst, Specialist to leverage data-driven insights for strategic decisions and improved operations. You will structure complex requests into analytical projects and extract large datasets from multiple sources.

The role develops automated reporting and decision-support tools, evaluates AI-enabled capabilities, and mentors junior analysts to expand team knowledge. A strong collaboration culture and hybrid work model support growth.

Qualifications

• Minimum 5 years of relevant work experience, with at least 3 years in advanced data analysis, statistical modeling or business intelligence.
• Bachelor’s degree (B.E./B.Tech) in Computer Science, IT, or a Bachelor’s in Statistics/Mathematics.
• Strong proficiency in SQL for querying, data extraction and performance optimization.
• Expertise in Python or R for data manipulation, automation and advanced analytics.
• Hands-on experience with data visualization tools such as Tableau, Power BI, or similar platforms to create interactive dashboards and reporting solutions.

Responsibilities

• Engages with internal partners to understand business strategy, questions and goals. Brings structure to business requests, translates requirements into an analytical project approach, and leads projects through completion. Delegates tasks and provides tactical and strategic guidance to peers.
• Acquires, integrates, and curates structured and unstructured data from diverse sources. Ensures data quality, accuracy, reasonableness, and fitness for use while helping establish scalable data assets that support advanced analytics, automation, and AI-enabled solutions.
• Performs analyses of historical data to surface trends and insights using advanced analytical methods. Evaluates and applies emerging analytical techniques, including AI-assisted methods where appropriate, and validates approaches used by other analysts.
• Develops and delivers compelling visualizations, presentations, and decision-support tools that translate complex analyses into clear, actionable recommendations. Uses storytelling techniques to help business partners understand insights, tradeoffs, and potential actions.
• Develops, owns and manages recurring analytic or reporting processes.
• Mentors, coaches, trains, and develops junior data analysts. Proactively expands knowledge of business and analytics and shares with team members. Shares and documents best practices.
• Contributes to strategic initiatives and innovation efforts. Identifies and pilots new analytical, automation, and AI capabilities that advance team objectives and enhance organizational effectiveness.
• Participates in special projects and performs other duties as assigned.

Skills

SQL

Python or R

Data visualization

Education

Bachelor's degree in CS/IT or Statistics/Math

Tools

Tableau

Power BI

Job description

Analyzes data, assesses trends and develops actionable insights and recommendations in support of business objectives. Trains and develops junior analysts.

Role Summary

The Data Analyst, Specialist is responsible for leveraging data-driven insights to support strategic business decisions and improve operational efficiency. This role involves structuring complex business requests into well-defined analytical projects, extracting and analyzing large datasets from multiple sources, and developing automated reporting and decision-support solutions to enhance data accessibility and business outcomes. The role will also evaluate and support emerging analytics, automation, and AI-enabled capabilities that help drive innovation and improve decision-making across the organization.

Core Responsibilities

• Engages with internal partners to understand business strategy, questions and goals. Brings structure to business requests, translates requirements into an analytical project approach, and leads projects through completion. Delegates tasks and provides tactical and strategic guidance to peers.
• Acquires, integrates, and curates structured and unstructured data from diverse sources. Ensures data quality, accuracy, reasonableness, and fitness for use while helping establish scalable data assets that support advanced analytics, automation, and AI-enabled solutions.
• Performs analyses of historical data to surface trends and insights using advanced analytical methods. Evaluates and applies emerging analytical techniques, including AI-assisted methods where appropriate, and validates approaches used by other analysts.
• Develops and delivers compelling visualizations, presentations, and decision-support tools that translate complex analyses into clear, actionable recommendations. Uses storytelling techniques to help business partners understand insights, tradeoffs, and potential actions.
• Develops, owns and manages recurring analytic or reporting processes.
• Mentors, coaches, trains, and develops junior data analysts. Proactively expands knowledge of business and analytics and shares with team members. Shares and documents best practices.
• Contributes to strategic initiatives and innovation efforts. Identifies and pilots new analytical, automation, and AI capabilities that advance team objectives and enhance organizational effectiveness.
• Participates in special projects and performs other duties as assigned.

Qualifications And Skills

• Minimum 5 years of relevant work experience, with at least 3 years in advanced data analysis, statistical modeling or business intelligence.
• Bachelor’s degree (B.E./B.Tech) in Computer Science, IT, or a Bachelor’s in Statistics/Mathematics.
• Strong proficiency in SQL for querying, data extraction and performance optimization.
• Expertise in Python or R for data manipulation, automation and advanced analytics.
• Hands-on experience with data visualization tools such as Tableau, Power BI, or similar platforms to create interactive dashboards and reporting solutions.

Preferred Qualifications

• Experience with AI-enabled analytics, generative AI applications, AI agent development, Microsoft Fabric, Amazon Bedrock, or other emerging analytics technologies is a plus.

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.