Role Overview
We are looking for a motivated and analytical Data Engineer Intern with a basic understanding of Microsoft SQL Server, SQL, databases, data analytics, data science and big data concepts. The candidate will work closely with the technical team to support database management, data processing, analysis and data engineering activities while gaining practical exposure to Microsoft SQL Server and related data technologies.
Responsibilities
- Write, execute and optimise SQL queries using Microsoft SQL Server for data retrieval and manipulation.
- Assist in data extraction, transformation and loading (ETL) processes.
- Perform data cleaning, validation and preprocessing to maintain data accuracy and consistency.
- Analyse datasets to identify trends, patterns and meaningful insights, and assist in developing reports and dashboards.
- Support database management, data integration, data processing and workflow automation.
- Assist in developing and maintaining SQL queries, stored procedures, views and functions while collaborating with the technical team on database and data engineering projects.
Requirements
- Understanding of relational databases, DBMS concepts, database design and normalisation, with a focus on Microsoft SQL Server.
- Basic to intermediate knowledge of MS SQL Server and T-SQL (Transact-SQL).
- Familiarity with SQL Server Management Studio (SSMS), stored procedures, views, functions and query optimisation.
- Understanding of ETL processes, data pipelines, data integration and data manipulation.
- Basic knowledge of database reporting and data visualisation; familiarity with Power BI or SSRS (SQL Server Reporting Services) is an advantage.
- Knowledge of MySQL and PostgreSQL is an added advantage. Basic awareness of Big Data technologies such as Hadoop and Spark is also beneficial.