Jobs
SQL Developer
- Tags:
1. Purpose of the Position
This person will help with the design of the Data Warehouse. He will be responsible for report writing and delivery of the data to business users and design, as SQL programmer he will also help with the data analysis.
2. Major Responsibilities/ Accountabilities:
· Data transformation Programming (SSIS) and design (SQL, business Intelligence)
· Dimensional modeling (Data Warehouse design)
· Data analysis
· Report writing (end user applications)
· Data base architecture
· SQL Programming
3. Critical Success Factors of the Job:
| Key Competencies/ Skills | Relevant Experience |
| Data analysis | · Matric · MSQL programming · SSIS packages · Analysis services · Report writing |
| Critical Personal Characteristics | |
| · Practical · Results driven · Professional · Attention to detail · Open to new possibilities, and learning?s
| |
4. Job Skill Profile:-
| N/A: Not Applicable BA: Basic Appreciation WK: Working Knowledge FO: Fully Operational LE: Leading Edge | |||||||
| Functional Skills | Level | Comments | |||||
| N/A | BA | WK | FO | LE | |||
| 1. | Data analysis |
|
|
| X |
|
|
| 2. | Strong SQL programming skills |
|
|
| x |
|
|
| 3. | Knowledge and experience in SQL 2005 analysis services and ETL tools |
|
|
| x |
|
|
| 4. | Knowledge in reporting tools (reporting services) |
|
| x |
|
|
|
| 5. | Handle report requests |
|
| x |
|
|
|
| 6. |
|
|
|
|
|
|
|
| 7. |
|
|
|
|
|
|
|
| 8. |
|
|
|
|
|
|
|
| General Skills | Level | Comments | |||||
| N/A | BA | WK | FO | LE | |||
| 1. | Knowledge of business (at end of project) |
|
| x |
|
|
|
