View Profile
Personal Profile
Career Summary
Job Skills
Software Skills
Business Skills

Match
History
Upload/Send CV

SQL Developer and Data Analyst

Position Details

Job ID:

3505

Last Updated (mm/dd/yyyy):

2012-09-19 11:16:09 AM

Position category:

Position Name:

SQL Developer and Data Analyst

Similar Experience:

42-48

Total Experience:

42-48

Project Location:

JHB

Job Type:

Contracting/Permanent

Pay:

R450k pa neg

Academic Qualification/s:

Information Technology Qualification

Industrial Qualification/s:

TSQL ETL SSIS XML

Position Active:

No

Relocation Assistance:

No

Workpermit Assistance:

No


Job Description:

Job Description SQL Developer and Data Analyst


Immediate Supervisor Head of Software Development & Architecture


FAIS Affected Role No

Experience And Skill Required

Experience

A Formal Qualification or Certification in Information Technology, with at least 2 to 3 years experience in database development and data modeling. A minimum 2 to 3 years experience in Microsoft SQL Server development including TSQL,SSIS and Reporting Services optional and preferably in the Financial Services Industry. Experience in.Net development or SharePoint a bonus.

Skills Required

  1. Good knowledge of Microsoft TSQL including stored procedures, triggers, indexing and remote data access

  1. Good understanding of Relational Database design principles

  1. Good understanding of mechanisms of ETL, data import and export including SSIS, Linked Servers and XML

  1. Ability to complete required documentation including Technical Requirements, Change Requests, ERD, DFD.

  1. Ability to communicate with both technical and non-technical people verbally and in writing

Key Responsiblies & Daily Duties

Key Responsibilities

  • Maintain existing and develop new ETLs

  • Assist in optimizing performance of databases

  • Assist in ongoing documentation of organizational data dictionary, data flows

  • Assist with data purification and enrichment exercises

  • Assist with development of reports, queries and extracts for use by business

Daily Duties

  • Monitor, support and maintain existing bespoke databases and ETLs

  • Develop new ETLs and data repositories

  • Monitor network, application and security logs


Format: Skill Description (Rating 1-5,Experience in Months)
Rating: 1-Beginner, 2-Below Average, 3-Average, 4-Above Average, 5-Expert

Required Job Skills:

Required Software Skills:

Required Business Skills: