As an Intermediate SQL Developer, you'll focus on building and maintaining ETL processes to ensure smooth data integration and warehousing. This role is ideal for someone with a solid understanding of data integrity and security practices.
In this role, you'll be responsible for building and maintaining reliable ETL processes using SQL Server Integration Services (SSIS). Your main goal will be to ensure effective data integration and data warehousing, which are crucial for the company's data operations. You'll also implement data integrity constraints and uphold compliance with data security practices, including the Protection of Personal Information Act (POPIA). This position requires a solid understanding of relational database design and basic data modeling techniques.
Your daily tasks will involve working with various data sources to extract, transform, and load data into the data warehouse. You'll collaborate with other team members to ensure that the data is accurate and accessible for analysis. Additionally, you may be involved in optimizing existing ETL processes and troubleshooting any issues that arise.
This role suits someone who is detail-oriented and has a strong technical background in SQL and data management. If you have relevant Microsoft certifications, such as the Azure Database Administrator Associate or legacy SQL Server certifications, it will be advantageous. A solid understanding of data integrity and security practices is essential, as is experience with relational database design and normalization.
Overall, this position offers a great opportunity for a mid-level professional looking to advance their career in data engineering while contributing to a company that values data integrity and compliance.
You'll be taken to the original listing on PNet to apply.