Data Sciences Architect

Client Transaction Capital Recoveries
Reference # DSA
Published 17/07/2017
Contract Type Permanent
Location Hyde Park, Gauteng, South Africa
Introduction
Responsible for both new and existing technology projects within the supply chains.
Job Functions Information Technology
Industries Financial Services
Specification
1
Research and Design
 Researching system implications and solutions
 Researching latest technologies and methodologies
 Code profiling
 Providing input to the Business Analyst regarding the quality and accuracy of specifications in terms of the development requirements
2
Developing Code
 Develop SQL Scripts
 Stored Procedures
 Functions
 ETL (Extract, Transform & Load) processes
 Code automation
3
Testing
 Test SQL Scripts, Stored Procedures, Functions and ETL (Extract, Transform & Load) processes to business requirement.
 Monitoring and confirming of procedures and processes after implementation to ensure correctness
 Efficient Testing, Minimum Errors and Bug Free
4
Implementation
 Deploy and Integrate SQL Scripts, Stored Procedures, Functions and ETL (Extract, Transform & Load)
 Manage the physical implementation to conform with physical models and source data to target mapping
5
Documentation
 Complete change controls
 Documenting of SQL processes
Requirements
REQUIRED MINIMUM WORK EXPERIENCE
 3 - 5 years SQL development experience
 SQL Server 2000 – 2008 experience (2012-2014 optional)
 Experience in SsRs, SSIS, SSAS packages
 Experience in SQL programming and an in-depth knowledge of the SQL Language including T-SQL
 Experience in the creation of stored procedures, views, triggers, cursors and functions
 The ability to read and understand existing SQL scripts, maintain them and enhance them if required
 Ability to create / schedule and monitor SQL jobs
 Knowledge of FTP (File Transfer Protocol) advantageous
 Knowledge of BCP (Bulk Copy) advantageous
 The ability to write optimal SQL codes accurately and timeously
 The ability to automate procedures

Technical:
 Business Acumen
 Quality Assurance
 Attention to detail
 Planning & Prioritising Skills
 Problem solving & analytical skills
Behavioural:
 Results and deadline driven
 Resilience
 Team-player
 Multi – tasking
Job Closing Date 28/07/2017
Share on