Skip to main contentA logo with &quat;the muse&quat; in dark blue text.

Data Modeler

AT Vanguard
Vanguard

Data Modeler

Melbourne, Australia

About Vanguard

More than 45 years ago, John C. Bogle had a vision to start an investment company that did things differently. A company with no external shareholders. Where all the profits were invested back into the business and used to lower costs. Evidently, it was as bold as it was brilliant. To this day, Vanguard Group still has no external shareholders. That means no share prices to protect, and no profits to generate for outside owners.

Today, Vanguard is one of the world's largest investment management companies, serving more than 50 million investors worldwide. For more than 25 years Vanguard Australia has been supporting individual investors, financial advisers, and superannuation members to achieve their long-term financial goals.

Want more jobs like this?

Get jobs in Melbourne, Australia delivered to your inbox every week.

By signing up, you agree to our Terms of Service & Privacy Policy.


Our Team & Opportunity

Part of our growing Technology division, the CDAO team responsible for transforming how our crew use data so that clients and investors can thrive. Our mission is to accelerate Vanguard's growth, clients, crew, and client experience by using data to inform and elevate every decision. We power information through data - improving outcomes, guiding strategies, and changing behaviour.

The Data Engineering team establishes technical excellence by knowing what their critical data is, where it is, and how it's being used. This supports Vanguard's reporting suite, global compliance, data quality efforts, and data security efforts .

As our Data Modeler , you will be reporting into the Data Engineering Manager and will lead the development and rollout of physical, logical, and conceptual Entity Relationship Diagrams with a clear focus on documenting our current landscape of data sources as well as our to-be Data Lakehouse infrastructure. You'll play a key role in defining the standards for our new data store and guiding the Engineering team to build a modern solution that enables self-serve data.

Our Data Engineering is a ful l stack team includes P roduct O wner s , S crum M aster s , Data Engineers, Tech Leads , and Architects .

What you will do

  • Explore our data sources to understand, model, and document the data we take from them.


  • Build Entity Relationship Diagrams to show the physical, logical, and conceptual makeup of our holistic data sources and our target databases.


  • Work closely with people across all aspects of Vanguard's business to understand data coming into our team and how data will be used once provided by our team.


  • Develop quer ies and other test artefacts to validate data is appropriately flowing through data pipelines in line with business requirements.


  • Deliver training and knowledge share sessions to the Data Engineering team covering the designed data models.


  • Liaise with our Product Owner, Data Analyst, Data Scientists, Product Architect, Data Engineers and engage business stakeholders directly to validate assumptions and design decisions .


  • Participates in design, code, and test inspections throughout life cycle to identify issues and improvements to our data models.

What We Are Looking For

  • Thorough understanding of Business I ntelligence , Kimball Methodology, Data Vault 2.0 and other design principles for data modelling.


  • Excellent SQL skills for data exploration.


  • Strong written and oral communication skills and presentation skills with the a bility to translate business needs to system and software/data requirements.


  • S trong analysis and analytical skills with attention to detail within complex systems and datasets , particularly on relationships between them.


  • Experience working in Data & Analytics team s with Data Engineer s, Analyst s , Scientists on on-premises or cloud-based environment s.


  • Experience with or knowledge of working with SaaS products, CRM and ERP systems , and generally working with data in different formats, such as flat files, APIs, JSON, and RDBMS .


  • Good understanding of lean and Agile principles, including Shift left, DevOps, CloudOps , DataOps , CI/CD & with a SRE mindset .


  • Experience working in complex Data environments, including with ETL processes/data integration frameworks , such as with Data Lakehouse s , Data Warehouse s and Data L ake s .


  • A s elf- s tarter who's c omfortable with a mbiguity and d emonstrable l earning a gility .


  • Experience with Data Visualization tools (Tableau is p referred).

Specialisations that will make an impact:

  • Knowledge of the financial services industry , particularly Investment Management .


  • Experience in setting up, operating , and monitoring a technical platform and its associated technologies.


  • Capability to question the status quo, challenge yourself and the business on the value that will be delivered to our customers with clear justification for change.


  • Lead issue resolution, identifying root cause and implementing solutions.

Inclusion Statement

Vanguard's continued commitment to diversity and inclusion is firmly rooted in our culture. Every decision we make to best serve our clients, crew (internally employees are referred to as crew), and communities is guided by one simple statement: "Do the right thing."

We believe that a critical aspect of doing the right thing requires building diverse, inclusive, and highly effective teams of individuals who are as unique as the clients they serve. We empower our crew to contribute their distinct strengths to achieving Vanguard's core purpose through our values.

When all crew members feel valued and included, our ability to collaborate and innovate is amplified, and we are united in delivering on Vanguard's core purpose.

Our core purpose: To take a stand for all investors, to treat them fairly, and to give them the best chance for investment success.

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.

Client-provided location(s): Melbourne VIC, Australia
Job ID: Vanguard-166420
Employment Type: Full Time

Perks and Benefits

  • Health and Wellness

    • FSA
    • HSA
    • Health Reimbursement Account
    • Fitness Subsidies
    • On-Site Gym
    • HSA With Employer Contribution
    • Health Insurance
    • Dental Insurance
    • Vision Insurance
    • Life Insurance
    • Short-Term Disability
    • Long-Term Disability
    • Mental Health Benefits
    • Virtual Fitness Classes
    • Pet Insurance
  • Parental Benefits

    • Non-Birth Parent or Paternity Leave
    • Birth Parent or Maternity Leave
    • Fertility Benefits
    • Adoption Assistance Program
    • Family Support Resources
    • Adoption Leave
  • Work Flexibility

    • Flexible Work Hours
    • Hybrid Work Opportunities
  • Office Life and Perks

    • Company Outings
    • Commuter Benefits Program
    • Casual Dress
    • Happy Hours
    • Snacks
    • Some Meals Provided
    • On-Site Cafeteria
  • Vacation and Time Off

    • Personal/Sick Days
    • Paid Holidays
    • Paid Vacation
    • Volunteer Time Off
    • Leave of Absence
  • Financial and Retirement

    • Relocation Assistance
    • Performance Bonus
    • 401(K) With Company Matching
    • 401(K)
    • Financial Counseling
    • Profit Sharing
  • Professional Development

    • Promote From Within
    • Mentor Program
    • Shadowing Opportunities
    • Access to Online Courses
    • Tuition Reimbursement
    • Internship Program
    • Lunch and Learns
    • Leadership Training Program
  • Diversity and Inclusion

    • Diversity, Equity, and Inclusion Program
    • Employee Resource Groups (ERG)

Company Videos

Hear directly from employees about what it is like to work at Vanguard.