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.
Never miss an opportunity! Create an alert based on the job you applied for.
