Title of the position
BI and SQL Specialist
 
Department
Development
 
Main objective
Responsible primarily for report and database development.


Key areas of responsibility
 
·         SQL server 2008 / 2008 R2 relational database development
·         Stored procedures, Functions, triggers
·         SSIS and SQL queries
·         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
 
 
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 2008 / 2008 R2 and relational database development,
         Stored procedures, Functions, triggers, SSIS and SQL query experience
·         BSc Comp Science, industry qualifications or equivalent experience
·         A minimum of 4 years relevant experience
·         In depth knowledge of business data


How to apply: