About the Role

We are seeking a skilled Data Engineer to join our team in Dubai, UAE. This role is centered on developing robust semantic models on our data lake/data warehouse infrastructure to support self-service business intelligence needs. You will be responsible for extracting data from various sources and integrating it into our central data environment using enterprise platforms like Informatica iPaaS and Microsoft Azure services.

Key Responsibilities

Data Modeling and Architecture

Design comprehensive data warehouse models based on specific business requirements and best practices

Create and maintain semantic models and self-service cubes that translate complex data structures into business-friendly views

Architect ETL pipelines that ensure reliable, timely data loading on a regular basis

Assess source system data quality and propose enhancements to improve data accuracy

Data Integration and Processing

Design, develop, and thoroughly test both batch and real-time Extract, Transform and Load (ETL) processes

Ingest structured and unstructured data into the organization's data lake and data warehouse systems

Optimize ETL processes to meet performance requirements and execution time targets

Troubleshoot data pipeline issues and implement solutions to maintain data flow

Business Intelligence Support

Perform BI administration and access management to ensure proper governance of reports and data access

Conduct unit testing and data validation to support successful Business User Acceptance Testing

Execute ad-hoc data analysis and present findings in clear, actionable formats

Collaborate with business stakeholders to understand reporting needs and implement appropriate solutions

Technical Maintenance and Optimization

Monitor data pipeline performance and implement optimizations

Document data models, ETL processes, and semantic layer designs

Stay current with Azure data technology advancements and implement improvements

Ensure compliance with data governance policies and security requirements

Qualifications and Skills

Experience

5-8 years of overall professional experience

Proven experience developing dimensional models in Azure Synapse with strong SQL knowledge

Minimum 3 years working as a Data Engineer in Azure ecosystem, specifically with Synapse, Azure Data Factory (ADF), and Databricks

Preferably 3 years of experience with data warehousing, ETL development, SQL queries, PySpark, and Informatica iPaaS for data ingestion and modeling

Technical Expertise

Expert-level SQL skills for complex query development and optimization

Proficiency with Azure Synapse Analytics, including dedicated SQL pools and serverless SQL pools

Strong working knowledge of Azure Data Factory for orchestrating data movement

Experience with PySpark for large-scale data processing

Familiarity with Informatica iPaaS for enterprise data integration

Understanding of dimensional modeling concepts (Kimball methodology)

Additional Skills

Strong problem-solving abilities and analytical thinking

Excellent communication skills to translate technical concepts to business users

Experience working in agile development environments

Knowledge of data governance principles and practices

How to Apply

Qualified candidates should send their resume and cover letter to salini@uhrs.ae

with the subject line "Azure Data Engineer Application - [Your Name]"

About Us

We have highly qualified sector specialists and client-friendly approach are unparalleled. It enables us to provide precise and customised solutions to the ever-changing client requirements effectively and efficiently.

With comprehensive experience in providing services to our world-class clientele and top-calibre candidates spread across numerous industries, we measure our successes through our ever growing list of satisfied clients. Today, with a track record of having outsourced and contracted over 30000+ employees from over 97+ different nationalities across more than 80+ job functions, we are proud to be the preferred recruitment and outsourcing partner for our 300+ clients.