Data Analyst SQL - Rivonia Verfied Gold Badge

Salary Negotiable Rivonia, Gauteng Rivonia, Gauteng more than 14 days ago 18-09-2015 12:01:06 PM
16-10-2015 12:01:06 PM
Our Client is the leading independent Management Consulting Firm in South Africa.

Minimum Requirements...
Qualifications and Experience:

Matric plus applicable tertiary equivalent experience or preferably, an ICT relevant diploma or degree from a recognized tertiary institution
DAMA certification and experience are beneficial but not required
Have a Drivers' License and a willingness to travel
Be a creative and analytical thinker
Have a desire and ability solve complex business processes with software
Be highly driven and able to self-manage in a fast paced environment
Possess strong organizational and time management skills
Build rapport and develop effective working relationships with clients

Experience:

Must have at least 4 years' experience, ideally in a consulting or financial services environment
Ability to communicate well with various levels, adapt to different project environments and play a flexible role on projects
Database and data warehouse concepts, principles, design and implementation.
Knowledge of BI methodologies such as Kimball and Inman.
Usage of tools supporting the above (i.e. Visio, Erwin, Enterprise Architect)
Logical and physical data modeling using industry best practices, patterns and frameworks
Database design and development using Microsoft SQL Server
Knowledge of Ab Initio, Cognos and SAS an advantage.

Job Specification...
Key Performance Areas:

Assist business analysts and business users with developing requirements and assessing their viability based on current and future data architecture.
Creating detailed technical specifications that specify data sources, data flows, data transformations, data storage and reporting.
These include source-to-target-maps, data dictionaries, logical and physical data models.
Interact with technical and business stakeholders to identify data sources, create solutions collaboratively and implement operational systems.
Ensure operational database and data warehouse systems are functioning within specification and provide optimization where necessary.
Assist with technical implementation of solutions where necessary.
Promote the use of existing enterprise and divisional database and date warehouse standards to enhance data integrity, data quality, data governance and data stewardship.
Promote reusability, maintainability, reliability, and scalability in design and development of data solutions

If you wish to apply for this job please answer the question(s) below then click the apply button

Yes No

Do You Have Financial/banking/consulting Industry Experience.?

Do You Have Sql/sas Experience