Data Engineer

Rohloff Group; Somerset West; On-site; ZAR 600 000 - 800 000; Full time

Job summary

A leading franchise group is seeking a Data Engineer to design, develop, and maintain business intelligence solutions while ensuring database performance. The ideal candidate has a Bachelor's degree in a relevant field, at least 3 years of experience in a similar role, and proficiency in tools such as SQL Server and Power BI. This role offers a competitive salary, bonuses, and a collaborative work environment in Somerset West, Western Cape.

Benefits

Competitive salary and bonuses

Comprehensive benefits

Collaborative and flexible work environment

Qualifications

• 3+ years' experience in a similar role.
• Experience with data warehouse design and business analysis.
• Understanding of database management systems, OLAP, and ETL processes.

Responsibilities

• Design, build and deploy data architecture, data warehouses and business intelligence solutions.
• Create and maintain data integration packages to extract, transform, and load (ETL) data.
• Monitor, maintain, and optimize database performance.

Skills

Data warehousing

SQL

ETL processes

Problem-solving

Presenting Visualizations

Database management

Education

Bachelor's degree in computer science, IT, or related field

Certification in Database Administration

Tools

SQL Server

Power BI

DAX

T-SQL

SSIS

SSAS

SSRS

Job description

Join Our Team as a Data Engineer at KFC Rohloff Group!

Are you a visionary team player with a passion for developing and designing various databases.? We're looking for a Data Engineer to join our dynamic Team at KFC Rohloff Group. Drive our franchise group's growth and success through managing design, develop and maintain business intelligence solutions that turn data into knowledge, while also ensuring the efficient administration, maintenance, security, and performance of our databases.

What You'll Be Cooking Up

• Design, build and deploy data architecture, data warehouses and business intelligence solutions (dashboards, reports).
• Create and maintain data integration packages to extract, transform, and load (ETL) data from various sources.
• Monitor, maintain, and optimize database performance (including tuning queries, indexing, and troubleshooting).
• Perform SQL queries - design, code, test, and aggregate the results to conduct analysis and create useful information.
• Collaborate with cross functional teams to integrate data solutions.
• Provide continuous improvements on reporting and analytics methods.
• Database server administration, including database maintenance and ensuring data quality, integrity and security.
• Ensure high availability and disaster recovery strategies are in place (e.g. clustering, replication, failover).

What You Bring To The Table

• Bachelor's degree in computer science, IT, business intelligence, or related field.
• Certification in Database Administration or equivalent.
• 3+ years' experience in a similar role.
• Experience with data warehouse design and business analysis.
• Understanding of database management systems, OLAP, and ETL processes.
• Proficient in presenting information through reports and visualization.
• Skilled in SQL Server, Power BI, DAX, T-SQL, SSIS, SSAS, and SSRS.
• Experience with cloud databases (e.g., Azure SQL, AWS RDS) is advantageous.
• Knowledge of FMCG or retail industries is a plus.
• Strong problem-solving and troubleshooting skills.
• Analytical and detail oriented.
• Proactive with a problem-solving attitude.
• Business acumen and sense of urgency.
• Self-managed and able to function independently.
• Committed to continuous learning and skill improvement.

Why You'll Love It Here

• Competitive salary and bonuses.
• Comprehensive benefits.
• Collaborative, inclusive, and flexible work environment.

Ready to make an impact? Apply now and join us on this exciting journey!