Seeking a Senior SQL Developer to design, develop, and optimize data solutions, focusing on ETL processes, data warehousing, and reporting. The role requires strong SQL and SSIS skills, collaboration with various teams, and adherence to best practices. Experience with data warehouse design, Git, and APIs is advantageous.
This position calls for a Senior SQL Developer to spearhead the design, development, and optimization of robust data solutions . These solutions are vital to fostering superior customer experiences and driving operational efficiency across the organization.
The Senior SQL Developer will work in close collaboration with diverse teams, including business stakeholders, technology experts, and product owners, to implement high-quality ETL processes, data warehouse solutions, reporting platforms, and comprehensive analytics tools. The core objective of this role is to ensure the creation of scalable, secure, and maintainable data solutions, all while adhering to industry best practices and organizational standards. The successful candidate will be expected to translate business needs into technical specifications, including data models, ETL logic, and reporting structures, ensuring a clear understanding of requirements across the team. Furthermore, the role involves building and maintaining enterprise data warehouse solutions and participating in architectural design decisions. \The Senior SQL Developer will play a pivotal role in the design and implementation of ETL solutions, utilising SSIS or similar tools, and ensuring accuracy, performance, and maintainability throughout the process. The role also encompasses building and maintaining enterprise-level data warehouse solutions, including dimensional modelling and the continuous optimization of performance to handle large datasets effectively. This requires a deep understanding of data warehousing principles and the ability to apply these principles to create efficient and scalable data infrastructure. The responsibilities further extend to the implementation of version control using Git, fostering collaborative development practices, and conducting thorough code reviews to maintain the highest standards of code quality. Moreover, the role requires working with internal APIs to retrieve, transform, and load data into SQL Server environments, incorporating API-driven processes into SSIS packages where needed. Participation in Agile delivery processes, including sprint planning, daily stand-ups, and retrospectives, is also a critical part of the role. Documentation is crucial; the Senior SQL Developer must meticulously document technical solutions, processes, and data flows to ensure operational continuity and facilitate knowledge sharing across the organization. The ability to troubleshoot and optimize SQL queries and ETL processes is essential for maintaining data integrity and ensuring the efficient functioning of the data infrastructure. This is combined with the need to stay up to date with new features and best practices for SQL development and data warehousing to continuously improve and provide value. The ability to consume and integrate APIs (REST/SOAP) into SQL and SSIS processes is also highly valued, as is experience or knowledge of platforms such as Snowflake or IBM Cloud Pak for Data.\The ideal candidate will possess a strong track record in ETL design and development, with hands-on experience using SSIS or comparable tools. A solid understanding of data warehouse design, dimensional modelling, and experience working with large-scale database solutions is crucial. Proficiency in source control systems, specifically Git, and familiarity with CI/CD practices for data solutions are essential for effective collaboration and continuous improvement. Demonstrated problem-solving skills, including the ability to troubleshoot and optimize SQL queries and ETL processes, are highly valued. Experience integrating APIs (REST/SOAP) into SQL and SSIS processes is considered a significant asset. Knowledge or hands-on experience with Snowflake or IBM Cloud Pak for Data is viewed favorably. Candidates with experience in the financial services or investment platform industries are also encouraged to apply. The educational requirements include a Bachelor’s degree in Information Technology, Computer Science, Information Systems, or a related field, or a relevant diploma with extensive hands-on experience in SQL development, ETL processes, and data warehousing. Any Azure Data Engineer Associate or similar cloud data certifications are highly beneficial and would further strengthen the application
SQL Development ETL Processes Data Warehousing SSIS Data Solutions
South Africa Latest News, South Africa Headlines
Similar News:You can also read news stories similar to this one that we have collected from other news sources.
Senior SQL Database AdministratorIT Industry News. Daily.
Read more »
Senior Full Stack Developer -.NET / JavaScript | FULLY Remote (International) Senior Full Stack DeIT Industry News. Daily.
Read more »
Full Stack Developer (Senior) 0513IT Industry News. Daily.
Read more »
PowerBI and SQL Developer - IT-OnlineIT Industry News. Daily.
Read more »
PowerBI and SQL Developer - KwaZulu-Natal DurbanIT Industry News. Daily.
Read more »
Senior Enterprise Java Developer (API Development)IT Industry News. Daily.
Read more »