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