Core Responsibilities

Data Exploration & Validation:

• Analyze and assess data sources for analytical readiness and business alignment.
• Acquire and compile structured and unstructured data, verifying its quality, accuracy, and reasonableness.
• Perform analyses of historical data to surface trends and insights using advanced analytical methods.
• Validate analytical techniques employed by other analysts.

Cross Functional Collaboration:

• Partner with cross-functional teams to translate business questions into actionable data solutions.
• Engage with internal partners to understand business strategy, questions, and goals.
• Participate in cross-divisional data projects and resolve operational challenges.

Prototyping & Data Storytelling:

• Build visualizations and proof-of-concepts to demonstrate data value and insights.
• Prepare and deliver visualizations and internal presentations that translate analytic insights into tangible, actionable solutions for business partners to implement.
• Develop, own, and manage recurring analytic or reporting processes.

Data Quality & Governance:

• Identify and resolve data inconsistencies, gaps, and ensure compliance with governance standards.

User Enablement:

• Empower non-technical users to leverage data products effectively through documentation and training.
• Foster a culture of continuous learning and innovation in analytics tools and methods.
• Proactively expand knowledge of business and analytics, share best practices, and document them.
• Serve as a subject matter expert for the team and the analytic organization.

Required Skills & Tools:

Advanced SQL expertise including:

• Multi-table joins (inner, outer, cross, self-joins)
• Subqueries and common table expressions (CTEs)
• Window functions (RANK, ROW_NUMBER, PARTITION BY)
• Aggregations and grouping logic
• Ability to optimize, troubleshoot, and validate SQL logic on large-scale datasets
• Strong experience querying and analyzing data through platforms such as Athena, Dremio, or similar distributed compute engines.
• Data Visualization:
• Ability to source and model data in Tableau or Power BI from scratch
• Build highly functional and intuitive dashboards that reflect UX best practices and visual storytelling principles
• Ability to design layout, structure, hierarchy, and visual selection based on business intent

Python:

• Ability to read and understand Python scripts used for data preparation
• Ability to write Python is a plus, especially for deeper analysis or working closely with engineering teams

Collaboration Tools:

• JIRA, Confluence, Mural/Figma for documentation, refinement, and sprint collaboration
• Collibra for data governance, documentation, and stewardship processes

Soft Skills:

• Strong analytical and problem-solving skills
• Excellent communication and stakeholder management capabilities
• Strong ability to translate technical data concepts to business-friendly narratives

Special Factors
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.