Projects (Deputations)

Data Analysis and Engineering Skills - Dubai - Subcon -Req ID - 215-20/08/2025

Dubai
Work Type: Full Time
Request ID
215
Primary Skill
Data Analysis and Engineering Skills
Duration
12 Months
How many resources are required
2
Technical skills required
Core Technical Skills
 
Amazon Redshift
  • Data modeling and schema design
  • Performance tuning (distribution keys, sort keys, vacuuming)
  • Redshift Spectrum & Federated Query usage
  • ETL/ELT processing within Redshift
 
SQL (Advanced)
  • Complex joins, subqueries, CTEs
  • Window functions
  • Query optimization techniques
  • Writing and debugging stored procedures
  • ETL/ELT pipeline design and orchestration

Cloud & DevOps Skills
  • AWS Services (S3, Lambda, Glue, EMR, IAM, CloudWatch)

Good to have 
  • Tableau (or similar BI tools)
  • Apache Spark
    • Spark SQL and DataFrame API
    • Data ingestion and transformation using PySpark/Scala
    • Tuning and optimizing Spark jobs
Data Platforms & Architecture
  • Experience with modern data stack (e.g., Snowflake, BigQuery as alternates)
  • Data lake vs. data warehouse design principles
  • Batch and real-time data processing concepts
Job Description
We are seeking a highly skilled Specialist Data Tech Lead to join our team and support the Customer 360 initiative. This role requires strong expertise in data engineering, analytics, and platform management to help build a unified, accurate, and actionable view of our customers.

The selected candidate will work extensively on Amperity’s Customer Data Platform, focusing on data ingestion, transformation, custom report creation, enhancement of customer attributes, and ensuring data integrity in daily runs. This position also requires hands-on experience with Amazon Redshift, SQL, Tableau, and Apache Spark, along with a solid understanding of modern data platforms and cloud environments.

Responsibilities

Design, implement, and maintain scalable data ingestion pipelines within Amperity and other platforms

Analyze, enrich, and transform customer data to support analytics, segmentation, and reporting needs

Create and manage advanced dashboards and visualizations using Tableau or similar BI tools

Lead troubleshooting and resolution of data issues identified in daily batch processes

Optimize Redshift data warehouse performance, manage schema design and query performance

Collaborate with cross-functional teams to translate business requirements into technical solutions

Implement and manage data governance, quality checks, and validation frameworks

Provide technical leadership and mentorship to junior data engineers and analysts




Submit Your Application

You have successfully applied
  • You have errors in applying