Analyst Programmer Business Intelliigence (BI) X2 at Rand Water

Job Advert Summary    

The incumbent will Design data modelling, use analysis services to mine enterprise systems and applications for knowledge and information that enhance business processes. Will also be responsible for assisting

in building, deploying, and maintaining data support tools, metadata inventories. Gather and Analyze business requirements, acquire solutions, extract data, analyse and assemble data, develop, test, implement, support and maintain applications, and communicate findings for decision making.

Minimum Requirements    

• IT Degree/diploma or equivalent
• Desired education: Business Intelligence Development Certification/Data Analytics /Data Science Certification
• 4 years’ experience in Management Information Systems/Business Intelligence (BI), data scientist and data analysis
• 3+ years Business Intelligence experience
• 4+ years of database design or integration experience with SQL Server databases
• Relational Database and SQL Language. Knowledge of Power BI, Power Pivot, M, T-SQ, PL/SQL, DAX. Cube and
• report development (Advantageous) Report Development (Microsoft SSRS)
• Extraction, Transformation and Loading (ETL) (Microsoft SSIS). SSAS Tabular Development (Microsoft SSAS and
• DAX, M, MDX).
• Data Warehouse / Solution Design. Collect and organize data to find patterns. Data Gathering, Data Visualisation, Data
• Cleaning, and data Validating. Creating algorithms, Dimensional Modelling and OLAP cubes. (Advantageous)
• Performance Scorecards/KPI Knowledge and development.
• System analysis process, Business analysis process.
• Experience in developing a project plan and exposure in project management environment.
• Development of test scenarios, unit testing, integration testing & UAT testing.
• SAP BW4/HANA knowledge would be advantageous. SAP Analytics Cloud would be advantageous

Primary Duties    

•  Development, implementation, testing, support, and maintenance of data analytics systems
• Investigation and proposing of solutions to business problems Dashboards development and giving oral presentations and reports. Communicate data findings in writing, with charts and graphs, or combination.
• Adherence to change control processes and principles.
• Solution implemented conforms to user requirements.
• Ensure that all new solutions are properly tested before implementation. Users trained on how to use functionalities
• implemented.
• Proper compilation and sign-off of all systems and Business Requirements documentation.
• System processes are optimally set-up. Software upgrade, version, and configuration control.
• Helpdesk Calls completed within SLA and Maintain high user satisfaction rate. Bringing new ways of doing things

Knowledge    

• Understanding of end to end processes
• Decision support systems
• 3rd Party products integration
• Documentation relating to all changes/development work
• installation of Enhancement/Service Packs and Fixes to rectify found vulnerabilities;
• SDLC Methodology
• SAP-BO Development
• Change control principles and processes
• Systems & Business analysis
• Progress reports against current tasks

Skills    

• Systems & Business analysis
• Create detailed functional &
• technical specifications.
• Data visualisation.
• Mathematical skills, Statistical
• Analysis and Data Mining
• Programming Languages
• SQL for data Manipulation,
• analysis, and scripting
• Power BI/ Tableau/SAC, DAX,
• ETL, SSIS, SAS.
• Machine Learning.
• Knowledge of SAP BPC -
• running process chains, would be advantageous