Division: PEOPLE, PERFORMANCE & TECHNOLOGY 
Unit: DATA & INFORMATION MGT  
Section:  DATA SERVICES 
Salary:  AUD 144,126.00 per annum plus Superannuation
Employment status: Permanent 
Employment arrangement: Full Time
Location: Sydney CBD

Option to work under a 19 day month arrangement

At the City of Sydney our people are our most important asset and central to achieving our exciting and ambitious Sustainable Sydney 2030 – developing a green, global and connected city. 

We are seeking a highly motivated and experienced Senior Business Intelligence / Data Analyst to join our Data & Information Management Services Unit.

This exciting and challenging role will be mainly responsible for:

• designing, building, deploying, and managing / maintaining the City’s data models, reports and dashboards to meet business scenarios and requirements
• maintaining existing and future business intelligence artefacts such as interfaces, data models, dashboards, and reports
• improving the City’s business intelligence and data integration capabilities throughout the City’s business intelligence program
• assisting business areas discover insights through data analysis, reporting, and visualisation.

To be successful you will have: 

• relevant tertiary (such as Mathematics, Statistics, Software Engineering and Computer Science), at degree level, and/or significant equivalent experience in business intelligence and data architecture and management

• expert level of knowledge in Microsoft Power BI, with demonstrative experience in in elicitation of BI requirement from business and translate into technical requirements
• experience in database design, development and modelling in SQL Server & data visualisation through Power BI M query and DAX

• strong background and expertise in Microsoft SQL Server 2014 (and later version) and the MSBI product suite like SSAS, SSIS. Experience working on data integration projects developing, modifying, and debugging packages in SSIS. Experience in developing tabular and multi-dimensional cubes using SSAS
• experience in Data warehouse and ETL solution design including batch and near-real time processing and database performance tuning
• experience in the end-to-end software development process as part of a project lifecycle including design, build, debugging, testing, deployment and documentation.

At the City you will join a dedicated team where individual effort is part of something much bigger – delivering great things for our city’s dynamic future.

To apply:  Click on the 'Apply' button below to complete your online application. Please upload your current resume and respond to the online application questions that demonstrates how you meet the requirements of this role. Please note the "Essential Criteria Response" field in the online application does not require you to respond or upload a document.

This role will require a national criminal check and pre-employment health declaration.

Position description: CLICK HERE to view or download the position description.

Applications must be made online via the City’s website by 11.59pm on Tuesday 25 August 2020.

For further information contact: Steven Zhong, Manager, Data Services on 02 9288 5853.

Employee Benefits: CLICK HERE for more information on the benefits of working in Council.

At the City we provide equal employment opportunity. We are committed to ensuring an accessible and inclusive work environment and encourage applications from people from diverse backgrounds and cultures.