BI and SQL Specialist - Sandton

My Client a leader in the online gaming industry is looking for a Business Intelligence/ SQL Specialist.

You would be required to have strong attention to detail and be a self starter. Your attention to detail will assist you in been able to have the ability to handle multiple tasks in a fast-paced demanding environment. Your ability to work under pressure whilst been able to deliver on deadlines will make you the ideal candidate. You must have good communication skills as you will be liaising with others to complete tasks.

Your main objective is to be responsible primarily for report and database development.

Key Areas of Responsibility:

SQL server 2014+ relational database development
Stored procedures, Functions, triggers
SSIS and SQL queries
Developing SSRS reports
Writing more complex queries for specialized 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 queries and 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
Ensure that best practices are adhered to at all times.

Skills and attributes required:

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
Ability to liaise directly with users and have good communication skills


Technical skills we are looking for:

Mandatory SQL Skills
SQL Database design and architecture
Dimensional and relational design concepts
Writing T-SQL Scripts
Stored Procedures
Functions
Views
Understanding of data
Table management
Microsoft Reporting Services
Microsoft Integration Services
Microsoft SQL Server DBA skills
Knowledge of OLAP cubes
Excel knowledge (using PowerPivot, PowerQuery and PowerMap)


Advantageous Technical skills we are looking for:

C# experience
Hadoop
Data Warehousing
MongoDB
Power BI


Qualifications and Experience:

Business Intelligence experience including design and maintenance of dimensional data warehouses
Must have SQL server 2014+ and relational database development, Stored procedures, Functions, triggers, SSIS and SQL query experience
BSc Comp Science, industry qualifications or equivalent experience
A minimum of 5 years relevant experience
In depth knowledge of business data

Please note that only short listed candidates will be contacted. If you have not had a response in 2-3 days please consider your application unsuccessful. we will keep your application for other applicable posts.

The biggest job-related Twitter account in the world Best Business Blog Winner / SA Blog Awards 2013