About Us

What We Offer

Funds

News & Resources

About Us

What We Offer

Funds

News & Resources

Contact

Invest Now

Vacancies

Data Engineer (Prescient Fund Services)

Reporting Line:

CIO

Location:

Westlake, Tokai, Cape Town

Business Unit:

Prescient Fund Services
Apply Now

The analyst / specialist will work across a range of projects, alongside the project management office, developers, analysts and IT partners to ensure that requirements are accurately translated into systems developments within PFS. The role will focus on designing, building and supporting data integration solutions between multiple internal and external systems, across a variety of data types and network applications.

DUTIES & RESPONSIBILITIES

  • Designing, building, and implementing processes for data integration to and from systems/databases, both within internal system stacks and external vendors
  • Conduct data analysis to understand and inform integration requirements
  • Understand the complexities and interdependencies of the various systems
  • Working with stakeholders to perform unit, system, and regression testing
  • Developing documents to detail the logic and testing processes
  • Be able to troubleshoot and provide production support to business users
  • Develop new solutions for ETL workflows
  • Technical testing and implementations
  • Ensures causes of ETL workflow issues are analysed and resolved
  • Works with stakeholders to implement required ETL changes
  • Delivering tasks within specified time frames
  • Communicates technical concepts to stakeholders
  • Participates in workshops to problem solve technical requirements
  • Create and present solutions that demonstrates a deep understanding of and ability to design and implement data integration workflows for all systems at Prescient
  • Solve complex problems independently across the data architecture at Prescient

REQUIRED EXPERIENCE 

  • Relevant work experience – 6-8 years’ experience in Business/Systems Analysis / Integration gained within Financial Services with a strong understanding of Investment Management/Fund Services/Investment operations
  • The position requires an intermediate knowledge in SQL, MS SQL, and Oracle
  • Experience with the use of ETL tools and processes
  • Strong Excel skills
  • The following is advantageous:
    • Conceptual understanding of APIs and integration of APIs
    • Basic level of programming skills
    • Exposure to cloud technology (Azure / AWS)

REQUIRED QUALIFICATIONS AND SYSTEMS EXPERIENCE

  • Bachelor’s Degree or equivalent in Commerce/IT/Computer Science/Engineering

KEY COMPETENCIES

  • Strong analytical thinking, systems thinking and problem-solving skills
  • ETL Process Modelling
  • Creative, critical and lateral thinking abilities
  • Ability to follow through with tasks and know when to hand over a challenging problem or seek assistance.
  • Must be able and willing to learn and adapt
  • Good understanding of the financial data
  • Strong Oral and Written Communication skills
  • Strong technical skills
  • Must be a team player
  • Strong ETL design, analysis and implementation skills
  • Good experience in the role of an Integration Specialist and be familiar with DAMA-DMBOK (Data Management Body of Knowledge)
  • Must also be capable in using specialized tools such as Xceptor / Pentaho (or similar) and SQL
  • Attention to detail
  • Strong planning and self-management skills

WHY THIS ROLE?

This is a fantastic opportunity to join a highly talented team of Project specialists who possess excellent knowledge of the market. You can learn from the best, be exposed to interesting and challenging projects and take your career to new heights.

INTERESTED?
APPLY NOW

Vacancy Applications

PRESCIENT GLOBAL

WE ARE A MULTINATIONAL BUSINESS.

South Africa

  • South Africa
  • China
  • Ireland

Enquiries

+27 21 700 3600

Please enter to search or esc to cancel

SUGGESTED TERMS

  • Investor Application
  • Stockbroker
  • Factsheet
  • Retirement Fund Solutions

Where exceptional expertise meets meticulous financial services