bi datawarehousing analyst developer in brisbane cbd

posted
job type
contract
salary
AU$ 70 per hour
apply now

job details

posted
location
brisbane cbd, queensland
job category
IT & ICT
job type
contract
working hours
Full-Time
salary
AU$ 70 per hour
experience
6 years
reference number
90M0347265_1534902509
phone
00 00
apply now

job description

Our client is seeking to engage a Senior Business Intelligence Analyst Programmer to join the Business Intelligence team within Information Technology, to work on a variety of projects within BI.

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.

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

The key responsibilities 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

If you are interested, please apply now or email taryn.botes@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

PowerBI, SSIS, SSRS, SSAS

qualification

IT Degree

responsibilities

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.

educational requirements

Bachelor Degree