PRIMARY DETAIL
Salary Package: From $133,989 to $141,514 (HEW Level 9), plus 17% employer's superannuation and annual leave loading
Appointment Type: Full time, Fixed-term role
Location: Macquarie University, Wallumattagal Campus, North Ryde
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 support the creation of strategic analytical data assets and provide data modelling expertise and leadership.
Reporting to the Head - Data Solutions, key responsibilities for this role include:
Define, develop, and implement the Enterprise Data Model (for assigned PMO Project) across Macquarie University and its entities, including defining, managing, and communicating the Enterprise Data Model roadmap.
Work with key stakeholders to understand business analytical requirements and lead the work to map them into logical and physical data models within relevant modelling tools as per the agreed standards.
Create and maintain artefacts relating to data models (e.g., DDLs, mapping of data, DMLs, Data Dictionaries, Change Registers, etc.)
Implement robust processes to govern the development and maintenance of the data models.
Provide data modelling expertise and leadership to the engineering teams responsible for building the data assets and to the analytical teams using them to deliver insights, as well as proactively driving the resolution of any delivery issues relating to the Enterprise Data Model.
Resolve production issues relating to Data Vault and Dimensional models and related conformed data layers.
Responsible for proactively identifying data quality issues and managing these in collaboration with the BIR Team.
Develop and continuously improve data modelling principles, processes, and standards, ensuring alignment with the broader MQ IT architectural principles, and delivery processes and standards and that documentation is properly managed including the maintenance of data catalogue.
Work with the project and wider BIR team and MQ IT in the development and implementation of data asset standards and governance processes.
Support the Project Team and BIR leadership in defining the overall data strategy.
Build and maintain collaborative relationships with project team, stakeholders, executives and working groups.
Comply with relevant EEO and WHS regulations.
Perform any other duties as required and appropriate for this classification.
About Us
The Vice-President Strategy, Planning and Performance (VPSPP) holds executive responsibility for the development and execution of university strategy, cross-institutional planning, and oversight of whole of University Group performance.
The VPSPP supports the Vice-Chancellor, Executive Group and University Council in ensuring the long-term sustainability and strategic direction of the University and its group subsidiaries.
Specific accountabilities include:
• Whole of institution strategy
• Effective decision making and transformational change
• Planning, performance, continuous improvement, and strategic focus
• Performance metrics and reporting frameworks
• Organisation progress and performance
Business Intelligence and Reporting is responsible for enabling evidence-based decision-making across the University.
There are significant investments being made in developing strategic data assets for the University and its entities, and a critical component of all this work is the definition of the strategic data model (Enterprise Data Model) that describes the data assets required to meet business analytical requirements and this will be used as the basis for all the data engineering work to then build the data assets.
The Lead Data Modeller (Analytics) will lead this work, who will have overall ownership for the definition and development of the strategic Enterprise Data Model as well as oversee all project data modelling activity to ensure alignment with the overall data strategy.
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.
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. Take a look at the staff benefits on offer.
To Apply
To be considered for this position, please apply online and attach your resume and a separate cover letter that outlines how you meet the selection criteria below:
Selection Criteria
Tertiary qualifications in Data and Analytics, Data Science, Business or Statistics or equivalent knowledge, skills, and experience.
Proficiency and experience with Erwin Data Modeller.
Data Vault 2 data modelling and implementation experience.
Dimensional data modelling and implementation experience.
Demonstrated knowledge of database tools (Snowflake recommended) and SQL skills for navigating and troubleshooting these data processes in these platforms.
Knowledge of database, 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.
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.
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.
Experience with DBT will be highly regarded.
Desired: Experience working in an agile squad environment.
Other Specific Requirements: Criminal history check
Role Specific Enquiries: Chitrani Gunasekera, Head - Data Solutions, chitrani.gunasekera@mq.edu.au
General Enquiries: Bill Egarchos, HR Officer, bill.egarchos@mq.edu.au
Application Close Date: Wednesday, 3rd April 2024, 11:59pm
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:
03/04/2024 11:59 PM
Diversity 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.
