Location: Sandton
We are seeking an experienced Senior SQL Developer / Programmer to join our team as a Team Lead. This role requires an individual who can oversee all aspects of data management and development for the CEM platform. As a Team Lead, the candidate will be responsible for project management, documentation, timelines, staff and vendor oversight.
The successful candidate must have a strong focus on SQL and be able to integrate their skills into the team while also expanding their SQL on Prem and SQL Azure skills. Responsibilities include analyzing, designing, and implementing various databases and structures within the CEM environment. This role will require programming experience in C# to deliver key components and functions.
The Senior SQL Developer / Programmer will be responsible for writing optimized SQL queries for integration with other applications, creating database triggers for use in automation, and maintaining data quality. They will also oversee database security, create stored procedures, and perform data-related implementation tasks such as provisioning data storage services, ingesting streaming and batch data, transforming data, and implementing security requirements.
This role can be divided into three main areas: data management, development, and platform. The successful candidate will manage the database platform and associated services, develop and maintain databases, and oversee the maintenance of the database and database servers. They will also be responsible for developing the necessary backend processes required to fulfill the CEM platform duties, services, and requirements, as well as managing and optimizing the data pipeline architecture within the Microsoft Azure platform.
The Senior SQL Developer / Programmer will provide technical input into cloud tools and database designs, develop and revise data management plans, and ensure that all data-related SOPs are developed, implemented, and maintained. They will monitor and evaluate the progress of data management for respective projects, compile monthly Project/EXCO/MANCO reports as required, and oversee reporting of any data quality and data errors reported by Data Unification process and other data testing mediums.
Requirements
- Bachelor's degree or relevant technology advanced diploma at NQF level 7
- Microsoft Certified: Azure Administrator Associate qualification (AZ-103)
- Microsoft Certified: Azure Data Engineer Associate (DP200 - 201)
- MCITP/MCSE or equivalent certifications/experience demonstrating cloud/networking/infrastructure knowledge
- 10+ years of experience in a Data Engineer role
- Strong working SQL knowledge and experience working with relational databases, query authoring (SQL), and familiarity with a variety of databases.
- Experience building and optimizing 'big data' data pipelines, architectures, and data sets
- Strong analytic skills related to working with unstructured datasets
- Experience supporting and working with cross-functional teams in a dynamic environment
- Strong project management and organizational skills
- Knowledge of Oracle, Visual Basic, or C# will be an advantage
- Thorough with good attention to detail, ordered, and systematic with a tendency to adhere to protocols
- Good administrative skills are required, together with working knowledge of Microsoft Office and database packages
- Able to work to deadlines and demonstrated data capturing speed and accuracy
Please be advised that you will be contacted by Medipath Healthcare Recruitment within 14 days should we wish to proceed with your application. Similarly, if you are not contacted by Medipath Healthcare Recruitment, please accept your application as unsuccessful. Your CV will automatically be added to our database and we could be contacting you should a suitable position arise.
