Business Intelligence Analyst

Randstad is currently working with a large Government department to find a Business Intelligence Analyst for a 2 Year contract. This role is based in Brisbane CBD with WFH flexibility. Key Duties: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
Liaise with business stakeholders to establish and maintain a healthy working relationship
Develop data warehouse documentation including the maintenance of a metadata repository.The ideal candidate for this role will possess:Demonstrated experience in Microsoft SQL Server Programming (SS2012, SS2014, SS2016)
Demonstrated experience in Microsoft SQL Server Integration Services Extract, Transform and Load.
Demonstrated experience in Microsoft SQL Server Analysis Services - Tabular and Multidimensional
Demonstrated experience in Microsoft SQL Reporting Services
Strong skills in Business Intelligence dashboard development (preferably Microsoft Power BI)
A good understanding of database optimisation concepts for tuning data access queries
An overall knowledge of end-to end data warehousing architecture, from tools to middleware to data quality
Ability to analyse data sources, perform data modelling and data cleansing
General systems and application development knowledge (strong skills preferable, but working knowledge mandatory)
Good problem solving and critical thinking skills
Strong oral and written communication skillsIf interested please hit "APPLY" or email your CV to sian.asnicar@randstad.com.auAt Randstad, we are passionate about providing equal employment opportunities and embracing diversity to the benefit of all. We actively encourage applications from any background.