Purpose: Perform development, advancements, support and give moxie in Data Warehouse and Reporting operations through the jotting of applicable queries and the development of data analysis and Business Intelligence( BI) reports. This part requires a combination of specialized moxie, report jotting, problem- working chops, and a strong understanding of data operation principles.
SALARY CENTRE Conditions R444 036per annum( Level 09) Bhisho A Degree( NQF position 7 as recognised by SAQA) In Computer Science/ Information Systems/ Financial Information Systems/ IT coupled with Minimum of 3 times’ work experience at an Officer position( Level 7 or advanced) in data storehouse inventor, data critic, data scientist, or Business Intelligence inventor, and with at least 2 times’ experience working with MS SQL. Experience and knowledge of any BI tools( e.g. MS Power BI) will be an added advantage.
Capabilities Advanced knowledge and experience in relational databases. Strong communication chops, donations and report jotting. Proficiency in MS SQL including ETL( SSIS), T- SQL, and experience with data warehousing technologies. Proficiency in MS Excel. Knowledge of data modelling ways. Strong understanding of data operation principles, including data integration, and data security. Capability to troubleshoot and resolve issues related to data storehouse performance and data quality. The capability to work effectively with other platoon members and stakeholders to understand their data conditions and insure the data storehouse meets these requirements. Capability to design, assay, and interpret complex data storehouse structures and schemas.
Experience in database design for data storehouse and business intelligence operations, including relational database structures and normal forms. Responsiveness, Team Player, Interpersonal Skill, Communication, Collaboration, Planning and Organising, Problem working and Decision Making and Project Management. Business Analysis Analysis of requests for robotization of business process that have a fiscal recrimination. Conduct business conditions needs analysis. Reviewal of and reengineering of business processes related to fiscal systems that bear process enhancement. Define reporting and waking conditions of stakeholders as well as crucial reporting points and criteria to be tracked.
Analysis of requests for fiscal systems data to identify common areas that bear standardised reporting- give input into the improvement of the fiscal information systems data storehouse standard operating procedures. Support In relating Applicable Data Sources and prize Transform and cargo Data For The Financial Information Systems Data Warehouse; help in relating applicable data sources for the fiscal information systems data storehouse. integrate data from colorful sources into the fiscal information systems data storehouse, icing thickness and delicacy. Develop and manage ETL( Excerpt, transfigure, cargo) processes to move and transfigure data between systems. Cleanse, import, and store data into the fiscal information systems data storehouse. – apply and maintain mechanisms to insure the quality and delicacy of data within the fiscal information systems data storehouse.
Apply and manage data security measures to cover sensitive data. Analyse the data in the Financial Information Systems Data Warehouse; Optimize fiscal information systems data storehouse performance to insure presto and effective data reclamation. Examiner and assay data using Business Intelligence tools and ways. Design data models to directly represent business processes and support data analysis. unite with the applicable internal and external stakeholders to insure the fiscal information systems data storehouse meets these requirements. Manage data requests to insure prioritisation of stakeholders and timeous responses.
Work as a member of the fiscal information systems data storehouse platoon to deliver business intelligence information to the stakeholders in a timeous manner. help in the analysis of the data in the fiscal information systems data storehouse to determine trends patters and implicit anomalies that bear farther review. Development and conservation of standardised reports grounded on linked trends and patterns. Project Management and Functional Support( Training); furnishing design operation support to FIS and affiliated design and data enterprise. give design administration.
icing that all design conditioning are directly proved. Monitoring design perpetration against planned targets. Escalation of design detainments. Supporting design perpetration and Change Management enterprise. Development of required training material related to design perpetration and data enterprise. Provision of Functional support and training of druggies. Training of druggies on the data handed in response to requests for information and how to use available tools e.g. MS Excel and PowerBI etc. Administration; Communication of plans and unit performance to critical stakeholders.
Maintain knowledge systems by keeping streamlined records of all critical business processes. Annual Performance Plan( APP) and functional Plans are developed and enforced within the set norms. Work from the unit( letters, memos, plans, reports) is of respectable situations of quality and within the timeframes agreed in the service norms. give input into the daily reporting of the performance of the fiscal information systems data storehouse unit. Misbehave with standard executive liabilities. Ms T. Nkonyile at 0838755707/ Ms. B Ndayi at 0605735574/ Ms. N Cloete at 0837351092.
