SQL Developer (Fixed Term Contractor) (8233) at Allan Gray Proprietary Limited

Job Responsibilities

• Work as part of a larger IT team using the Scrum methodology to align with the strategic objective of the business
• Develop integration solutions using SQL and other vendor integration tools (Markit EDM).
• Develop reporting solutions; write SQL stored procedures to manipulate the data supplied by the source system and prepare it for reporting.
• Design and create SSRS report definitions to present the data.
• Solid understanding of the SDLC
• Develop and implement performant stored procedures and functions using T-SQL
• Ability to interpret requirements and deliver timeously

Requirements

• 4-5 years SQL experience (stored procedures, UDF’s, T-SQL, performance tuning and optimization, RDBMS, error handling and logging, etc.) is essential
• Working experience of SSRS is essential
• Working knowledge of SSAS would be advantageous
• An understanding of dimensional databases would be advantageous
• PostgreSQL experience would be advantageous

Skills and Competencies

• Attention to detail and quality of work.
• Ability to take initiative and responsibility.
• Strong analytical skills.
• Good communication
• Provide accurate estimates
• Present solutions clearly
• Ability to work well under pressure and meet deadlines without sacrificing quality.

Education

• Analytical degree or diploma is advantageous
• Knowledge of financial concepts and terms advantageous
• Financial Services industry experience would be an advantage.