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 & RESPONSIBILITIESDesigning, building, and implementing processes for data integration to and from systems/databases, both within internal system stacks and external vendorsConduct data analysis to understand and inform integration requirementsUnderstand the complexities and interdependencies of the various systemsWorking with stakeholders to perform unit, system, and regression testingDeveloping documents to detail the logic and testing processesBe able to troubleshoot and provide production support to business usersDevelop new solutions for ETL workflowsTechnical testing and implementationsEnsures causes of ETL workflow issues are analysed and resolvedWorks with stakeholders to implement required ETL changesDelivering tasks within specified time framesCommunicates technical concepts to stakeholdersParticipates in workshops to problem solve technical requirementsCreate and present solutions that demonstrates a deep understanding of and ability to design and implement data integration workflows for all systems at PrescientSolve complex problems independently across the data architecture at PrescientREQUIRED EXPERIENCERelevant 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 operationsThe position requires an intermediate knowledge in SQL, MS SQL, and OracleExperience with the use of ETL tools and processesThe following is advantageous:Conceptual understanding of APIs and integration of APIsBasic level of programming skillsExposure to cloud technology (Azure / AWS)REQUIRED QUALIFICATIONS AND SYSTEMS EXPERIENCEBachelor's Degree or equivalent in Commerce/IT/Computer Science/EngineeringKEY COMPETENCIESStrong analytical thinking, systems thinking and problem-solving skillsCreative, critical and lateral thinking abilitiesAbility 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 adaptGood understanding of the financial dataStrong Oral and Written Communication skillsStrong technical skillsMust be a team playerStrong ETL design, analysis and implementation skillsGood 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 SQLStrong planning and self-management skillsWHY 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.
#J-18808-Ljbffr