Junior SQL/MYSQL Data Engineer

Boardroom Appointments; Cape Town; On-site; ZAR 360,000 - 540,000; Full time

Job summary

Boardroom Appointments seeks a Junior SQL/MYSQL Data Engineer to extract insights for reporting and decision-making. You will develop and maintain ETL workflows and complex queries to support BI needs, with Looker/Tableau proficiency as a plus.

You will build data models, ensure data quality, and collaborate with teammates to deliver scalable data solutions while maintaining documentation and data integration processes.

Qualifications

• 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.
• Team-player
• Proactive
• Solution-driven
• Ready to be accountable
• Have a proven multi-tasking record
• Stress-tolerant and great at shifting priorities as demands change

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.

Skills

SQL

Data modelling

ETL development

Data architecture

BI tools

Analytical skills

Communication

Teamwork

Proactive

Multi-tasking

Stress-tolerant

Tools

Looker

Tableau

Power BI

Job description

About the job Junior SQL/MYSQL Data Engineer

Key purpose:

We are seeking a talented SQL/MYSQL Data Engineer to extract valuable insights for reporting and decision-making processes. This role involves developing and maintaining complex database and ETL solutions to support business intelligence (BI) and reporting requirements. Experience in BI visualisation tools like Looker and Tableau would be a significant advantage.

Duties and 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.

Qualifications and experience:

• 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.
• Team-player
• Proactive
• Solution-driven
• Ready to be accountable
• Have a proven multi-tasking record
• Stress-tolerant and great at shifting priorities as demands change