Data Engineer

Boardroom Appointments; Cape Town; On-site; ZAR 600,000 - 900,000; Full time

Job summary

Boardroom Appointments seeks a Data Engineer with strong SQL and BI skills to manage and optimize database systems. You will implement ETL processes, ensure security, monitor performance, and collaborate with developers and BI teams.

The ideal candidate has 5+ years of data engineering experience, solid PowerBI/MS SQL/SSIS expertise, and excellent communication. This role demands proactive data management and adherence to data governance.

Qualifications

• Tertiary qualification in Computer Science and/or Software Engineering and/or Information Systems and/or Information technology/or related technical certification in an IT field.
• Minimum of 5 years experience as Data Engineer.
• Experience with PowerBI, MS SQL, SSIS.
• Good written and verbal communication skills.

Responsibilities

• Modifying the database structure as necessary, from information given by application developers.
• Enrolling users and maintaining system security.
• Controlling and monitoring user access to the database.
• Monitoring and optimizing the performance of the database.
• Maintaining archived data.
• Contacting database vendor for technical support.
• Perform database monitoring, tuning and capacity planning.
• Optimize database access and allocates /re-allocates database resources for optimum configuration, database performance and cost.
• Manage schema changes and implementations.
• Implement advanced database security features.
• Audit user activity to ensure integrity and performance of all the database.
• Establish standards, policies and procedures for data managements.
• Define and implement alerts on data.
• Develop reports and ETL packages in line with Business Intelligence best practices and procedures.

Skills

5+ years experience as Data Engineer

Communication skills

Education

Tertiary qualification in Computer Science/Software Engineering/Info Systems/IT field

Tools

PowerBI

MS SQL

SSIS

Job description

• Tertiary qualification in Computer Science and/or Software Engineering and/or Information Systems and/or Information technology/or related technical certification in an IT field and /or International Data engineering Qualification
• Minimum of 5 years experience as Data Engineer working with:
• PowerBI
• MS SQL
• SSIS
• Good written and verbal communication skills

Responsibilities:

• Modifying the database structure, as necessary, from information given by application developers
• Enrolling users and maintaining system security
• Controlling and monitoring user access to the database
• Monitoring and optimizing the performance of the database
• Maintaining archived data
• Contacting database vendor for technical support
• Perform database monitoring, tuning and capacity planning
• Optimize database access and allocates /re-allocates database resources for optimum configuration, database performance and cost
• Manage schema changes and implementations
• Implement advanced database security features
• Audit user activity to ensure integrity and performance of all the database
• Establish standards, policies and procedures for data managements
• Define and implement alerts on data
• Develop reports and ETL packages in line with Business Intelligence best practices and procedures