top of page

Position:       Data Engineer (SQL Server Developer/ BI Developer)

Job No:          202491

Location:      Rosebank

Salary:           R 50 000 - R 60 000 P/m dependent upon experience

​

Job Purpose


The Data Engineer is primarily responsible for development, enhancement, troubleshooting and maintenance services on both on-premises (Microsoft SQL Server) and cloud data systems. You will need to have a sound understanding of relational database management systems, system analysis and design and data modelling. You will need to have working experience (3 years+) and competency with the Microsoft BI stack primarily SSIS, SSRS and
T-SQL development. You will be required to upskill and learn the Google cloud services platform stack and assist with cloud migration of on-premise reports.

 

Core skills and knowledge


Key Responsibilities

  • Responding to issues\tickets related to support of existing systems

  • Developing new reports on both on-premises and cloud systems

  • Upskilling on cloud services used by the Data Engineering team

  • Supporting on-premises system

  • Developing high performing stored procedures using T-SQL

  • Troubleshooting issues that arise on data systems (on-premises and cloud)

  • Developing and automating complex ETL processes

  • Adhering to development standards and naming conventions

  • Update tasks on Jira

  • Understanding SQL execution plan

  • Optimizing code, developing indexes etc.

  • Working well with team members within and outside of your team to deliver on tasks

  • Communicating progress with Scrum master and other stakeholders

  • Understanding payment processes and data

  • Delivering within SLAs and agreed timelines

 

Qualifications:

  • Degree in Computer Science, Engineering, Informatics, Applied Mathematics, Statistics

  • or Information systems.

  • Optional - MCSA or MCSE in data platform, database development, data engineering

  • Optional - Google Cloud Professional Data Engineer certification

 

Personal Skills

 

Communication:

  • Communication skills (written and verbal) in English.

  • Interpersonal / Relationship management skills

  • Negotiation and influencing

  • Facilitation

  • Presentation skills

 

Mind-set and attitude:

 

  • Analytical, diagnostic and problem-solving skills

  • Business acumen

  • Process and organizational thinking

  • Attention to detail.

  • Adaptability to change.

  • Willingness to take ownership and accountability.

 

Time management:

  • Planning and organizing skills

  • Ability to work under own initiative without guidance, cope well under sustained pressure and deliver to deadlines.

  • Ability to deal with multiple projects at the same time.

 

Minimum required knowledge

  • Understanding of Relational Database Management Systems (RDBMS)

  • Understanding of concepts related to RDBMS (Atomicity, transactions, Isolation levels, concurrency, locking, blocking)

  • System analysis and design

  • Software development (any optional of Python, java, C# or C++)

  • Good software development principles (abstraction, decomposition - modularizing code, developing for reuse, commenting appropriately, choosing appropriate data types, quantifying and managing complexity, writing simple readable code)

  • Data modelling for OLTP system (normalization, ERDs, Interaction diagrams)

 

Experience

 

  • At least 3 years of experience with the Microsoft BI Stack (SSIS, SSRS and SQL-server)

  • At least 3 years of experience with T-SQL development

  • Using SQL query execution plan

  • Optimizing code using indexes, partitioning, refactoring code, redesigning tables etc.

  • Normalizing de-normalized tables to 3NF

  • Working in an Agile environment

  • Creating complex ETL processes using SSIS or similar tool

 

Optional

  • 3 years in banking or payments services industry

  • At least 1 year of experience programming any of python, C#, java, C++ or C in a commercial environment

  • Experience with cloud services (Azure, AWS, GCP)

  • Dimensional data modeling for OLAP systems

  • Experience working in a medium to large corporate environment.

  • Jira, Confluence, slack

​

bottom of page