BI Data Modeller - Sandton Verfied

R 360 per hour Sandton, Gauteng Sandton, Gauteng more than 14 days ago 11-02-2015 8:42:47 AM
11-03-2015 8:42:47 AM
BI Data Modeller
Contract Period: 6-12 months
Key Purpose
The primary function of this job is to understand the business information needs and detailed requirements in order to create and document logical and physical data models.
Role Outputs
You will be required to:
Interact with the Business Analyst and End Users to understand the business information needs, detailed requirements and business processes.
Conduct detailed data profiling in collaboration with the Business Analyst
Identify and make recommendations for managing data quality errors identified during data profiling
Conduct interviews and workshops with project team to gather additional requirements
Create and document logical, physical and dimensional data models that meet the business needs and technical requirements of the ETL and front-end reporting tools.
Review the data model with business and technical team
Assist BI ETL and reporting tool developers to understand and implement the data model
Produce source-to-target mapping documentation

Experience
5+ years of experience in building large-scale data warehouses and BI solutions
Proven track record in producing logical and physical data models within Business Intelligence solutions in Corporate, Financial Services environments
Exposure to ETL design

Skills:
Kimball dimension data modelling methodology preferred
Excellent SQL query writing experience
Good communication (verbal and written)
Great attention to detail
Presentation
MS Office (Word, Excel, Powerpoint, Access)
MS SQL
MS Visio
Negotiation
Business Analytics

Qualifications:
Essential:
Matric
Relevant tertiary qualification:
??Bachelor of Science (Computer Science) or
??Bachelor of Commerce (Informatics) or
??Any other relevant certification or diplomas
Competencies:
Relating and Networking
Persuading and Influencing
Presenting and Communicating Information
Writing and Reporting
Applying Expertise and Technology
Analysing
Learning and Researching
Delivering Results and Meeting Customer Expectations
Following Instructions and Procedures
Adapting and Responding to Change
Coping with Pressure and Setbacks

Recruiter: O2 Placements