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