Cape Town
A fintech company who build innovative fintech products have a SQL Developer role that has opened within their medium sized company.
The organisation supports small and medium enterprises with the funds to help them grow, and are looking for candidates who love to make a difference and change the game in building the next generation of business friendly fintech products.
The more businesses that succeed, the more jobs, money, and opportunities for all South Africans
Overall Purpose
As the SQL Developer, you will be tasked with implementing and maintaining data models with the goal of improving data reliability and quality, ensuring scalable data pipelines are working smoothly.
As a member of the Data Science team, your primary focus will be to combine raw information from different sources to create consistent and consumption-ready formats.
More specifically, you will need to construct and test architectures that enable data extraction and transformation for modelling.
Responsibilities will include :
Develop and maintain scalable data pipelines and systems
Develop, maintain and ensure utmost quality of our Data Warehouse
Monitor production runs to ensure accuracy and on-time delivery of data to reports
Combine raw information from different sources
Analyse and organise raw data
Explore ways to enhance data quality and reliability, including optimising current SQL queries
Refactor code in order to maintain neatness in the data engineering repos
Provide input around how we can improve tools and processes already in place
Enhance existing data collection procedures to include information that is relevant for building analytical systems
Co-ordinate, build features and produce bespoke data sets for consumption by machine learning algorithms
Identify opportunities for data acquisition that is relevant for building analytical systems
Drive best practices around data collection, knowledge sharing and data governance, including contributions to data catalogue and documentation of work
Collaborate with Data Scientists, Data Analysts and Data Engineers on several projects
REQUIREMENTS
Degree in Computer Science, IT, or similar field
3+ years experience with PostgreSQL / MS SQL and Python
Strong SQL skills
Experience in shipment of data via ETL, API, etc.
Experience with source code and version control
Excellent understanding of databases, data structures and concepts
Experience with Agile methodologies
The Competencies Were After
Clear and concise communication and documentation skills
Process orientated with experience in Agile
Team-player with a desire to collaborate
Critical thinking skills 
