business intelligence analyst in australia

job type
apply now

job details

job category
job type
working hours
reference number
apply now

job description

The Role:

This position involves working with a number of stakeholders including senior executives to establish a Business Intelligence (BI) reporting platform primarily using Microsoft Power BI.


  • Liaise with business stakeholders to establish and maintain a healthy working relationship
  • Analyse existing databases that support small business systems, define information requirements, design data warehouse components and develop data models
  • Create databases, tables and views in MS SQL Server
  • Construct Extract, Transform, and Load (ETL) packages using MS SQL Server Integration Services (SSIS)
  • Create multi-dimensional cubes using MS SQL Server Analysis Services (SSIS)
  • Create reports using MS SQL Reporting Services (SSRS)
  • Create interactive dashboards using Power BI and/or other products
  • Undertake unit testing of all ETL related processes
  • Develop data warehouse documentation including the maintenance of a metadata repository

Necessary Criteria:

  • Demonstrate experience in Microsoft SQL Server Programming (SS2012, SS2014, SS2016)
  • Demonstrate experience in Microsoft SQL Server Integration Services Extract, Transform and Load.
  • Demonstrate experience in Microsoft SQL Server Analysis Services – Tabular and Multidimensional
  • Demonstrate experience in Microsoft SQL Reporting Services
  • Have strong skills in Business Intelligence dashboard development (preferably Microsoft Power BI)
  • Have a good understanding of database optimisation concepts for tuning data access queries
  • Have an overall knowledge of end-to end data warehousing architecture, from tools to middleware to data quality
  • Be able to analyse data sources, perform data modelling and data cleansing
  • Have general systems and application development knowledge (strong skills preferable, but working knowledge mandatory)
  • Have good problem solving and critical thinking skills
  • Have strong oral and written communication skills

Interested? Apply Now!

Please click ‘Apply Now’ or send your CV to

At Randstad, we are passionate about providing equal employment opportunities and embracing diversity to the benefit of all. We actively encourage applications from any background.


Relevant Skills


Relevant Qualifications

educational requirements

Bachelor Degree