Analyst Programmer: Business Intelligence (BI) Strategic Human Capital - 12 Months Contract at Rand Water

Job Advert Summary    

• Rand Water is currently looking for an Analyst Programmer: Business Intelligence (BI) - 12 months contract in strategic Human Capital (SHC). The Analyst Programmer is responsible for ensuring the quality of SHC IT BI solutions and reporting to meet business information and reporting requirements. This includes gathering and analysing business information requirements, proposing and implementing SHC BI solutions, and maintaining and supporting systems solutions. The Analyst Programmer will also be responsible for SHC Reporting requirements, including SHC Generic KPI Reports, Shareholder Compact, Statutory reports, and ad-hoc reports.

Minimum Requirements    

• Minimum: NQF 7, Bachelor’s degree in computer science or related field
• Desired: Honours Degree in computer science or related field with 5+ years related Expereince

Primary Duties    

• Gather, extract, analyse and document business information requirements and problems reported from SHC business representatives.
• Propose, design, develop/configure and implement SHC BI solutions (data warehouse, data marts, ETL, cubes, reports) to meet SHC Business Process/Data Owner expectations.
• Maintain and support systems solutions.
• Develop SHC Generic KPI Reports, Shareholder Compact, Statutory reports, and ad-hoc reports.
• Develop bespoke programmes, including Remuneration: Total Cost to Company Modeler, Total Cost to Company Report, Net Pay Calculator.
• Develop reports at both tactical (MIS) and strategic levels (e.g., Business Performance, Balanced Scorecard or Dashboarding).
• Develop data warehousing solutions, including data marts as well as data extraction, loading, and reconciliation.
• Define data definition languages, data catalogues, and/or cubes.
• Develop test scenarios and conduct unit, integration, and user acceptance testing.
• Compile system and training documentation.
• Integrate third party products.
• Communicate and interact with SHC Project Manager, SHC business process owners and SHC super users.

Knowledge    

• Strong programming skills in SQL and experience with BI tools such as Tableau, Power BI, Power Platform or similar
• Knowledge of SAP HR Modules will be beneficial.
• Experience in data modelling, ETL development, and data warehousing.

Skills    

• Strong analytical and problem-solving skills.
• Ability to work in a team environment and communicate effectively with stakeholders
• Accuracy and attention to detail

Attitude    

• Calm – work with tight deadlines
• Be able to manage stress

Closing Date    
2023/05/17