The Data Engineer will be responsible for the investment team database architecture, data flow and data processes. This includes efficiently receiving, transferring, processing, analyzing, and integrating 3rd party systems for investment research and business operational processes. Strong programming skills, particularly in Python and SQL are therefore essential. Solid experience managing and analysing large amounts of data is a must. Experience with version control and database solutions is necessary as well. The person will need to follow a collaborative team approach that adheres to the Prescient value framework.
DUTIES & RESPONSIBILITIES
Data Engineering:
Design and develop scalable data pipelines and ETL (Extract, Transform, Load) processes to collect, process, and integrate data from various sources into a centralized data warehouse or data lake.
Implementing data models, schemas, and database structures to organize and optimize data storage for efficient data retrieval, writing and analysis
Collaborating with quantitative and analysts to understand their data requirements and provide them with the necessary infrastructure and tools for data exploration, analysis, and visualization
Ensuring data quality and consistency by implementing data validation, cleaning, and transformation procedures.
Monitoring and maintaining the performance, availability, and security of data systems, including database servers, data warehouses, and data processing frameworks
Troubleshooting and resolving data-related issues and performance bottlenecks in collaboration with the investment teams
Evaluating and integrating new data technologies, tools, and frameworks to improve data infrastructure and processing capabilities
Documenting data pipelines, workflows, and technical specifications to facilitate knowledge sharing and maintain system
Keeping up-to-date with industry trends, best practices, and emerging technologies in the field of data engineering
General:
Assist and collaborate on team wide projects
Contribute to the analytics platform to know what is required from a Data Engineering perspective
Assist and investigate ad-hoc data related queries
REQUIRED EXPERIENCE
Up to 3 years’ experience with a specific focus in database management, data analysis and have produced ETL processes at scale are essential.
Basic understanding of financial instruments and markets
Exceptional skill and experience in Python and SQL
Linux server administration
Git version control
REQUIRED QUALIFICATIONS
University Post Graduate Degree (Computer Science/Information Systems/Maths/Stats/Business Science/Actuarial)
Strong programming skills in Python and SQL
KEY COMPETENCIES
Outstanding organization skills
Excellent interpersonal skills, excellent communication skills oral and written
Aptitude in decision-making and problem-solving
Strong work ethic, self-motivated, driven and results oriented
Ability to listen and respond to new ideas, input and diverse perspectives
High levels of self-confidence, assertive as well as healthy levels of EQ
Energetic problem-solver
Structured work style, attention to detail and accuracy is of the utmost importance
WHY THIS ROLE?
An exciting role, offering fantastic growth and exposure, as you form part of a team in a leading systematic investment framework.
Prescient only conducts financial services with clients via formal processes and communication channels. Note that Prescient does not sell or advertise or solicit any business or investment opportunities via soft channels such as WhatsApp, Facebook, Instagram or Text Messaging.
Please be cautious of individuals fraudulently attempting to solicit business or investments by impersonating or claiming to be an associate or representative of Prescient, who are selling or advertising investment opportunities. Please ensure to contact Prescient directly in the event of someone soliciting or attempting to solicit investments from you.
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.