As our Data Modeler, you will be reporting into the Head of Data Platforms 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 Platforms team is a full stack and includes Product Owners, Scrum Masters, Data Engineers, Tech Leads, and Architects.
About Vanguard
Vanguard Australia has been helping investors achieve their long-term financial goals for over 20 years. Serving institutional and individual clients, and financial advisers, we offer investment solutions that are low-cost, diversified and robust through time.
With more than AUD $11 trillion in assets under management Vanguard is one of the world’s largest global investment management companies. In Australia we partner with institutional clients, financial advisers and individual investors to offer low-cost investment solutions. Our comprehensive range of managed funds, exchange traded funds (ETFs) and tailored investment solutions are built to support long-term investment success for our clients.
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 queries and other test artefacts to validate data is appropriately flowing through data pipelines in line with business requirements.
- Help the Data Team and our business treat data as a strategic asset, supporting us to have AI-ready datasets.
- Deliver training and knowledge share sessions to the Data Engineering team covering the designed data models.
- Liaise with our Product Owners, Data Analysts, Data Scientists, Architects, 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.
- Review, build, and run our data pipelines to understand the processing of data in non-production environments.
What We Are Looking For
- Thorough understanding of Business Intelligence, Kimball Methodology, Data Vault 2.0 and other design principles for data modelling.
- Experience working with Data Engineering teams to POC models and design ideas before formal engineering engagement.
- Excellent SQL skills for data exploration.
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.
- Experience using Erwin or similar data modelling tools in an enterprise environment.
- Strong written and oral communication skills and presentation skills with the ability to translate business needs to system and software/data requirements.
- Strong analysis and analytical skills with attention to detail within complex systems and datasets, particularly on relationships between them.
- Experience working in Data & Analytics teams with Data Engineers, Analysts, Scientists on on-premises or cloud-based environments.
- 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 Lakehouses, Data Warehouses and Data Lakes.
- A self-starter who’s comfortable with ambiguity and demonstrable learning agility.
- Experience with Data Visualization tools (Tableau is preferred).
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.
