Connecting...

BI analyst

Job Title: BI analyst
Contract Type: Contract
Location: Brisbane CBD, Queensland
Industry:
Salary: Negotiable
Start Date: 22/08/2018
Reference: JO-1808-90711_1534913754
Contact Name: Nicholas Leong
Contact Email: nicholas.leong@davidsonwp.com
Job Published: August 22, 2018 14:55

Job Description

SCOPE
The Senior Business Intelligence Analyst Programmer will be responsible for the design and development of business intelligence and ETL solutions utilising the Microsoft BI Technologies. The Senior Business Intelligence Analyst Programmer will work closely with business users, IT teams, system owners and administrators.

CONTRACT SPECIFICATIONS

The contractor shall have demonstrated knowledge and experience in the Information Technology industry consistent with the services specified.
The successful contractor should be a self-motivated, enthusiastic, and results-oriented person with good interpersonal skills.

Key skills required include:

Essential:

* 6+ years experience of working in the Microsoft Business Intelligence (BI) space
* Demonstrated experience in Microsoft SQL Server SQL Server Integration Services, SQL Server Analysis Services, MDX and SQL Server Reporting Services
* Demonstrated experience in Microsoft SQL Server T-SQL query
* Demonstrated experience in SQL 2016, SQL 2014 and SQL 2012
* Demonstrated experience in MS Visual Studio for the creation of SSIS packages, SSAS cubes and SSRS reports
* Demonstrated experience in Power BI
* Demonstrated experience in Master Data Services
* Demonstrated experience in Kimball dimensional modelling
* Demonstrated experience in data analysis, data modelling, data integration, data warehousing and database design
* Demonstrated experience in building data warehousing and business intelligence solutions
* Demonstrated ability to work independently as well as in a team
* Demonstrated experience in delivering quality solutions
* Demonstrated experience in developing technical and support documentation (including technical specification, support manual, change management, release management)
* Demonstrated ability to converse at ease with people at all levels of business and explain technology in business terms.
* Demonstrated excellent ability in analytical and problem solving skills
* Demonstrated experience working in an Agile development environment

Desirable
* Demonstrated experience in using SSRS with SharePoint
* Demonstrated experience in Data Quality Services
* Demonstrated experience in using Team Foundation Server as a source code repository
* Demonstrated experience in building application to application integration and data migration solutions
* Demonstrated experience in MS Self-Service BI toolsets including Excel using PowerPivot, PowerView

Work required to be performed
The key responsibilities of the contractor will include:


* Design and develop ETL, data transformation and data management processes using SSIS.
* Design and develop SSAS cubes
* Design and develop Power BI reports on both datawarehouse and cubes
* Design and develop SSRS reports on both datawarehouse and cubes
* Data modelling using Kimball data modelling principles
* Design and build application to application integration and data migration solutions
* Work with the business to gather and analyse business and technical requirements
* Coordinate and manage quality assurance processes including unit testing and support for SIT/UAT
* Technical and support documentation (including technical speciation, support manual, change management, release management)
* Full life cycle solution delivery, from conception, prototyping all the way through to go live and making arrangements for ongoing support
* Performing BAU data warehousing/business reporting tasks
* Actively participating in team process improvement activities



To apply, click the link and upload your current resume in Microsoft Word format only (.doc or .docx). If you would like to have a confidential discussion, please contact Nicholas Leong on 07 3023 1069, quoting ref no. JO-1808-90711. Want to know more about Davidson? Visit us at www.davidsonwp.com