Junior SQL Data Engineer
Posted Updated 5
views
Summary
The Junior SQL Data Engineer will develop and optimize ETL processes, manage database performance, and create BI dashboards using tools like SQL, MySQL, Looker, and Tableau. The role involves collaborating with teams to ensure data quality and maintaining system documentation.
Minimum requirements:
- 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.