Senior developer - database

Organisation: Victorian School Building Authority Occupation: IT and Telecommunications Reference: VG/DE/VSBA/1838882 Job posted: 08/01/2025 Closes: 02/02/2025 Classification: VPSG5 Job duration: 30/06/2027 Salary Range: $109,730 - $132,764 VPS5 Fixed Term - Full Time until 30th June 2027 About the Department The department provides a wide range of learning and development support and services, policy leadership, and plans for the future of education in Victoria. About the Victorian School Building Authority The Victorian School Building Authority (VSBA) is part of the Department of Education. Established in 2016, it oversees Victoria's largest school building program. The VSBA upgrades existing schools and plans, designs, and builds new schools to meet enrolment demand. About the Role Reporting to the Manager, the Senior Developer - Database will be responsible for designing, developing, building, implementing, and supporting Business Intelligence (BI) and Data Warehouse solutions within VSBA. This role will play a pivotal role in data modelling and designing the Reporting Database and BI solutions. Key Responsibilities: Work closely with the team lead to create optimal physical data models of datasets. Act as a point of contact for VSBA staff requiring BI and report writing assistance. Provide technical expertise within the Business Systems Unit. Develop and maintain metadata information including data dictionaries and entity relationship diagrams. Establish and nurture productive relationships essential for delivering outcomes. Offer expert advice on asset data concepts. Contribute to the development of VSBA's reporting database, known as School Asset Information Lake (SAIL). Identify data gaps and lead the development of new data sources. Extract, transform, and load data from multiple sources into a central data warehouse. Provide advice and recommendations regarding data and systems. Utilise strong conceptual and analytical skills in client-focused roles. Independently analyse problems and demonstrate excellent communication skills. Attributes Data Modeling Expertise: Strong experience in designing and developing data models. Database Design: Proficient in designing databases and optimizing their performance. Data Analysis: Ability to analyze business requirements and translate them into effective data models. Normalization and Denormalization: Strong knowledge of database techniques. Data Governance: Familiarity with data governance practices. Technical Proficiency: Strong SQL skills. Documentation: Ability to create comprehensive data documentation. Problem-Solving: Skilled in identifying data issues and working to resolve them. Communication Skills: Ability to clearly communicate complex data structures. Desirable Qualifications and Experience Relevant tertiary qualification in Information Technology is desirable. Advanced knowledge and understanding of information technology. Proficiency in MS SQL Server, SSRS, SSIS, Power BI, or similar tools. Experience in developing and maintaining metadata information. Experience in scenario modelling of datasets. Proven ability to identify, troubleshoot, and implement solutions. Proven ability to document business requirements. Further Information The department values diversity and inclusion in all forms. Aboriginal and Torres Strait Islander candidates are strongly encouraged to apply. For further information pertaining to the role, please contact Parag Chaudhari- Team Leader via Applications close 11:59pm on Sunday, 2nd February 2025. To apply for this role, you will be redirected to the Victorian School Building Authority job application system. #J-18808-Ljbffr