SQL Developer at Swift Momentum

Job description

A Cape Town based company is seeking a SQL Developer with at least 5 years’ experience to be responsible for developing and supporting integration and reporting solutions. An Analytical degree or diploma (ComSci, BBusSci or B.Com with IS/Actuarial, BSc (Eng, Math) or similar is essential. Exceptional skills in writing SQL for Microsoft SQL Server, including stored procedures and other T-SQL Querying is also required.

SALARY: R45-60K/m, CTC

DUTIES

• Responsible for developing and supporting integration and reporting solutions.
• Optimising SQL queries to improve performance.
• Work as part of a larger IT team using the Scrum methodology.
• Write technical specifications where required.
• Develop integration solutions using SQL and other vendor integration tools.
• 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.
• Assist with the migration of existing Crystal reports onto SSRS reports.
• Interact with business users, Business Analysts, Test Analysts and other developers to understand user requirements.
• Develop according to company quality and coding standards.
• Support existing integration solutions in the production environment by analysing problems reported by users and track down their cause through debugging techniques and discussion with other team members.
• Testing and deployment of new development.
• Provide 2nd line support for any production support issues.

REQUIREMENTS

• Analytical degree or diploma (ComSci, BBusSci or B.Comm with IS/Actuarial, BSc (Eng, Math) or similar is essential.
• Experience in analysing data and performing complex data manipulation using Microsoft SQL.
• An understanding of relational database structures.
• Exceptional skills in writing SQL for Microsoft SQL server, including stored procedures, UDF’s and other T-SQL Querying.
• Knowledge of financial concepts and terms and interested in attending courses to improve business knowledge. Financial Services industry experience would be an advantage.
• Experience in interacting with business users to understand their requirements and managing the implementation of system changes.

ATTRIBUTES

• Strong analytical & mathematical skills.
• Leadership skills.
• A positive, can-do attitude, willing to learn and persevere.
• Ability to work effectively as part of a diverse team and cross-train with team members.
• Good communication
• Willingness to take initiative and responsibility.
• Ability to meet deadlines and deal with pressure.
• Attention to detail and quality.