Johannesburg: Business Intelligence (BI) Specialist

Job Title: Business Intelligence (BI) Specialist Reporting Line: Chief Technology and Information Office (CTIO) Salary Range: R570 700 – R741 900 per annum Main Purpose of Job: Use business intelligence (BI) technologies to process, analyse, report on and track business information at operational and strategic levels. Key Responsibilities: 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 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. 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 databse servers as and when required. Work closely with the IT team to ensure that the security and integrity of the databse 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 viualise spatial data effectively. Develop presentations and communicate findings of analysis to various clients. Guide principles for data visualisation and train fellow employees on best practices for data visualisation techniques. Provide support in digital transformation initiatives through BI insights and analytics. Values Management Behaviours in line with the company’s values and principles.The values are: Performance-orientated Excellence Accountability Teamwork The supporting principles are respect, trust, care and integrity. Skills Comprehensive knowledge of Business Intelligence, data management and data visualisation is required. Excellent statistical and analytical skills are required. Advanced database design and SQL skills is required. Programming and scripting is required to develop statistical or spatial models. Good communication and presentation skills. Experience in Geographic Information Systems (GIS) Must be able to pay attention to detail and work under time constraints to accomplish project deadlines. Keep abreast of new trends and innvations in the field of business intelligence, database design, spatial and statistical modelling, as well as related hardware and software. A valid driver’s licence is required as travelling is required from time-to-time. Qualifications & Experience At least a degree in Computer Science, Information Systems, GeoInformatics, Statistics, Engineering or related disciplines. Must be literate in Microsoft technologies such as Microsoft SQL Server, Microsoft Excel Pivot Tables & PowerPivot and Microsoft Access. Must have experience in Tableau and/or other BI tools, as well as integration with statistical packages such as R. and More thank five years of current experience designing, implementing, and maintaining databases and applications in a relational environment, along with experience in data visualisation, data analysis and working with large quantities of data. More than three years of current experience in GIS and statistical modelling. Experience in assessing client needs and trabslating them into information products and services is also required. If you meet the above requirements and have the relevant qualifcations and experience, please apply by submitting your CV.