SQL Developer

Fixed Term - Bellville
Experience:
 - Business technology degree (BCom, Information Management qualification)
 - Experience in Financial Services is a requirement with Wealth Industry knowledge being an advantage
 - 3 – 4 years solid experience in a data warehousing environment and ETL development framework
 - Exposure to big data
 - Experience in report writing and user interaction
 - Experience in managing/creating datamarts, dimension modelling and facts
 - Expertise in the Microsoft BI solution offerings including SQL Server 2012 / 2008 R2 Stack (SSRS, SSAS, SSIS)
 - Knowledge of PowerView, PowerPivot, SharePoint and Excel are an advantage
 - Understanding of BI solutions
 - Operational and analytical, strong knowledge of relational and multi-dimensional database architectures
 - In-depth understanding of the Ralph Kimball data warehouse methodology
 - Experience in report writing
 - Knowledge in the technical aspects of BI, including data modelling, ETL, metadata / data management and OLAP tools
 - 5+ years working experience in the field of data warehousing and BI
 - A good feel and understanding of business in general
Technology:
 - Exposure to mainstream Microsoft BI tools is a requirement, and an added advantage is exposure to Cognos, QlikView, Tableau or similar
 - Advanced Excel, OLAP and presentation skills
 - Familiar with a semantic layer and designing frameworks for reporting and analysis
 - Cube development using SSAS
 - ETL knowledge (SSIS)
 - Data warehousing conceptual and practical knowledge
 - Advanced knowledge of SSAS, SSIS and SSRS
 - Exposure to MS PowerQuery and PowerBI is an advantage
 - Advanced knowledge of SQL and SQL server skills (SQL 2012 – 2014) is an advantage
 - Knowledge of MDX query
    © 2024 Rough Diamonds Studio. All rights reserved.