Rand Water Is Recruiting: Analyst Programmer: Business Intelligence (BI) Strategic Human Capital – 12 Months Contract- South Africa
CLOSING DATE: 17 MAY 2023
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
