Job Description

Data Engineer (AWS)

• Location: Hybrid in Sandton
• Seniority: Senior Level
• Salary: up to R 95 000 pm

Job Purpose:

Drive, design, and build scalable ETL systems for a big data warehouse. Deliver robust data for high-performing ML algorithms, predictive models, and real-time data visualization across the organization.

Core Responsibilities:

Systematic Solution Design:
Design ETL and data pipelines to meet business user specifications.
Ensure the highest data quality, accuracy, and completeness.
Translate business needs into architecture solutions.

Develop ETL Pipelines:
Implement ETL pipelines according to approved designs.
Utilize the most accurate data sources.
Validate data against financial records.

Data Governance and Quality Assurance:
Facilitate an understanding of data sources.
Build data quality metrics and conduct testing.
Ensure governance standards are upheld.

Customer-Centric Approach:
Maintain high customer satisfaction levels.
Adhere to Service Level Agreements (SLAs).
Communicate developments and manage expectations.

Effective Self-Management and Teamwork:
Maintain professionalism in all aspects.
Meet deadlines and resolve issues.
Accept constructive feedback and develop skills.
Support organizational core values.

Competency Requirements:

Knowledge:
Data Architecture, Data Modeling, and Data Pipelining.
Retail SAP architecture, IT environments, and emerging data trends.
Technology, SDLC, and Agile methodology.
Retail industry data models and IT governance.

Skills:
Analysis, judgment, and problem-solving.
Excellent written and verbal communication.
Proficiency in SQL, SAS Data Studio, AWS.
Python or R (or willingness to learn).

Behaviours:
Adapt to change and innovate.
Customer-oriented and excellence-focused.
Responsible, accountable, and a team player.
Continuous learning and research.

Qualifications:
3-year IT-related degree.
Postgraduate qualifications are advantageous.

Experience Requirement:
5-10 years of experience in data warehousing (Kimball methodology).
ETL process design and development.
SQL development and AWS experience.
Proficient in Python or R.
Experience in Retail, Financial Services, or Logistics.

Key Success Measures:

Systematic Solution Design:
Data requirements meet customer needs.
Develop ETL Pipelines:
Accurate data reports.
Timely delivery to stakeholders.
Informed stakeholders.

Data Governance and Quality Assurance:
Understanding of data by stakeholders.

Customer-Centric Approach:
Customer satisfaction levels within agreed parameters.
Adherence to SLAs.

Effective Self-Management and Teamwork:
Maintain professionalism.
Meet deadlines.
Support Core Values

Next steps:

Get in touch to discuss this opportunity in more detail, by September 22nd 2023. While we aim to respond to every application, unfortunately this is not always possible. If you have not heard from us within 7 days of your initial application, please regard your application as unsuccessful at this time.

Good luck!

Nigel Frank International