Data Engineer

Job Description

RAPP Mauritius is seeking a Data Engineer to join their team. RAPP is part of Omnicom’s Precision Marketing Group, focusing on individual customer experiences through customer-centric consulting, creativity, and customer experience management. The Data Engineer will evaluate business needs, build algorithms, and design data warehouse components.

Responsibilities:

• Evaluating business needs and building algorithms and prototypes.
• Designing, building, and supporting data warehouse components like ETL processes and databases.
• Conducting complex data analysis and reporting results.
• Identifying opportunities for data acquisition.
• Collaborating with data scientists and architects.
• Consolidating and optimizing data warehouse infrastructure.
• Conceiving analytics and business intelligence platform architecture.
• Monitoring, tuning, and performing database performance analysis.
• Designing, automating, building, and launching scalable data pipelines.
• Performing root cause analysis and resolving production and data issues.

Requirements:

• Experience with data models, data mining, and segmentation techniques.
• Experience with SQL database design and SQL Server Integration Service (SSIS).
• Experience with programming languages like Java and Python.
• Experience in combining raw data from different sources and conducting complex data analysis.
• Experience in building algorithms and prototypes and performing complex data analysis.
• Experience in designing and implementing ETL procedures.
• Minimum 4 years of experience in data warehouse architecture development and management.
• Minimum 4 years of experience with technologies such as SQL Server, SQL Server Integration Service (SSIS), and stored procedures.
• High proficiency in dimensional modeling techniques.
• Minimum 3 years of experience in custom ETL design, implementation, and maintenance.
• Advanced SQL skills.
• Bachelor's or master's degree in Computer Science or a related field.
• Data engineering certification (preferable).
• Ideally Intermediate English Proficiency (B2 reading, writing, and conversation).