SQL Developer at Lulalend

OVERALL PURPOSE

We are looking for a SQL Developer to join our team. 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

THE COMPETENCIES WE’RE AFTER

• Clear and concise communication and documentation skills
• Process orientated with experience in Agile
• Team-player with a desire to collaborate
• Critical thinking skills

THE SKILLS AND EXPERIENCE WE’RE LOOKING FOR

• 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