Data Engineer - Prescient Fund Services

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 demonstrate 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 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