Senior Data Warehouse Engineer

Jobgether SRL; Abu Dhabi; Remote; AED 558,000 - 753,000; Full time

Benefits offered by this job

Fully remote work

Job summary

Jobgether SRL is seeking a Senior Data Warehouse Engineer for a fully remote role, supporting a globally distributed data platform. You will design scalable data warehouses, build robust ETL/ELT pipelines, and collaborate with data scientists, analysts, and engineers to deliver actionable insights.

The role emphasizes ownership, performance optimization, and cost efficiency across ClickHouse, Redshift, AWS, Kafka, dbt, and Prefect in a remote, international team.

Qualifications

• Experience designing and optimizing cloud data warehouses.
• Strong SQL and data modeling skills.
• Proficiency with dbt and modern ELT pipelines.

Responsibilities

• Architect and maintain scalable data warehouse solutions.
• Develop reliable data pipelines and ELT processes.
• Optimize warehouse performance and cost efficiency.

Skills

SQL proficiency

Data warehousing design

Cloud data warehousing

dbt

Prefect/Airflow

ETL/ELT

Data modeling

Python/Bash

Education

Bachelor's degree in CS or related field

Tools

ClickHouse

Redshift

Databricks

BigQuery

Job description

This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Senior Data Warehouse Engineer based in United Arab Emirates.

This role offers the opportunity to shape the data infrastructure supporting a high-growth technology platform focused on online security and fraud detection. You will design and optimize scalable data warehouses, reliable pipelines, and modern ELT processes that enable analytics and data-driven decision-making. Working closely with data scientists, analysts, and engineers, you will transform complex data into trusted and actionable insights. The position combines hands-on engineering with opportunities to improve performance, reliability, cost efficiency, and developer productivity. You will work with modern cloud technologies including ClickHouse, Redshift, AWS, Kafka, dbt, and Prefect. This is a strong opportunity for an autonomous data engineer who enjoys solving complex problems in a globally distributed, fully remote environment.

Accountabilities

• Architect, build, and maintain scalable, high-performance data warehouse solutions that support analytics and operational needs.
• Develop reliable, well-documented data pipelines and ELT processes while maintaining strong standards for data quality and consistency.
• Optimize data warehouse performance through query optimization, partitioning, indexing, and other performance-tuning techniques.
• Partner with data analysts and data scientists to transform raw data into actionable analytics and support machine learning initiatives.
• Monitor, troubleshoot, and continuously improve data warehouse infrastructure while balancing performance, reliability, and cost efficiency.
• Establish and promote best practices for clean, well-structured, reliable, and accessible data.
• Work with modern cloud-based data warehouses such as ClickHouse and integrate data platforms with other cloud services.
• Contribute to developer-facing data tools and solutions that empower engineering and other technical teams.
• Support data transformation and modeling initiatives using tools such as dbt and SQL.
• Contribute to automation, testing, version control, code reviews, and other software engineering practices across data systems.
• Help improve the scalability, maintainability, and operational efficiency of the overall data platform.

Requirements

• Extensive professional experience designing, implementing, and optimizing data warehouses in cloud environments such as AWS or GCP.
• Strong hands-on expertise with data modeling and transformation tools, particularly dbt.
• Excellent SQL skills and experience with modern columnar or cloud data warehouse technologies such as ClickHouse, Databricks, BigQuery, Snowflake, or Redshift.
• Experience developing and managing data pipelines using orchestration tools such as Prefect or Airflow.
• Solid understanding of data engineering principles, warehouse architecture, transformation, and data quality.
• Strong software engineering fundamentals, including version control, code reviews, testing, automation, and maintainable development practices.
• Experience working collaboratively with data scientists, analysts, engineers, and other cross-functional stakeholders.
• Strong English communication skills for effective collaboration within a globally distributed remote team.
• High degree of ownership, autonomy, and accountability, with the ability to work effectively in ambiguous environments.
• Strong analytical and problem-solving skills, with a practical approach to troubleshooting and performance optimization.
• Familiarity with business intelligence and visualization tools such as Apache Superset, Sigma, Tableau, or Looker is a plus.
• Experience with infrastructure-as-code tools such as Terraform and a DevOps-oriented mindset is desirable.
• Scripting or automation experience with Bash, Python, or Go is an advantage.
• Experience with technologies such as Kafka, AWS, Terraform, and modern data visualization platforms is beneficial.

Benefits

• Fully remote work arrangement within eligible hiring locations.
• Opportunity to work on large-scale data infrastructure supporting a technology platform focused on online security and fraud detection.
• Exposure to a modern technology stack including ClickHouse, Redshift, Confluent Kafka, dbt, Prefect, AWS, Terraform, Apache Superset, and Sigma.
• Opportunity to collaborate with data scientists, analysts, engineers, and globally distributed technical teams.
• High level of ownership and autonomy in a data engineering environment.
• Opportunity to contribute to developer-facing tools and scalable data platform initiatives.
• US-based compensation range of $152,000–$205,000; compensation may vary by hiring location and is not directly applicable to all locations.
• Fully remote international environment with team members distributed across multiple countries and time zones.
• Visa sponsorship is not provided; candidates must be authorized to work from their home location.
• Specific India-based salary, healthcare, retirement, paid time off, and other benefits were not specified in the source description.