RAPP Mauritius is looking for Data Engineer to join our award-winning team.

WHO WE ARE:

We think too much marketing isnt us. Its mass markets, not audiences of one. Homogenous groups to be targeted, not individuals to be inspired. Segments to reach, not people with their own ideas & ambitions. Its one size fits all, & its dull.

When it comes to individuals, were fierce. We stand up for individuality. We speak up against bland, broad-brush generalizations. We fight for solutions that adapt to the individuals needs, beliefs, behaviors & aspirations. And we commit to doing this in every aspect of our work for clients & their consumers.

We actively foster an inclusive workplace where diversity & individual difference are valued & leveraged to achieve the agencys vision. And most importantly, we value every individuals wellbeing.

We are Fiercely Individual.

HOW WE DO IT:

At RAPP, we are fiercely focused on the individual & how we can create value from every individuals experience with a brand. We do this across three capability areas: customer-centric consulting, creativity that inspires action & customer experience management.

Our data analysts know who that person is. Our strategists understand what they want. And our award-winning technologists & creatives know how to get it to them.

RAPP is an integral part of Omnicoms Precision Marketing Group, comprising 4,000 creatives, technologists, strategists, & data & marketing scientists across 40 global markets.

YOUR ROLE:

• Evaluate business needs, objectives & build algorithms & prototypes
• Responsible for designing, building, & supporting the components of data warehouse, such as ETL processes, databases, reports & reporting environments
• Conduct complex data analysis & report on results, analyze & organize raw data
• Identify opportunities for data acquisition by developing analytical tools & programs
• Collaborate with data scientists & architects on several projects
• Consolidate & optimize available data warehouse infrastructure
• Responsible for designing, building, & supporting the components of data warehouse, such as ETL processes, databases, reports & reporting environments
• Assembles performance statistics, analyzes them, & makes recommendations for improvements
• Establishes system documentation & ensures it is continually sustained
• Conceive analytics & business intelligence platform architecture for clients, including internal & third-party clients
• Collaborate with business & technology stakeholders in ensuring data warehouse architecture development & utilization
• Carry out monitoring, tuning, & database performance analysis
• Design, automate, build, & launch scalable, efficient & reliable data pipelines into production
• Perform root cause analysis & resolve production & data issues

YOUR RESPONSIBILITIES:

• Experience & expertise with data models, data mining, & segmentation techniques
• Experience with SQL database design
• SQL Server Integration Service (SSIS)
• Experience with programming languages (e.g. Java & Python)
• Experience in combining raw data from different sources & conducting complex data analysis
• Experience in building algorithms & prototypes & perform complex data analysis
• Experience in design & implement ETL procedures for intake of data from both internal & external sources, as well as ensure data is verified & quality is checked
• Experience in design & implement ETL processes & data architecture to ensure proper functioning of analytics, as well as clients or third-partys reporting environments & dashboard
• Carry out monitoring, tuning, & database performance analysis
• Minimum 4 years experience performing data warehouse architecture development & management
• Minimum 4 years experience with technologies such as SQL Server, SQL Server Integration Service (SSIS), & stored procedures
• Minimum 4 years experience developing code, testing for quality assurance, administering RDBMS, & monitoring databases
• High proficiency in dimensional modeling techniques & their applications
• Minimum 3 years experience in custom ETL design, implementation & maintenance
• Advanced SQL skills is a must

REQUIRED SKILLS:

• Bachelor or master's degree in Computer Science or related technical field
• Data engineering certification (preferable)
• Ideally Intermediate English Proficiency (B2 reading, writing, & conversation).

NOTE:  This job description is not intended to be all-inclusive. Employee may perform other related duties as negotiated to meet the ongoing needs of the organization.