The Business Intelligence Solutions team within Performance Monitoring and Reporting is seeking a Principal Business Solutions Developer who is a multiskilled professionally with proven experience in SQL Server Management Studio and will contribute to the ongoing development, enhancement and maintenance of data warehouse and
reporting products.
This position will develop fit-for-purpose data models to deliver insights and plays a key part in shaping and supporting the department's continued expansion of business intelligence solutions.
About the Department of Education:
Working for the Queensland Department of Education means joining an organisation that values its people and promotes leadership and innovation. Be part of an environment that respects professionalism and diversity, offers training and development opportunities and embraces flexible careers and work-life balance. Find out more about working with us ( ).
About the Role:
The ideal candidate for the role of Principal Business Solutions Developer will be a multiskilled professional with proven experience in SQL Server Management Studio and Visual Studio, who will contribute to the ongoing development, enhancement and maintenance of data warehouse and reporting products. This role will develop fit-for-purpose data models to deliver insights directly into the hands of users. This position plays a key part in shaping and supporting the department's continued expansion of business intelligence solutions.
Experience and Skills:
It would be highly desirable to have the following skills and experience:
* Demonstrated knowledge of data warehouse architecture, data modelling, and ETL design.
* Highly developed analytical skills, particularly in analysing data and transforming into relational tables.
* Demonstrated experience working with the Microsoft development stack, including SQL Server Management Studio and Visual Studio, for the creation of ETL processes on Microsoft SQL Server, as well as creation of semantic models in PowerBI or SSAS, including DAX query language.
* Design and develop data models, applying extensive knowledge of data warehouse and ETL design principals.
* Develop and implement Quality Assurance checks to ensure data quality, integrity, and lineage across solutions.
* Conduct performance analysis and optimise code as required.
* Undertake unit and system testing of all development work.
Interested? To Apply:
* Attach a brief resume including contact details for 2 referees (referees should have an understanding of your relevant work history);
* A maximum one-page written response outlining your suitability for the role.
We welcome all applicants to share any support needed to ensure our recruitment process is inclusive.
Applications remain current for 12 months from the closing date and may be considered for appointment to identical or similar vacancies within the Department.
Applications from recruitment agencies will not be accepted.