Analyst Programmer -Business Intelligence and Decision Support Systems at Rand Water

Job Advert Summary

The overall responsibility of the successful candidate in this position is to ensure that quality Analytics and Business Intelligence (ABI), Decision Support Systems (DSS) and Web solutions are in place, stable and satisfy business information and reporting requirements.

Participate in digital technology innovation projects in the Scientific Services division particularly with regards to Data Analytics and Business Intelligence (ABI).

Implement data analytics models that are used to manage data as decision making tools through analysis, predictive modelling, machine learning culminating to what would eventual become augmented Artificial intelligence (Al).

Minimum Requirements

• NQF 7: BTech Information Technology; or BTech Informatics; or BSc Computer Science; or equivalent minimum four-year Tertiary Qualification in IT. An additional qualification of Microsoft certified Database Administrator will be advantageous.
• 5 years’ experience in the field of Digital Technology specifically Business Intelligence.

Primary Duties

• Identifying, gathering / extracting, analysing, documenting business information requirements and problems reported, from business representatives.
• Participate in digital technology innovation projects in the Scientific Services division particularly with regards to Data Analytics and Business Intelligence (ABI).
• Implement data analytics models that are used to manage data as decision making tools through analysis, predictive modelling, machine learning culminating to what would eventual become augmented Artificial intelligence (Al).
• Defining, proposing, documenting, designing, developing / configuring, and implementing ABI, DSS and Web solutions to meet Business Process / Data Owner expectations.
• Administrating, maintaining, and supporting the systems solution(s)
• Develop programs in Python; JavaScript; Visual Studio; and related Analytics and Business Intelligence (ABI) programming tools for use on desktops/laptops and mobile devices (Android and IOS based).
• Training/coaching or mentoring Graduates placed under the Scientific Services Division.
• Ensure that solutions developed under the ABI complies to the following critical capabilities: Security; Governance; Cloud-enabled analytics; Data source connectivity; Data preparation; Catalogues; Automated insights; Data visualization; Natural language query; Data storytelling; Natural language generation; Reporting.
• Perform database data integrity and basic Database Administration.
• Project administration and management.
• Support and participate in the division disaster recovery and redundancy protocols of the BI, DSS and WEIR databases as part of Business Continuity Process (BCP).
• Conduct Technology Research to stay abreast of developments in Analytics and Business Intelligence, Data Science, Artificial Intelligence, Machine Learning, Mobile Application Development, Decision Support Systems and Database Management.
• Mentoring and development of Scientific Services (SS) application users.
• Development of training programs for SS application users.
• Excellent customer service skills.
• Take a role withing the SHEQ systems e.g., Fire fighter, First Aider, SHE Rep etc... when required to do so following engagement and agreement as per the act.

Knowledge

• Working knowledge of Microsoft Windows Server Exposure
• Working knowledge of Project Management and SDLC methodology
• Working knowledge of Microsoft SQL Server and SQL query; Python, JavaScript, Power BI or Visual Studio
• Working knowledge of Analytics and Business Intelligence
• Working knowledge of Mobile App development (Android and IOS)
• Working Knowledge of statistical analyses and/or data science within a SAS application
• Working knowledge of MS Office Packages
• Basic understanding of machine learning and/or artificial intelligence (Al)
• Enterprise information management
• Data \ information Architecture, data \ information flow analysis and data definition languages
• Software Package selection, acquisition and implementation
• Business case development techniques
• Business and system analysis techniques and tools
• Software testing and quality control
• Effective written and verbal communication skills
• Basic knowledge of SANS 241 and other water quality guidelines

Skills

•  Adept at procedure and policy writing.
• Good communication and negotiation skills
• Supervisory, Planning and Organisational skills
• Coaching and problem-solving skills
•  Computer literacy
• Presentation skills
•  Project management
• Strong commitment to quality and integrity
• Ability to effectively present information and respond to questions from groups of Managers
• Systems thinking
• Thinking adaptab
• Judgement
• Decisiveness
•  Initiative and innovative
• Programming in multiple computer languages
• Persistence
• Persuasion\Influence
• Organizational Awareness
• Stress Mastery
• Self-starter – show initiative
• Personal flexibility
• Develop and implement a strategy, procedures, and action plans
• Practice effective teamwork
•  Understanding of LabWare LIMS database structure for the purpose of report generation and ETL (extract, transform, load) for the support of DRP and backups (Production and Operations)
• Understanding the Water Cycle and Rand Water's water services and operations within the water services context (Production and Operations)
• Apply operations research principles and tools in the management of project activities and resources (Project Management)
• Contribute to the management of project risk within own field of expertise (Project Management
• Applying Scientific Testing and Measurement within the Water Services context (Scientific)
• Applying Scientific Research and Development theory and practice within the Water Services context (Scientific)
• Applying Scientific Interpretive skills within the Water Services context (Scientific)
• Applying Scientific Discipline, Concepts re. communication and reporting and presenting information within the Water Services context (Scientific)
• Applying Scientific Monitoring and Quality Assurance within the Water Services context (Scientific)
• Contribute to the management of project risk within own field of expertise (Project Management
• Advising and submitting recommendations to clients on specialist technical knowledge in context of Water Services
• Assess and evaluate the operation of water treatment plants (Production and Operations)
• Applying relevant Digital Technology applications for executing your functions within RW
•  Applying the techniques of coaching and on the job transfer of knowledge and skills (Human Resources)
• Apply accounting principles and procedures in the preparation of reports and decision making

Attitude

•  Ability to chair meetings and record minutes
• Building Trust & Relationships
• Customer Focus
•  Decision Making
• Energy / Tenacity / Stress
• Formal Presentation / Communication
• Managing work / Conflict
• Planning and Organising
• Quality Orientation
•  Technical / Professional Knowledge
• Work Standards