BI Consultant

SUMMARY:
The Role:

We are looking for a BI Consultant: Office based (Centurion)

• Development of high-quality database solutions 
• Develop, implement, and optimize stored procedures and functions using T-SQL
• Review and interpret ongoing business report requirements
• Research required data
• Build appropriate a...
  
  

  POSITION INFO:
  The Role:

  We are looking for a BI Consultant: Office based (Centurion)

  • Development of high-quality database solutions 
  • Develop, implement, and optimize stored procedures and functions using T-SQL
  • Review and interpret ongoing business report requirements
  • Research required data
  • Build appropriate and useful reporting deliverables
  • Analyse existing SQL queries for performance improvements
  • Suggest new queries
  • Develop procedures and scripts for data migration
  • Provide timely scheduled management reporting
  • Investigate exceptions with regard to asset movements
  • Unit testing and compliance to Change Control process
  • Data Warehouse load process monitoring (Standby after hours)
  Skills and Experience:
  • Proven experience as a BI Consultant (3- 5years)
  • In-depth knowledge of MS Reporting services
  • Thorough understanding of Business Intelligence concepts, like the ETL process, Dim and Fact tables and Warehouse
  • Working knowledge of SSIS-packages
  • In-depth knowledge of T-SQL including complex SQL queries (ex: using various joins and sub-queries) and best practices
  • Assisting in database design and technical specifications
  • Monitoring SQL performance issues and efficiency (Dead lock tracing etc.)
  • Creating and optimizing complex SQL queries for data extraction
  • Developing and maintaining interfaces between Symplexity and other systems.
  • Ability to understand complex technical and logical concepts.
  • Strong quantitative, analytical, problem solving, organizational, communication and interpersonal skills are required.
  • Familiarity with RDBMS principles, database design and normalization
  • Experience with complex query design, stored procedures, views and functions
  • Understanding of index design and T-SQL performance tuning techniques

   

  Following skills are a plus:

  • MS Reporting services Subscriptions
  • Crystal 8.5, 10 or 11 knowledge
  
  
  

   

  NB! This job is now closed. You can apply for other jobs by uploading your CV.

  
  

  ---

   

  New users - Upload your CV

  Existing users - Login here