EDUCATION, SKILLS AND EXPERIENCE:A relevant ICT degree or equivalent qualificationRequirements gathering - minimum five (6) year experienceProject management - minimum five (6) year experienceTechnical writing minimum five (6) year experienceDatabase design and implementation - minimum five (6) year experienceSQL development - minimum five (6) year experience in developing data solutions on MSSQL platformReporting and dashboarding - minimum five (6)) year experience developing reports and dashboard using PowerBI, SRSS and MSSQLData quality assurance - minimum five (6) year experienceData management - minimum three (3) year experienceData migrations - minimum three (3) year experienceData Warehousing minimum three (3) year experienceData modelling - minimum three (3) year experienceData Governance minimum two (2) year experienceRequirements gathering - minimum two (2) years experience in gathering and translating requirements into technical designs and solutionsMentoring experience in providing mentoring to junior resourcesWorking experience in developing cloud database solutions with databases and platforms in Azure cloud environments is an advantageKEY PERFORMANCE AREAS:Requirements gathering through engagement with business i.e., collect, document, and review business requirements. Database design and implementation design, implement manage complex databases and data structures that meet business requirements, taking scalability, reliability and performance into consideration.Database modelling understanding of data modelling concepts and create logical and physical data models to support database design. create and maintain data models and data structures, ensuring data consistency and accuracy.SQL development - develop SQL scripts and optimise database performance using techniques like indexing, partitioning, and query optimization. including writing complex queries, stored procedures and triggers to support business operations.Data migration migrate data from one data source to another, ensuring data integrity and accuracy during the migration process.Data management manage and maintain large amounts of data and ensure data quality, accuracy, and security. Reviewing reports and performance indicators Data quality assurance ensuring the integrity and accuracy of data through well-defined verification and validation modelsReporting and dashboarding - develop reports and dashboards providing a view on trends, patterns, focus and prediction based on relevant data setsData Warehousing - develop data warehousing solutions, including data integration, data cleaning, and data warehousing design.Technical writing develop and maintain comprehensive technical documentation and specifications and related technical specificationsProject management adhere to project management standards and techniques in the line of workData Governance - implement data governance processes and policies to ensure data integrity and security.Mentoring guide and support junior resources on data related tasks
