Senior Software Engineer ELT

Transguard Group was established in 2001 and has diversified significantly, leading in the fields of Cash Services, Security Services, Manpower Services, Facilities Management & Aviation. Transguard Group is the UAE’s most trusted business support and outsourcing provider and has a large, dynamic, and culturally diverse workforce with 50,000 employees! We are currently recruiting for a Senior Software Engineer - ELT for our trusted client to be based out of their office in Dubai.

Job Purpose:

To run data integration projects aimed at centralizing data reporting and helping the business understand processes, have visibility in data quality, and improve decision-making. This includes creating reports that enhance operational efficiency and promote visibility of processes and KPIs. Responsibilities include developing data integration pipelines, data transformation procedures, and reports in Tableau, as well as providing business visibility into key performance indexes. The role requires understanding business requirements, designing and implementing solutions, and communicating project status to the project manager while updating the business on progress.

Responsibilities:

1. Design, build, and deploy effective data ingestion pipelines/streams in StreamSets Data Collector & Kafka.
2. Process data using SQL and PL SQL Procedures.
3. Orchestrate and automate data ingestion pipelines.
4. Transform data into Star Schema Data Model including partitioning and distribution strategy.
5. Create Semantic layer and Data Marts.
6. Build Aggregate tables.
7. Design and Develop Visualization for KPIs.
8. Compose Sheets using Tableau Data Model.
9. Develop Tableau Workbook using Containers and Sheets parameters and automate data extracts.
10. Maintenance of system logs.
11. Security Update and System Patching.
12. Monitoring of the platform and applications.