Overview
Randstad is currently working with a Queensland Government Client to find an A06 level Senior BI Analyst (SQL Coder) for an initial 6 Months Fixed Term position. This role is based in Kedron with WFH flexibility.
This is a technical role which would require someone proficient in writing SQL code. The client also uses Cognos as their reporting platform and are undergoing a version upgrade so someone who also has Cognos experience would be great but not essential.
Responsibilities
* Provide authoritative, expert, and timely technical advice on business intelligence solutions to inform the ongoing development and maturity of the client\'s enterprise suite of business intelligence tools.
* Undertake ongoing development, maintenance, and enhancement activities to optimise business intelligence systems and processes, including database design, ETL and reporting to ensure high-quality business critical information is readily available to support operational decision making.
* Develop business intelligence tools including visualisations, dashboards, and suites of standard reports to support timely operational decision making.
* Actively participate in the identification and management of risks and issues regarding business intelligence solutions.
* Design, develop and deploy Online Analytical Processing (OLAP) cubes incorporating various data sources to enable consistent and timely access to self-service operational activity reporting.
* Design, develop, test, and release complex data extracts from large datasets using SQL within Microsoft SQL Server and Oracle database technologies.
* Using a high-level knowledge of operations and business, analyse, interpret and transform complex data extracts into meaningful information, and present it in a professional manner to support operational performance reporting and decision making.
* Develop and maintain business intelligence and technical documentation including architectural diagrams, design documents, project quality plans, process mapping, technical specifications, report specifications and data dictionaries.
The ideal candidate will possess
* Demonstrated high level knowledge and experience in the effective operation of a multi-tier business intelligence platform using enterprise level tools, including Oracle and Microsoft SQL Server Relational Database Management Systems (or similar).
* Demonstrated high level ability to develop, coordinate and implement complex data design, collection, interpretation, analysis and practical reporting solutions using business intelligence systems.
* Experience with SQL, T/SQL, PL/SQL, Cognos Transformer and Framework Manager is highly desirable.
* Experience with PowerBI or similar is highly desirable.
* Knowledge and experience in relational and dimensional data modelling methodologies is highly desirable.
* Experience in scripting languages (e.g. Python) is highly desirable.
* Whilst not mandatory, a Bachelor\'s Degree in Information Systems/Computer Science and/or equivalent will be highly regarded.
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.
#J-18808-Ljbffr