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 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 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 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 Nationality Position Data Engineer (Prescient Fund Services) Your CV Your Academic Transcript By applying for a role at Prescient, you explicitly acknowledge and understand, that we, our appointed third-party service providers whom we utilise to facilitate requisite background checks, verifications and screenings, will collect and process your personal information. For more information on the type of data that we will collect and process, either in-house or by our third party appointed service providers, please click here to access our Group Data Privacy Policy. Retention of your personal information is governed by the Prescient Retention Policy. Notice to Visitors () This website is not intended or permitted to be accessed or used by you if you are prohibited from doing so under the applicable laws and regulations of your country of residence and/or the country in which you are viewing this website. The content contained in this website is for information purposes only and does not constitute an offer or an invitation to subscribe or make use of any service or investment by a person, whether natural or legal, which is resident or situated in any jurisdiction where such offer or invitation would be unlawful, or in any jurisdiction in which Prescient Holdings, including all of its subsidiaries and associates("Prescient"), is not qualified to make such offer or invitation, or to persons to whom it would be unlawful to make such offer or invitation. By clicking "I AGREE" below, you consent to the terms and conditions above and you confirm and agree that:. you are not a person prohibited under the laws of your country from accessing the information on the investment products and services referred to herein; by accessing this website you will not contravene or cause Prescient to contravene any law that seeks to regulate the promotion of financial products either in the country of your residence or in the country in which you are viewing this website; and any investment which you may place with or through Prescient is based solely on your own enquiry and initiative and is not due to any offer or solicitation by Prescient. Where exceptional expertise meets meticulous financial services #J-18808-Ljbffr