BI and SQL Specialist

Department
Development

Reports to
HOD

Main objective

Responsible primarily for report and database development.

Key areas of responsibility

  • SQL server 2012 and above relational database development
  • Stored procedures, Functions, triggers
  • SSIS and SQL queries
  • SSAS Development and maintenance
  • Developing SSRS reports
  • 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 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
  • Data ware housing

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

Technical skills

  • 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)

Qualifications and experience

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

Apply for this position

Allowed Type(s): .pdf, .doc, .docx