senior bi/data warehousing developer/analyst in Brisbane CBD

posted
contact
kayla lombard, randstad
job type
temporary
salary
AU$ 90.00 - AU$ 100.00 per hour
apply now

job details

posted
location
brisbane cbd, queensland
specialism
IT & ICT
job type
temporary
working hours
Full-Time
salary
AU$ 90.00 - AU$ 100.00 per hour
reference number
90M0379155_1552459014
contact
kayla lombard, randstad
apply now
Apply with

job description

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

Responsibilities:

  • Design and develop Extract, Transform and Load (ETL) procedures, data transformation and data management processes using SQL Server Integration Services (SSIS).
  • Design and develop SQL Server Analysis Services (SSAS) cubes.
  • Design and develop SQL Server Reporting Services (SSRS) reports on both dataware house 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 System Integration Testing (SIT) and User Acceptance Testing (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.
  • Perform routine data warehousing/business reporting tasks
  • Actively participating in team process improvement activities
  • Actively participating applications supported by team and participating in roster as and when required.

Key Experience and Essential skills

  • Demonstrated experience in building data warehousing and business intelligence solutions.
  • Experience of working in the Microsoft Business Intelligence (BI) space.
  • Demonstrated experience in Microsoft SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Multidimensional Expressions (MDX) and SQL Server Reporting Services (SSRS).
  • Demonstrated experience in Microsoft SQL Server T-SQL query.
  • Demonstrated experience in SQL 2012, SQL 2014 and SQL 2016.
  • Demonstrated experience in MS Visual Studio for the creation of SQL Server Integration Services (SSIS) packages, SQL Server Analysis Services (SSAS) cubes and SQL Server Reporting Services (SSRS) reports.
  • Demonstrated experience in Microsoft Power BI.
  • Demonstrated experience in Master Data Services (MDS) and Data Quality Services (DQS).
  • Demonstrated experience in Kimball dimensional modelling.
  • Demonstrated experience in data analysis, data modelling, data integration, data warehousing and database design.

APPLY NOW or contact Kayla at kayla.lombard@randstad.com.au for more information on the role.

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

SQL, SSAS, SSRS, SSIS, Business Intelligence, MDS, Microsoft, PowerBI, T-SQL, Data Analyst

qualification

Grade 12/Secondary/ High School

educational requirements

Secondary School/High School