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.

#J-18808-Ljbffr

ACACIA Facility Services jobs

Data Engineer (Prescient Fund Services)