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