SUMMARY:
-
POSITION INFO:
Job Description:
Perform development, enhancements, support and provide expertise in Data Warehouse and Reporting Applications through the writing of relevant queries and the development of data analysis and Business Intelligence (BI) reports. This role requires a combination of technical expertise, report writing, problem-solving skills, and a strong understanding of data management principles.
Education and experience:
- A Degree (NQF level 7 as recognised by SAQA) In Computer Science/ Information Systems / Financial Information Systems /IT coupled
- Minimum of 3 years’ work experience at an Officer level (Level 7 or higher) in data warehouse developer, data analyst, data scientist, or Business Intelligence Developer, and with at least 2 years’ experience working with MS SQL. Experience and knowledge of any BI tools (e.g. MS Power BI) will be an added advantage.
Responsibilities:
Business Analysis
- Analysis of requests for automation of business process that have a financial implication. Conduct business requirements need analysis.
- Reviewal of and reengineering of business processes related to financial systems that require process improvement.
- Define reporting and alerting requirements of stakeholders as well as key reporting points and metrics to be tracked.
- Analysis of requests for financial systems data to identify common areas that require standardised reporting – Provide input into the enhancement of the financial information systems data warehouse standard operating procedures.
Support In Identifying Relevant Data Sources and Extract Transform and Load Data for The Financial Information Systems Data Warehouse
- Assist in identifying relevant data sources for the financial information systems data warehouse.
- Integrate data from various sources into the financial information systems data warehouse, ensuring consistency and accuracy.
- Develop and manage ETL (Extract, Transform, Load) processes to move and transform data between systems.
- Cleanse, import, and store data into the financial information systems data warehouse. – Implement and maintain mechanisms to ensure the quality and accuracy of data within the financial information systems data warehouse. Implement and manage data security measures to protect sensitive data.
Analyse The Data in The Financial Information Systems Data Warehouse
- Optimize financial information systems data warehouse performance to ensure fast and efficient data retrieval.
- Monitor and analyse data using Business Intelligence tools and techniques. Design data models to accurately represent business processes and support data analysis.
- Collaborate with the relevant internal and external stakeholders to ensure the financial information systems data warehouse meets these needs. Manage data requests to ensure prioritisation of stakeholders and timeous responses.
- Work as a member of the financial information systems data warehouse team to deliver business intelligence information to the stakeholders in a timeous manner.
- Assist in the analysis of the data in the financial information systems data warehouse to determine trends / patters and potential anomalies that require further review.
- Development and maintenance of standardised reports based on identified trends and patterns.
Project Management and Functional Support (Training)
- Providing project management support to FIS and related project and data initiatives.
- Provide project administration. Ensuring that all project activities are accurately documented. Monitoring project implementation against planned targets.
- Escalation of project delays. Supporting project implementation and Change Management initiatives. Development of required training material related to project implementation and data initiatives.
- Provision of Functional support and training of users.
- Training of users on the data provided 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 updated records of all critical business processes.
- Annual Performance Plan (APP) and Operational Plans are developed and implemented within the set standards.
- Work from the unit (letters, memos, plans, reports) is of acceptable levels of quality and within the timeframes agreed in the service standards.
- Provide input into the quarterly reporting of the performance of the financial information systems data warehouse unit. Comply with standard administrative responsibilities.
Competencies / Skills:
- Advanced knowledge and experience in relational databases. Strong communication skills, presentations and report writing.
- Proficiency in MS SQL including ETL (SSIS), T-SQL, and experience with data warehousing technologies. Proficiency in MS Excel.
- Knowledge of data modelling techniques. Strong understanding of data management principles, including data integration, and data security. Ability to troubleshoot and resolve issues related to data warehouse performance and data quality.
- The ability to work effectively with other team members and stakeholders to understand their data requirements and ensure the data warehouse meets these needs.
- Ability to design, analyse, and interpret complex data warehouse structures and schemas.
- Experience in database design for data warehouse and business intelligence applications, including relational database structures and normal forms.
- Responsiveness, Team Player, Interpersonal Skill, Communication, Collaboration, Planning and Organising, Problem Solving and Decision Making and Project Management.
