Share this job with your friends, family and co-workers...
THIS JOB ADVERT HAS EXPIRED...
SQL BI DEVELOPER - 366726
Reference:
366726
Date Posted:
2020-11-13
Job Title:
SQL BI DEVELOPER
Industry:
Information Technology / Web Development / Telecommunications
Type:
Permanent
Wage / Salary:
R - Market Related - P/M (Per Month)
Location:
Umhlanga, KwaZulu-Natal
Country:
South Africa
Closing Date:
2021-01-12
Job Description:
A reputable company based in Umhlanga is seeking the perfect candidate to fill a SQL BI Developer role. This role can be Durban or Johannesburg based.
Duties & Responsibilities
Understand and evaluate customer business and Business Intelligence requirements
Develop and deploy innovative, high quality Business Intelligence solutions at customer sites
Supervise the delivery of small to medium sized Business Intelligence solutions from customer engagement to post-implementation support
Identify source data, source systems and data mapping required to deliver the Business Intelligence layer (solution)
Advise customers on options available for display and analysis of information
Proactively identify potential BI solutions within the existing client systems
Development of high-quality database solutions
Develop, implement, and optimize stored procedures and functions using T-SQL
Review and interpret ongoing business report requirements
Use database management tools to investigate, diagnose and resolve database problems in accordance with service level agreements, referring to database users, other staff, and suppliers as and when necessary
Work together with team and clients/users to investigate and model business functions, processes, information flows and data structures, using methodical and consistent techniques
Desired Experience & Qualification
3 years solid experience with T-SQL, database admin, including server maintenance, security monitoring
Excellent knowledge in SSIS, SSRS and Data Warehousing using the Kimble methodology
Excellent knowledge in developing SSAS cubes in SQL Server, including Tabular Models
Proven experiences of large data sets
Proven Knowledge of MDX, PowerShell, tracing of stored procedures
Strong Knowledge of SQL Server
Excellent knowledge of SQL queries, stored procedures, and triggers
Azure experience advantageous but not essential
