Lead Data Modeller
Wallumattagal Campus, North Ryde, Australia
Macquarie University
Macquarie University is a place of pioneering minds, breaking free of conventions. Discover our story as one of the global leaders in tertiary education.PRIMARY DETAIL
• HEW Level 9, $138,679 base salary plus 17% superannuation and annualleave loading
• Full time, fixed-term contract ending 31 December 2026
• Hybrid working arrangement
About the role
The Lead Data Modeller will be working with the relevant project team to lead the development and implementation of conceptual, logical, and physical data models to integrate source data into the enterprise data warehouse and provide data modelling expertise and leadership.
Our Student360 Program is seeking a Lead Data Modeller with a keen focus to design, develop, implement, scale, maintain solutions and large-scale processing systems. This includes building data pipelines, logging and monitoring. You will collaborate closely with stakeholders to address data infrastructure requirements and tackle technical challenges.
This position will play an important role in supporting the implementation of a new, consolidated, secure student CRM that will allow effective connection to successfully support students throughout their journey. The Student360 Program will deliver a student CRM (Salesforce) that will realise our ambitions for end-to-end student engagement and service delivery.
This role will be based at Macquarie University Wallumattagal Campus, North Ryde, and the fixed term contract ends 31 December 2026.
About You
You will be a self-starting individual with excellent work organisation, time management skills and ability to work under pressure. You will have strong analytical skills, an eye for detail and be able to effectively communicate with clients and stakeholders at all levels.
You will enjoy working in a dynamic environment, applying a methodical and consultative approach in your work, and be motivated to deliver work outputs that are of a consistently high quality.
How to apply
Please apply online and attach your resume and a separate cover letter that outlines how you meet the selection criteria below:
Tertiary qualifications in Data and Analytics, Data Science, Business or Statistics or equivalent knowledge, skills, and experience.
Data Vault 2 data modelling and implementation experience.
Dimensional data modelling and implementation experience.
Proficiency and experience with Erwin Data Modeller or equivalent modelling tool.
Salesforce data modelling experience is highly regarded.
Demonstrated knowledge of database tools (Snowflake recommended) and SQL skills for navigating and troubleshooting these data processes in these platforms.
Experience with data pipeline and workflow management tools: Snowflake, JIRA, Wiki, DBT Airflow, etc
Ability to rapidly understand business requirements and map them into logical and physical data models within relevant modelling tools.
Experience working in a collaborative environment.
Technical leadership of the implementation of data and/or integration solutions for complex enterprise systems within complex multistakeholder and formalised project delivery environments
Experience with DBT will be highly regarded.
Providing specialist data modelling support in the context of a mature IT service delivery organisation supporting both cloud and hybrid on premises application configurations.
Highly developed analytical and problem-solving skills including the ability to analyse and interpret requirements and information from numerous sources and the ability to translate business requirements into technical solutions.
Time management and ability to balance competing demands to effectively prioritise tasks and achieve deadlines, on individual basis as well as for a team.
Excellent verbal and written communication skills with the ability to build and maintain relationships with a wide range of stakeholders including the ability to influence senior management and executives.
Presenting to a wide range of audiences with varying levels of data analytics capability.
Working knowledge of the Higher Education or Education Data Model is desired.
Proven experience in data modelling for enterprise-scale data warehouses and analytics environments is essential.
Strong understanding of data governance, data architecture, and best practices for data integration.
*This position requires a criminal record check and working rights in Australia.
Applications Close: 14 March at 11:59pm
Please note we reserve the right to progress or decline an application as well as close the advertisement prior to the stated closing date.
About Us
Macquarie is a university engaged with the real and often complex problems and opportunities that define our lives. Celebrating its 60th year in 2024, it was established as a bold experiment in higher education and designed to break from educational traditions to work in tandem with industry. Institutionally we strive for the extraordinary by challenging convention and embracing different views. Our pioneering culture has encouraged and inspired students, staff and collaborators to break free from conventional thinking, and to actively shape the complex issues that define the future of humanity.
Why work at Macquarie
We rank amongst the top employers in the Australian Workplace Employers Index, having recently earned a five-star rating in the QS World Rankings with the highest rating for employability.
Our prime location, we are walking distance from Macquarie University Metro Station and Macquarie Shopping Centre. Not only are we close, take a look at our benefits on offer:
17% Superannuation
Subsidised onsite parking options
Flexible working options
Training and professional development
Onsite childcare facilities
Discounted health insurance (Medibank)
Onsite vacation care
Employee Assistance Program
Subsidised membership at the Sport & Aquatic Centre
Onsite GP, imaging & physio clinics
If you're already part of the Macquarie Group (MQ University, U@MQ, MQ Health, MGSM), you'll need to apply through your employee Workday account. To apply for this job: Login to Workday and go to the Careers App > Find Jobs.
Applications Close:
14/03/2025 11:59 PMDiversity and Inclusion
Innovation and ingenuity thrive at Macquarie University when diversity, equity and inclusion take centre stage. At the University, we embrace a culture where diversity of background, experience and perspective are fundamental to our success.
We do not discriminate on gender identity, age, culture, disability, sexuality, Indigeneity, family and caring responsibilities or religion. See our journey towards leadership in Equity, Diversity and Inclusion in Higher Education.
Flexible Work
At Macquarie, we believe by providing flexibility in when, where and how work is done, we can support our staff to manage their personal commitments, while optimising their work performance and contributions to the University. See how we lead in flexible work to enable an outcome focused and inclusive workplace. To learn more about our culture and hiring process, explore our Candidate Resource Hub.
Tags: Airflow Architecture Data Analytics Data governance Data pipelines Data warehouse dbt Jira Pipelines Salesforce Snowflake SQL Statistics
Perks/benefits: Career development Equity / stock options Flex hours Flex vacation Health care Insurance
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.