Praesignis is on a major recruitment drive and are looking for skilled and experienced Data Analysts with experience and a good understanding of all aspects of Data Warehouse Life Cycle.Minimum Requirements:
Matric or equivalent. 5 Years experience in Data Management and Data Analysis. Understanding of ETL and BI. SQL and database development skill.
• Business Analyst experience in a BI environment.
• Understanding of business processes.
• Work on more than one project at a time.
• Be able to work within the framework of project methodologies and work independently on support and maintenance tasks.
• Strong communication skills.
• Good writing skills.
• Must be able to pay attention to detail.
• Good general understanding of the relevant industry.
• Work independently.
• Must be a team player.

Job Specifications:
The successful candidate will be working in a fast paced environment using Agile methodology to deliver High quality solutions to our customers. Only best of breed technology will be used for building the BI solutions. These include IBM Information Server, MS SQL, Teradata, Sybase IQ and SAP.
Duties:
• Identify and define the data requirements necessary to support business requirements or integrated application and subject areas.
• Identify and define the security requirements necessary to protect the data items.
• Identify and define the business rules associated with the data; these should include all data integrity / constraint requirements.
• Identify and perform detailed analysis of all data sources for each application and subject area.
• Perform data profiling of data contained in source systems.
• Provide detailed analysis of all data implemented into the database.
• Provide the data mapping and associated transformation rules for each data item.
• Ensure that the business requirements and subsequent development activities are supported by accurate information.
• Support and maintain the project data models at multiple levels of detail and functionality (conceptual, logical, normalised, relational, dimensional, application-level, subject-level, integrated, etc.).
• Assist Data Modellers to draw up detailed data models.
• Assist ETL Analysts to draw up data cleansing specifications.
• Present data quality anomalies and problem areas to business users and source system owners.
• Validate data models against the business- and data requirements.
• Ensure the quality, accuracy, integrity and conformity to standards of all models.
• Provide accurate metadata, which allows full understanding of the project data components.
• Coordinate and synchronise data models with process and technical models.
• Identify data and data model inconsistencies and conflicts.
• Transition information and assist the DBA’s with physical implementation of the data models.
• Transition information and assist develops with the data mapping and transformation and provide additional data analysis as required during the development phase.
• Work with modelling tools and data repository to maintain project deliverables.
• Analyse the business environment related to the past, present and future.
• Work with Project Manager to assist with the estimation and planning of activities.
• Document requirements, including KPI’s, measures, reporting and business dimensions, business processes, data modelling requirements, interface layouts, data flows, screen and report layouts, etc.
• Investigate and define requirements for business processes and the documentation thereof.
• Facilitate the implementation of new / enhanced processes.
• Review processes on an on-going basis and conduct process audits.
• Render support to and facilitate sessions with end-users.
• Work closely with the Solution Architects and Data Modellers to design and implement the best possible solution within the limits of the tools available.
• System and user acceptance testing.
• Provide input to Quality Assurance.
Optional Requirements:
Relevant Tertiary qualification. Experience in MS SQL, DB2, Teradata, Sybase IQ.
Attributes:
Self-motivated with strong team spirit. Good work ethic. Ability to work independently with little supervision as well as the ability to work within a team. Excellent multi-tasking skills. Ability to communicate well to both technical and non-technical staff.