Description:
A well known government entity is seeking an experienced BI / Data warehouse Developer / Data Analyst to join them as an Assistant Director (Financial Information Systems Analyst) in Bhisho.
Qualifications and experience:
Bachelors' degree - Computer Science / Information systems / Financial information systems / IT
No less than 3 years' work experience at Level 7 or higher in government, covering Data warehousing developer/ Data Analyst / Data Scientist / BI developer roles
No less than 2 years' working experience on MS SQL
Power BI experience and knowledge is an advantage
Advanced knowledge and experience in relational databases
Great track record - reference checks will be conducted upfront
Key skills:
Analytical
Communication
Report writing
Presentation
Troubleshooting
Interpret complex data
Interpersonal
Database design
Collaboration
Planning
Organising
Problem solving
Decision making
Stakeholder management
Technical
Competencies:
Proficiency MS SQL - ETL (SSIS), T-SQL, data warehousing technologies
Strong understanding of data management principles - data integration and security
Troubleshooting and resolving issues related to data warehouse performance and data quality
Key performance areas:
Development, enhancements, support and providing expertise in the data warehouse and reporting applications, by means of writing relevant queries and the development of data analysis and BI reports.
Analysis of requests for automation of business processes that have financial implications.
Re-engineering of business processes.
Support in the identification of relevant data sources and extracting transformation.
Loading data for the financial information systems data warehouse (ETL).
Analyst the data in the financial information systems data warehouse - Design data models, manage data requests, monitor and analyse BI tools.
Development and maintenance of standard reports based on trends and patterns.
Project management and functional support - Monitor project implementation against planned targets. Support project implementation and change management.
Develop training material.
Annual performance plan and operation plan development,
Communication of plans and unit performance to critical stakeholders.
Provide input into the quarterly reporting of the performance of the financial information system data warehouse unit.