Junior SQL Data Engineer

Boardroom Appointments; Cape Town; On-site; ZAR 600,000 - 900,000; Full time

Job summary

Boardroom Appointments in Cape Town seeks a SQL/MYSQL Data Engineer to design and optimise ETL processes, build robust data models and maintain data quality. You will craft reports and dashboards with Looker and Tableau, collaborate across teams, and ensure scalable data architectures.

The role requires strong analytical skills, problem solving and experience with PHP or Python for backend support.

Qualifications

• Proven work experience as a SQL/MYSQL Data Engineer or a similar role.
• Experience with data architecture, data modelling and ETL development.
• Knowledge of BI tools like Looker and Tableau.

Responsibilities

• Develop, implement and optimise SQL/MYSQL queries and procedures for ETL.
• Develop reports and dashboards using Looker, Tableau, Power BI, etc.
• Monitor system performance, troubleshoot and add features.
• Ensure databases meet business and performance requirements.
• Collaborate with team to integrate systems and improve data quality.
• Improve data foundation procedures, guidelines and standards.
• Maintain documentation for database design and data flows.
• Monitor data integrations with platforms like Facebook/Google.

Skills

SQL

MySQL

Databases

Data architecture

Data modelling

ETL development

BI visualization

Looker

Tableau

Power BI

Python

PHP

Analytical thinking

Communication

Teamwork

Job description

• Proven work experience as a SQL/MYSQL Data Engineer or a similar role.
• Proficient in SQL and experience with SQL Server, MySQL, or other databases.
• Experience with data architecture, data modelling, schema design, and ETL development.
• Knowledge of BI visualisation tools, such as Looker and Tableau.
• Strong analytical skills with the ability to collect, organise, analyse, and disseminate significant amounts of information with attention to detail and accuracy.
• Excellent problem-solving skills and ability to think critically.
• Strong communication skills and ability to work in a team-oriented environment.
• Basic development knowledge in backend programming languages such as PHP or Python.

Responsibilities:

• Develop, implement, and optimise SQL/MYSQL queries and procedures to extract, transform, and load (ETL) data.
• Develop reports and dashboards using BI visualisation tools, such as Looker, Tableau, PowerBi etc.
• Monitor system performance by performing regular tests, troubleshooting, and integrating new features.
• Ensure all database systems meet business and performance requirements.
• Collaborate with other team members to integrate systems and achieve high data quality and reliability.
• Improve data foundational procedures, guidelines, and standards.
• Maintain documentation for database design, process flow, and other relevant information.
• Monitor and maintain data integrations with platforms such as Facebook/Google.