Data Team Lead

We are looking for a passionate Senior Data Developer or Team Lead to join our existing development team. This individual should be highly experienced in Microsoft SQL Server, ETL processes such as SSIS, and Data Warehousing. This individual must have a drive to lead a development team and be able to balance Team Management, Architecture, and Development.

As a Team lead delivering data solutions, you will play a vital role in contributing to our existing team of developers. Your role will be influential in guiding, contributing and developing a variety of technically challenging projects. Your role will be to provide architectural direction, team management, and development to our products and data requirements.

Primary Responsibilities for the Role
- Manage a team of Data Developers whose focus is the support, maintenance, and improvement of current data processes across various products and function,
- Guide a roadmap of data requirements with the Development Manage and Solution Owners to improve and modernise the way we ingest and process our data, as well as implementation of new data processes or architecture,
- Prioritise and plan sprint activities in collaboration with the Development Manager and Solution Owners.
- Help guide the design and refinement of ETL data processes for medium to large incoming data sets using SSIS and Microsoft SQL Server,
- Collaborate in a fast-paced team environment to understand, engineer, and deliver on business requirements,
- Strike a balance along the dimensions of feasibility, stability, scalability, and time-to-market when delivering solutions,
- Identify areas of technical debt and recommend solutions to improve the solutions,
- Work with multiple agile development teams that include testers, developers, and DevOps
- An openness to learn and implement new technologies outside of Microsoft SSIS such as Apache Kafka or AWS Glue.

Minimum Qualification and Experience Requirements

**Education & Qualification**
- Relevant tertiary qualification in Computer Science or related field.
- Azure or AWS accredited certification in Database Development or BI Development

***

**Skills and Competency**

***
- Provide prompt and accurate feedback to relevant stakeholders
- Establish standards or best practice for Data development approach and methodology.
- Document and update knowledge base, driving a learning culture and equipping the broader team for success.
- Communicate effectively with managers, developers, and other stakeholders
- Strong analytical and problem-solving skills
- Drive the teams ownership of solutions through your own ownership.

**High Beneficial skills**
- Experience in other forms of ETL process such as Event Stores like Apache Kafka, AWS Glue, Azure Data Factory
- Experience with AWS and/or Azure, understanding SaaS Cloud based concepts
- Experience working with Atlassian Suite
- Experience in the Telecommunications and/or Workforce Management industries
- Experience in designing advanced insights through Machine Learning.
- Experience with SAP Analytics Cloud (SAC)

**Leadership Qualities**
- Strong Leadership mentality instead of Manager mentality.
- Ability to motivate team in difficult times and praise team in successful times.

**Relevant Experience**
- At least 7 years of experience as a Data Developer with a focus on Microsoft SQL Server, SSIS, Warehousing
- At least 2 year experience as a Senior Data Developer with a demonstratable focus on Architecture and mentorship
- Experience with being involved in Team Management, including People management, prioritisation, and planning.
- Solid understanding in performing Extraction, Transformation, and Loading (ETL) of differing data into a standard data set.
- Solid understanding of Data Warehousing, including the designing and implementation of warehousing concepts such as Cubes, Dimensions, Metrics, Facts.
- Solid understanding of T-SQL with proven experience with Data Modelling, Design, SQL Function, Stored Proc and other common T-SQL processes
- Source Control, versioning and branching concepts.
- Experience performing Database Administration such as installation of MSSQL Server and Configuration of Clustering, Encryption, and Backup strategies
- Solid experience in Performance tuning of custom scripts in Stored Procedures or ETL Steps to improve the quality, speed, and accuracy of the resulting process, especially extraction of data.

In accordance with Adapt IT’s Employment Equity plans and goals, preference will be given to suitable applicants from the designated groups as defined by the Employment Equity Act of 55 of 1998 and subsequent amendments thereto.