Wednesday , April 17 2024

City of Swan Careers – Business Intelligence Developer

Website City of Swan

Job Description:

Design and develop Business Intelligence (BI) solutions and Corporate Reports to meet the City’s information needs. This will be achieved by using requirements analysis and design techniques and writing sustainable code according to the City’s standards and guidelines. Assist in the overall management and maintenance of information data warehouses operating in the City’s infrastructure and technology platform. Partner with technical groups to ensure that database performance is optimised
and performance standards adhere to the City’s service level agreements

Job Responsibilities:

  • Design and development of the City’s BI applications and corporate reporting in a timely manner
  •  Ensure Corporate SLA’s for the BI functions are met
  •  Ensure that all BI services are running and completing without application errors
  •  Resolve integrity errors of the City’s BI applications and core systems within the SLA’s.
  •  Perform data warehouse design and modelling according to established standards
  •  Determine BI and data warehousing solutions to meet business needs
  •  Manage new reporting and enhancements based on change requests
  •  Assist in capacity planning for existing; and proposed corporate applications
  •  Other tasks as required by the manager

Job Requirements:

  • Skilled in creating stored procedures and scripts in Microsoft SQL.
  •  Understanding of data base, warehouse design, development and modelling.
  •  Skills in the use of the Microsoft Office suite of applications.
  •  Communication and research skills.
  •  Demonstrated ability to interpret and apply legislation, as well as organisational policies and procedures.
  •  Sound knowledge of administrative procedures with considerable experience.
  •  Ability to proactively solve issues within area of responsibility in a timely and effective manner.
  • Ability to apply project management techniques to specific projects as and when required.

Qualification & Experience:

  • Certificate or higher level qualification in a relevant discipline or industry recognised certification
  • Microsoft Certification in Business Intelligence
  • 3 years’ experience in Microsoft SQL Reporting Services (SSRS)
  • 3 years’ experience in Microsoft SQL Analysis Services (SSAS)
  • 3 years’ experience in Microsoft SQL Integration Services (SSIS)
  • SQL Integration Services (SSIS)
  • 3 years’ experience in Business Intelligence development
  • 3 years’ experience in Data Warehouse administration

Job Details:

Company: City of Swan

Vacancy Type:  Full Time

Job Location: Swan,Western Australia, Australia

Application Deadline: N/A

Apply Here