Reverside Professional Services (Pty) LtdReverside is a Global ICT company focusing on Digital Engineering, Integration, Cyber-Security, Cloud and Digital Transformation services with delivery centres in Johannesburg and Cape Town, South Africa and Gurgaon, India. Reverside has its Global Headquarters in South Africa and is a B-BBEE Level 1 IT consulting & services organization. Founded in 2006, Reverside has grown to a strong team of over 300+ consultants, serving more than 40+ active clients globally.DescriptionWe are looking for a Data Analyst Professional with 4+ years solid experience. The candidate must be very data hands-on and very strong at writing complex SQL scripts.Key purposeThe primary function of this job is to understand the information requirements and business processes of a client in order to write data warehouse and reporting specifications. As the data analyst in this role, you will be expected to take ownership of the solution and be involved in each step of the SDLC process to ensure that the proposed warehouse/dashboard solution meets the client needs.You will be required to:Understand at a detailed level how certain business processes work (Interviewing stakeholders).Identify, analyze and document business requirements.Analyze source systems and understand how information is stored and related based on the data/business processes (interviewing source system analysts and architects).Catalog and communicate the structure and content of data.Provide meaningful descriptions for individually named data objects.Produce source to target mapping documentation.Undertake detailed data profiling.Document data quality issues and work with stakeholders to formulate resolution strategies.Propose/assist in solutions and create logical data models for BI source implementations.Write dashboard/report specifications once mock-up has been agreed.Play an active supporting role during the development of the warehouse.Assist the Quality Assurance team to produce test plans, test cases and test scripts and write test specifications (when necessary) to ensure quality of the solution.Assist with testing to ensure quality of the solution (Unit, functional and data testing).Experience4+ years of experience as data/systems analyst in building large scale data warehouses.4+ years of experience as data/systems analyst in building reports and dashboards.Strong analytical skills and solid experience in writing functional and technical specifications.Sound understanding of data modelling, both logical and physical models.Exposure to ETL design.SkillsExcellent SQL query writing experience.Good communication (verbal and written).Great attention to detail.MS Office (Word, Excel, PowerPoint, Access).MS SQL.MS Visio.Negotiation.Analytical.Data Warehousing.Business Analytics.Qualifications:Matric.Relevant tertiary qualification: Bachelor of Science (Computer Science) or Bachelor of Commerce (Informatics) or any other relevant certification or diploma.Advantageous:Diploma in Business Analysis.Competencies:Relating and Networking.Persuading and Influencing.Presenting and Communicating Information.Writing and Reporting.Applying Expertise and Technology.Analyzing.Learning and Researching.Delivering Results and Meeting Customer Expectations.Following Instructions and Procedure.Adapting and Responding to Change.Coping with Pressure and Setbacks.
#J-18808-Ljbffr