Data Engineer (Python & SQL) at Datafin Recruitment
ENVIRONMENT:
Be responsible for the investment team database architecture, data flows and data processes of a dynamic provider of cutting-edge financial solutions in Tokai looking for a highly qualified Data Engineer qualified. Your role will be to effectively receive, transfer, process, analyze and integrate third party systems for investment research and business operational processes. You should possess a postgraduate university degree in computer science/information systems/mathematics/statistics/business sciences/actuarial science with up to 3 years of experience with a particular focus on database management, data analysis data and have produced ETL [Email Address Removed] MUST have strong Python and SQL programming skills, Linux server administration, Git, basic understanding of financial instruments and markets, and solid experience managing and analyzing large amounts of data.
FUNCTIONS:
Database and ETL –
- Design relational data tables to meet current data needs and anticipate future use cases.
- Optimize table structures for scale and high frequency reads/writes.
- Optimize stored procedures for large datasets and high-frequency calls.
- Write ETL scripts for data ingestion and transfers as well as report generation using stored procedures and Python scripts.
- Integrate systems data communication.
Python-
- Data analysis and report creation using Python Pandas, Numpy, Plotly and Scikit-Learn.
- Python web frameworks.
- ETL script.
- Create and add existing internal Python modules.
- Automate data quality checks.
Systems –
- Linux server administration and bash scripting.
- Git version control.
- Understanding and implementation of DevOps fundamentals.
- Investigate new technologies to improve the data flow framework.
General –
- Assist and collaborate on team-wide projects.
- Process documentation and version control.
- Implementation of systems and frameworks.
- Ensure that database services are always available.
- Manage ad hoc data query surveys.
TERMS:
Skills –
- Postgraduate university degree (computer science/information systems/mathematics/statistics/business sciences/actuarial science).
Experience/Skills –
- Up to 3 years of experience with a particular focus on database management, data analysis and large scale ETL process production is essential.
- Exceptional skills and experience in Python and SQL.
- Basic understanding of financial instruments and markets.
- Linux server administration.
- Git version control.
ATTRIBUTES:
- Exceptional organizational skills.
- Excellent interpersonal skills, excellent oral and written communication skills.
- Aptitude for decision making and problem solving.
- Strong work ethic, self-motivated, self-motivated and results-oriented.
- Ability to listen and respond to new ideas, contributions and diverse perspectives.
- High levels of self-confidence, assertive and healthy EQ levels.
- Energetic problem solver.
- A structured work style, attention to detail and precision are of the utmost importance.
Although we would really like to respond to every application, if you are not contacted for this position within 10 working days, please consider your application unsuccessful.
COMMENTS:
When applying for a job, make sure you meet the minimum job requirements. OnlySouth African citizens will be considered for this role. If you are not at the stated location of any of the jobs, please note your relocation plans in all job applications and correspondence. Please email a word copy of your CV to [Email Address Removed] and mention the reference numbers of the works. We have a job listing on [URL Removed] Datafin IT Recruitment – Jobs in Cape Town.
Desired skills:
Find out more/Apply to this position