Business Intelligence Specialist (Head Office)

Data Acquisition, Integration & Quality Assurance

• Establish the data requirements of internal/external clients through running consultation for developing data definitions and standards.
• Identify potential data sources through defining the data requirements and hypotheses, searching the general data environment and establishing partnerships and/or agreements with data custodians.
• Receive data in line with agreed partnerships, arrangements and/or agreements with internal/external clients as required.
• Review and normalise each set of data received from different sources through verifying the reliability, consistency and accuracy of the data in terms of data infrastructure standards.
• Integrate data from different sources through creating an integrated data framework, establishing relationships between data and identifying potential data conflicts or duplications.
• Participate in data quality assurance and compliance processes supporting organisational frameworks

Database design and administration

• Design, develop and support databases required for BI/GIS reporting.
• Work closely with the IT team to install, configure, maintain and administer database servers as and when required.
• Work closely with the IT team to ensure that the security and integrity of the database is maintained at all times.
• Work closely with the IT team to ensure that backups of the database are done and restored daily.
• Work closely with the GIS team to build spatial geodatabases.

Data analysis and interpretation

• Analyse and manipulate raw data and create information products that can be used across various business units of the organisation based on clients’ needs.
• Use GIS software to collect, analyse and interpret spatial data.
• Use statistical software packages such as Microsoft Excel or R to process and summarise large volumes of qualitative and quantitative data.
• Use programming, scripting and/or model builders to develop spatial and statistical models that could be used to support operational and strategic decision-making.
• Interpret findings from data analysis and develop conclusions and recommendations for application by clients.

Data visualisation

• Use Business Intelligence tools such as Microsoft Excel PowerPivot or Tableau to visualise operational and strategic data in the form of interactive dashboards and infographics.
• Use various GIS tools to visualise spatial data effectively.
• Develop presentations and communicate findings of analyses to various clients.
• Guide principles for data visualisation and train fellow employees on best practices for data visualisation techniques.