Apply for Job

Systems Analyst / Designer ll

Vacancy Details

Reference No.



Our client in the banking industry is looking to employ a Systems Analyst / Designer ll to develop high level end to end design and Macro design in the context of the high-level solution architecture to realise the business requirements. To perform consulting services to find suitable solutions to various business requirements.


  • Registration of files in the Data Warehouse Dev, QA and production environments
  • Develop, test and implement programs from supplied specifications to extract, transform and load data into various data warehouse marts using predominantly SAS, SQL and Netezza tools.
  • Perform root cause analysis and impact assessments and implement solutions
  • Peer review and Quality assure the output of colleagues
  • Optimisation of programs and applications
  • Perform a technical lead role and mentor and coach junior staff
  • Support all production-related incidents to ensure that tight daily SLAs are met
  • Professional application and demonstration of acquired knowledge across technologies, and/or in-depth speciality in a specific technology – e.g. SAS, and SQL
  • Actively participate in project teams as a core project member (incl cross functional forums and external parties)
  • Take responsibility for incident fixes and manage to closure (focus on live environment)


Essential Qualifications - NQF Level

  • Diploma/Degree in IT / Programming

Preferred Qualification

  • BCom Information Technology

Minimum Experience Level

  • Minimum 4 years’ experience in SAS, advanced macros, and SQL
  • Interpret the business requirements in order to create technical specifications across projects
  • Deliver and coordinate coding work tasks according to technical specifications
  • Accountability to ensure end to end testing through to sign off to ensure fault free production implementation
  • Good knowledge of SAS, including advanced macros, and SQL
  • Exposure to scheduling tools
  • Advanced debugging ability
  • Advance understanding of testing practices
  • Good understanding of data warehouse concepts
  • Knowledge of appliance technology such as Netezza will be a big plus
  • Exposure to IBM Banking Data Warehouse Model - preferably
  • Problem solving skills

Behavioural Competencies

  • Collaborating
  • Compelling Communication
  • Decision Making
  • Driving for Results
  • Influencing
  • Innovation
  • Technical/Professional Knowledge and Skills

Kindly note, if you have not heard from us within two weeks of your application please consider it unsuccessful.

Position Type


Work Level



Market Related


Banking/Finance And Investment

Salary Type



Cost To Company

Affirmative Action


Geographic Location

Gauteng - JHB North