SQL BI Developer at Kempston Employment Solutions

  • Permanent Senior position

  • Johannesburg, Gauteng

  • R30,000 - R50,000 pm basic salary

  • Job 2169012 | Ref KES290

  • Posted 13 Feb 2018 by Kempston Recruitment

About the Position

Reviewing query performance and optimizing code continuously.

Writing queries and procedures used by applications, reports, SSIS packages or SQL jobs.

Designing and developing database tables.

Data modelling to visualize database structure.

Working with application developers to create optimized queries and indexes.

Creating database triggers for automation.

Creating table indexes to improve database performance.

Programming views, stored procedures, and functions.

Development of SSIS packages to load data into the warehouse.

Must have 5 or more years SQL development experience on Microsoft SQL server 2008 r2 or later.

Passion for data and performance.

Experience with enterprise scale data and related considerations like performance, processing and security is high preferred.

Deep understanding of SQL query engine, relational data concepts including advanced development experience of view, stored procedures, functions, jobs, triggers and database structures.

SSIS and SSAS experience advantageous.

Must have at least Maths symbol - C on HG. (Essential)

Desired Skills

  • ssis
  • ssas
  • SQL developing
  • microsoft SQL
  • server 2008
  • r2
  • Maths-C HG

Desired Work Experience

  • 5 to 10 years Software Development

Desired Qualification Accreditation

  • Grade 12 / Matric

About The Employer

Dynamic and vibrant Insurance Company based in Johannesburg.
Passionate about life insurance and the good it can do.

Apply online
This job may be removed before it expires.

Expires in 25 days

Get jobs via email

Receive a daily digest of all new jobs matching this job. Your information is safe with us and you can cancel at any time