business intelligence analyst in australia

posted
job type
temporary
apply now

job details

posted
location
australia
job category
IT & ICT
job type
temporary
working hours
Full-Time
reference number
90M0369275_1544077238
phone
000
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.

Responsibilities:

  • 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 madeline.reeve@randstad.com.au

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.

skills

Relevant Skills

qualification

Relevant Qualifications

educational requirements

Bachelor Degree