As the Traffic Coordinator within the Multichannel Traffic Team, you will be ensuring all commercial inventory is scheduled correctly and ready for telecast as per requirements agreed between the National Sales Team, Clients & Agencies and in line with industry legal requirements (Free TV Commercial Television Industry Code of Practice) as well as National Traffic policies.

KEY RESPONSIBILTIES

• Accurately produce multiple daily commercial transmission schedules across our multi channels as per our schedule production deadlines
• Ensure all schedules and material application adheres to the requirements of the Television Industry Code of Practice and any further directions from ClearAds
• Ensure all sponsorship spots are scheduled as instructed by the Sponsorship team and any exclusivity clashes are reported to the Sponsorship team asap and prior to finalisation of logs
• Schedule sport as instructed by the Sports sponsorship team
• Assist Network Sales with late bookings and produce amendments due to these late changes
• Complete the previous days reconciliation (Debrief) resolving any discrepancies between the scheduled log and the as run log

We are seeking an Account Executive to join our fast-paced, high performing and energetic Sales team! We are looking for someone to work alongside our talented Sales Executives, to lead our campaign coordination across our Nine TV and online assets.

If you are a creative and ambitious individual and are passionate to work with clients across national brands, then we'd love to hear from you!

Day to day you will:

• Build strong relationships with internal and external stakeholders
• Run campaign optimisation reviews for clients
• Manage the reporting, campaign updates & tracking for clients
• Identify new opportunities for upselling and building new business
• Other ad-hoc administrative tasks as required 

PRIMARY DETAIL

THE ROLE

The Lead Data Engineer will be working with the relevant project team to lead the development and optimisation of data and analytics architecture, as well as optimising data flow and collection to deliver integrated and quality business information and reporting solutions. 

Reporting to the Head - Data Solutions, key responsibilities for this role include:

• Develop, test, and maintain data and analytics architecture, including databases and large-scale processing systems, for optimal extraction, transformation and upload of data from multiple sources and different technologies. 

• Work with the stakeholders to support their data infrastructure requirements and assist with resolving technical issues.  

• Provide Technical leadership of the implementation of data and/or integration solutions for complex enterprise systems within complex multistakeholder and formalised project delivery environments.

• Deploy models into production using CI/CD pipelines.  

• Reverse and forward engineer data assets.  

• Build data acquisition, ingestion pipeline, and data lake capability. 

• Recommend improvements to data reliability, efficiency, and quality, and provide high quality data assets for enterprise use. 

• Identify, design, and implement process improvement to automate processes, optimise data delivery, and achieve infrastructure efficiency and scalability.  

• Collate, process, transform, and model raw data from multiple sources, and utilise different data sourcing, integration, and modelling techniques.  

• Pilot, demonstrate and evaluate useability of new technologies and systems, 

• Design and update user guides, technical specifications and Process flow documents for all applications and tools.  

• Creation and maintenance of artefacts relating to data models (e.g. DDLs, mapping of data, DMLs, Data Dictionaries, Change Registers etc.) 

• Assisting in the development and continuous improvement of data modelling and principles, processes, and standards 

• Assisting in the implementation of data asset standards, and in the implementation of related data asset governance processes 

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.

• Advanced Knowledge and experience in Snowflake. 

• Highly developed skills to write, test and validate data transformation and ETL routines within DBT, Apache Airflow, Python, Alteryx.

• Data Vault 2 data model implementation experience.

• Dimensional data model implementation experience.

• Demonstrated knowledge of database tools and SQL skills for navigating and troubleshooting these data processes in these platforms. 

• Experience with database, data pipeline and workflow management tools: Snowflake, JIRA, Wiki, DBT Airflow, Python etc. 

• Experience in pipeline scalability, through services such as Kubernetes.

• Experience working in a collaborative environment.

• Experience with database, data pipeline and workflow management tools: Snowflake, JIRA, Wiki, DBT Airflow, etc. 

• Experience in providing 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 deployment support in the context of a mature IT service delivery organisation supporting both cloud and hybrid on premises application configurations.

• Experience with DBT.

• 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.

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:

Diversity and Inclusion

PRIMARY DETAIL

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:

Diversity and Inclusion