SQL & BI Server Support (one-year contract)

  • Posted:27 May 2021
  • Location:Pretoria, South Africa

Reports to: IT Manager

Direct Reports: None

Job Purpose

This is a SQL Server Support and Implementation position to support various applications and systems that make use of MSSQL for a one-year period.

Duties and Responsibilities

  • SQL & BI Server Support
  • Assist with implementation, design, development and maintenance SQL server and business intelligence solutions
  • Assist with development of custom SQL and BI solutions as required
  • Implementing and streamlining of support and business systems making use of SQL and BI
  • Crafting and executing queries upon request for data
  • Presenting information through reports and visualization
  • SQL DBA functions and support
  • Assist with AI integration across all systems
  • Assist with implementation of Azure SQL and data services to compliment BI
  • Responsible for troubleshooting and problem solving of SQL and all applications connecting to SQL
  • To proactively monitor and maintain all services and systems
  • Translate business needs to technical specifications
  • Maintain and support data analytics platforms
  • Collaborate with teams to integrate systems
  • Develop and execute database queries and conduct analyses
  • Create visualizations and reports for requested projects
  • Develop and update technical documentation
  • Integrate Data: SQL data analysts integrate data from multiple data sets into one database system to streamline information
  • Create Database Functions: SQL data analysts’ program specific database functions to create database triggers and design data tables
  • Design Reports: After reviewing and analysing data, SQL data analysts design reports to show statistics and other information about specific database topics
  • Write Scripts: SQL data analysts write scripts to analyse data and perform specific data queries
  • Resolve Data Issues: SQL data analysts isolate and resolve issues with data and databases
  • SQL data analysts and collation across all systems.

Qualifications and Experience

  • Windows Server 2012, 2016 and 2019 experience
  • 5+ years’ experience using Microsoft SQL Server
  • 5+ years’ experience in database design, schema design, data model, data solutions and complicated visualizations
  • 5+ years’ experience in SSIS
  • Azure platform experience will be advantageous
  • Power BI experience a plus but a not requirement
  • Datawarehouse experience a plus but a not requirement

Knowledge & Skills

  • SQL Server knowledge that covers but is not limited to designing database tables and structures, creating views, functions, and stored procedures, writing optimized SQL queries for integration with other applications, creating database triggers for use in automation, maintaining data quality, designing, and maintaining of SQL replication and overseeing database security
  • Good communicator
  • Comfortable working across the business
  • Attention to detail and thorough
  • Logical and methodical
  • Analytical thinking and problem solving

Click here to apply.

Job description