Data Development Engineer (Fixed Term Contract - 6 months) Competitive

AfroCentric Group; Roodepoort; On-site; ZAR 500,000 - 700,000; Full time

Job summary

AfroCentric Group in Roodepoort is seeking an experienced ETL Developer to design, code, and optimize ETL pipelines for the data warehouse. The role focuses on delivering robust data integration, and ensuring data accuracy and performance.

The position requires strong SQL/PLSQL skills, data modelling expertise, and the ability to analyze system changes, implement efficient solutions, and support BI data loads with a focus on quality objectives, SDLC compliance, and cross-team collaboration.

Qualifications

• 5-10 years of programming experience with data warehousing.
• SQL/PLSQL knowledge is essential.
• ETL tool experience with DataStage 8.2+ and UNIX scripting.
• Data modelling knowledge preferred and SDLC awareness.

Responsibilities

• Design, code, debug ETL programs to meet business needs.
• Analyse effects of new functions on existing systems.
• Compile and run test cases per the SDLC and perform in-house testing.
• Develop practical ETL solutions; support BI data loads and performance tuning.
• Provide specialist input to improve efficiency and data quality.

Skills

SQL/PLSQL

Data warehousing

Data modelling

System design

Attention to detail

Problem solving

Customer focus

Communication

Education

Diploma/Degree in IT

Data-related qualifications

Tools

DataStage 8.2+

UNIX scripting

Job description

ETL Developer Job Description

The purpose of the ETL Developer is to develop extraction, translation, and loading jobs which will populate the Data Warehouse. Develop and enhance the back-end of the data warehouse to satisfy specified and agreed user requirements in conformance with standards, time, and cost parameters agreed for each project/request.

Duties & Responsibilities

Accountabilities:

1. Design, code, debug, and correct programs to ensure business requirements are met.
2. Analyse the effect of new functions on the existing system.
3. Compile test cases according to System Development Lifecycle methodology and conduct thorough in-house testing per operational procedure.
4. Implement practical solutions that use the specialist and departmental systems and processes.
5. Provide specialist input and recommendations to improve efficiency, compliance, and quality objectives related to the area of specialization.
6. Identify problems and develop and propose solutions to present to appropriate leaders or stakeholders.
7. Ensure day-to-day operational support required from the area of specialization is provided to enhance performance.

Cost containment:

1. Support the identification, development, and implementation of cost-effective processes to increase efficiency and reduce cost drivers related to the area of specialization.
2. Continuously review cost/benefit and Return on Investment within the area of specialization.

Drive customer-centricity:

1. Maintain a high level of impact on other departments to support improved delivery.
2. Continually increase understanding of client and stakeholder needs, satisfaction, and service delivery.

Knowledge management:

1. Ensure that adequate knowledge regarding specialization is shared as required and maintained within the research library.
2. Provide advice and/or training as required.
3. Maintain, develop, and implement specialist knowledge within the day-to-day operations of the organization.

Maintain expertise level:

1. Be a member of related professional bodies.
2. Ensure CPD (Continual Professional Development) or similar accreditation requirements are met annually to ensure maintained specialist accreditation.

Network key relationships:

1. Engage with and provide support to the established network of internal and external expert resources and partners.

Specialist support to projects:

1. Provide specialist expertise and ensure best practice related to specialization is implemented in projects when required.
2. Conform to project management disciplines when participating in projects.
3. Represent department or project on appropriate committees related to the area of specialization.

Specific deliverables:

1. Design, development, and implementation of ETL pipelines.
2. Debug and correct programs to ensure business requirements are met, including new and maintenance work.
3. Performance tuning of long-running queries and recommending performance improvement strategies.
4. Performing data extracts.
5. Support implemented BI solutions by monitoring data loads, addressing user questions concerning data integrity, doing performance tuning, archiving strategy, and communicating functional and technical issues.
6. Analyse the effect of new functions on the existing system.
7. Compile test cases according to System Development Lifecycle methodology and conduct thorough in-house testing per operational procedure.
8. Ensure day-to-day operational support, identify problems, and propose solutions to be presented to appropriate leaders or stakeholders.

Competency Requirements

Attribute:

1. Credibility: Lead with integrity and trust others as you would like to be trusted.
2. Entrepreneurship: Take chances to continuously improve our Customer's experiences.
3. Influence: Engage with Customers and colleagues to advance the organization's welfare.
4. Collaboration: Build work-related networks and share knowledge with colleagues.
5. Ownership: Make critical decisions based on what's right for AfroCentric and Customers.

Knowledge:

1. Knowledge and application of the System Development Life Cycle (SDLC) methodology.
2. Knowledge and application of relevant legislation.

Skill:

1. Task Management.
2. Data modelling and evaluation.
3. Communication Skills.
4. Business Writing Skills.
5. System design and development skills.
6. Attention to Accuracy and Detail.
7. Problem solving and decision making skills.
8. Customer Focus.
9. Numerical Ability.

Desired Experience & Qualification

Experience: 5-10 years’ experience in programming, understanding of database design and system analysis. Minimum of 5-10 years Data Warehousing experience. SQL/PLSQL knowledge essential. ETL Tool knowledge (DataStage 8.2 and above). Data Modelling Tool Experience preferred. Basic UNIX scripting.

Qualifications: 3-4 Years Diploma/Degree in Information Technology, Computer Science or data-related qualifications.

Package & Remuneration

Competitive.