Senior Data Engineer – Snowflake & ELT
Summary
Senior Data Engineer building and optimizing ETL/ELT pipelines and Snowflake data warehouse solutions for a semi-government aviation entity in Dubai. Day-to-day: SQL development, dimensional modeling, automated data ingestion, performance tuning, and Linux server support.
We are looking to hire a Senior Data Engineer – Snowflake & ELT who will be responsible for designing, developing, and optimizing data integration pipelines and data warehouse solutions for semi- government entity based in Dubai, one of the region's leading aviation organizations.
We are looking for a technically strong and hands-on Data Engineer with extensive experience in Snowflake, advanced SQL, ETL/ELT development, and data integration. The ideal candidate will have a solid understanding of data warehousing, data modeling, query optimization, and data processing, alongside working knowledge of Linux operating systems and server environments.
Key Responsibilities
- Design, develop, implement, and maintain scalable data integration and ETL/ELT pipelines across multiple data sources.
- Develop, manage, and optimize data processing and transformation workflows using Snowflake.
- Write, troubleshoot, and optimize complex SQL queries, stored procedures, and data transformation logic.
- Design and implement data warehouse models, including dimensional modeling, Star Schema, data marts, and aggregate tables.
- Develop and maintain automated data ingestion workflows to ensure reliable and efficient data movement.
- Perform data cleansing, validation, transformation, and performance optimization to maintain data accuracy and integrity.
- Monitor and troubleshoot data integration processes, identifying and resolving pipeline and performance issues.
- Support Linux-based environments, including basic operating system administration, server maintenance, and software troubleshooting.
- Collaborate with internal stakeholders to understand business requirements and translate them into effective technical solutions.
- Support data quality and governance initiatives to improve the reliability and consistency of enterprise data.
Knowledge, Skills & Experience:
Essential Requirements
- Bachelor's degree in Computer Science, Information Technology, Software Engineering, or a related discipline.
- 5–7 years of overall professional experience, with at least 3–5 years in data engineering, data integration, or ETL/ELT development.
- Strong hands-on experience with Snowflake, including data processing, transformations, and query optimization.
- Advanced proficiency in SQL, including complex query development, stored procedures, and performance tuning.
- Proven experience designing and developing ETL/ELT pipelines and data integration solutions.
- Experience with data integration or data acquisition technologies such as StreamSets, Informatica, Talend, Azure Data Factory, Apache NiFi, Airflow, or equivalent tools.
- Strong understanding of data warehousing concepts, dimensional modeling, Star Schema, and data transformation.
- Experience in data cleansing, validation, and processing across multiple data sources.
- Working knowledge of Linux operating systems, including basic server administration, maintenance, and troubleshooting.
- Strong analytical, problem-solving, and technical troubleshooting skills.
Desirable Skills
- Experience with Kafka, DBT, or other data orchestration and streaming technologies.
- Exposure to data governance and data quality platforms such as Atlan and DQLabs.
- Experience developing dashboards or reports using Tableau or similar BI tools.
- Previous experience in aviation, banking, telecommunications, or other large-scale enterprise environments.
Skills
Sign in to read and join the discussion.