Job Alerts

Follow us on Facebook, Twitter or Linked In

Alternatively browse our RSS Job Feeds

Information Technology - Database Professionals Jobs

BI and SQL Specialist

Job Information
LocationRecruitment Agency / Vacancy in Gauteng
SalaryR480K - R300K per annum
Job TypePermanent
EducationBSC Comp Science, industry qualifications or equivalent experience
ExperienceMinimum 3 years experience

Job Description

Our client is looking to hire a BI and SQL Specialist to join their team in the Development Department to be based in Johannesburg. Your main objective will be primarily to be responsible for Data Warehousing and Rational Database Development.

Key areas of responsibility:

• Data Warehouse development and maintenance

• SQL server 2005/8 and relational database development

• Create cubes using SSAS

• Stored procedures, functions, triggers

• DTS packages, SSIS and SQL queries

• Writing more complex queries for specialised requirements on current and new projects

• Develop operational reporting systems

• Develop systems to support operations

• Ensure that data sources cater for demands of ad hoc extracts

• Operations and maintenance of standard, routine queries

• Operate, maintain, enhance and optimize systems

• Ensure correct preparation of data for all operations

• Additional tasks related to data extracts, automated operations and SQL queries as required

• Assist with queries to support both business projects, operational and informational needs

Consults with

• All business divisions

Skills and attributes:

• Strong attention to detail

• Self-starter with the ability to handle multiple tasks in a fast-paced demanding environment

• Ability to work under pressure and deliver on deadlines

Technical skills:

Mandatory SQL Skills

• SQL Database design and architecture

• Development experience: Visual Studio (SSAS, SSIS, and SSRS)

• Solid understanding of Kimball and Inmon methodologies

• Using SQL Scripts

• Stored Procedures

• Functions

• Views

• Understanding of data

• Table management


• Microsoft SQL Server DBA skills

Qualifications and experience:

• Business Intelligence experience including design and maintenance of dimensional data warehouses

• Must have SQL server 2005/8 and relational database development, Stored procedures, Functions, triggers, DTS packages, SSAS, SSRS, SSIS and SQL query experience

• BSC Comp Science, industry qualifications or equivalent experience

• A minimum of 3 years relevant experience

• In depth knowledge of business data

Should you meet the requirements for this position, please email your CV to You can also contact Nadia on 021 555 0432.

NOTE: When replying to the advert, also include the reference number in the subject line.

Correspondence will only be conducted with short listed candidates. Should you not hear from us within 3 days, please consider your application unsuccessful.

or email us:

Job Tools

Like This Job for R2000!

Like or Share this job and if one of your Facebook friends gets this job, we pay you R2 000 if you were the 1st of his/her friends to like it!
If you are a registered Mass Staffing Projects Member on our website we will pay you R2 500!
T&C’s apply.