Senior Data Engineer

Hantec Trader Limited; Dubai; On-site; AED 300,000 - 480,000; Full time

Benefits offered by this job

Annual ticket home

VISA Sponsorship

Health Insurance

Annual discretionary bonus pool

Core Values nominations

Core Values winner trip

Work from other offices

Job summary

Hantec Markets is seeking a Senior Data Engineer in Dubai to design, build, and optimize scalable data platforms using the Microsoft data ecosystem. You will develop data pipelines, automate workflows, and enable analytics across the organization while ensuring governance, security, and reliability.

You’ll collaborate with cross-functional teams to deliver data solutions, optimize performance, and support AI initiatives with clean, governed datasets and semantic models for reporting.

Qualifications

• 5+ years of experience as a Data Engineer or Senior Data Engineer.
• Strong experience with Microsoft Fabric.
• Hands-on experience with Azure Data Factory, Azure Synapse Analytics, and Azure Data Lake Storage.
• Extensive SQL Server development experience, including performance tuning and query optimization.
• Experience designing and maintaining enterprise ETL/ELT pipelines.
• Strong understanding of data warehouse, lakehouse, and dimensional modeling concepts.
• Experience with workflow automation using Power Automate.
• Exposure to AI, Copilot, or machine learning data integration is desirable.
• Experience with Git, DevOps, and CI/CD pipelines.
• Knowledge of Power BI semantic models is an advantage.
• Strong analytical, problem-solving, and communication skills.

Responsibilities

• Redesign and refactor existing SQL code, data models, and data structures.
• Build, maintain, and optimize ETL/ELT pipelines using Microsoft Fabric, Azure Data Factory, Azure Synapse Analytics, and Azure Data Lake.
• Design and implement scalable data warehouse and lakehouse architectures.
• Develop automated data ingestion, transformation, and orchestration pipelines.
• Implement data validation, quality checks, monitoring, and automated workflows.
• Collaborate with Data Analysts to deliver clean datasets and semantic models for reporting.
• Optimize SQL queries, stored procedures, and database performance.
• Develop and maintain CI/CD deployment processes for data solutions.
• Drive automation initiatives using Power Automate and other Microsoft automation tools.
• Support AI and Copilot initiatives by preparing and governing high-quality data.

Skills

5+ years data engineering

Microsoft Fabric

Azure Data Factory

Azure Synapse Analytics

Azure Data Lake Storage

SQL Server

ETL/ELT pipelines

Data warehouse concepts

Power Automate

AI Copilot data integration

Git/DevOps

CI/CD

Power BI semantic models

Tools

Git

Azure DevOps

Job description

Senior Data Engineer

Location: Dubai, UAE

Why Join Hantec Markets?

We’re a global broker with innovation at our core. Designing for us means building tools that empower traders across markets, platforms, and geographies. You’ll be part of a team where ownership is expected, collaboration is celebrated, and creativity is the standard.

About the Role:

We are looking for an experienced Senior Data Engineer with strong expertise in the Microsoft data ecosystem to design, build, and optimize scalable data platforms. You will be responsible for developing modern data pipelines, implementing automation, supporting AI initiatives, and delivering high-quality data solutions that power analytics and business intelligence across the organization.

Key Responsibilities:

• Redesign and refactor existing SQL code, data models, and data structures.

• Build, maintain, and optimize ETL/ELT pipelines using Microsoft Fabric, Azure Data Factory, Azure Synapse Analytics, and Azure Data Lake.

• Design and implement scalable data warehouse and lakehouse architectures.

• Develop automated data ingestion, transformation, and orchestration pipelines.

• Implement data validation, quality checks, monitoring, and automated workflows.

• Collaborate with Data Analysts to deliver clean, reliable datasets and semantic models for reporting and analytics.

• Optimize SQL queries, stored procedures, and database performance.

• Develop and maintain CI/CD deployment processes for data solutions.

• Drive automation initiatives using Power Automate and other Microsoft automation tools.

• Support AI and Copilot initiatives by preparing and governing high-quality data for AI-powered solutions.

• Ensure performance, security, governance, and reliability across all data platforms.

• Work closely with cross-functional teams to deliver scalable and business-focused data solutions.

Required Skills & Experience:

• 5+ years of experience as a Data Engineer or Senior Data Engineer.

• Strong experience with Microsoft Fabric.

• Hands-on experience with Azure Data Factory, Azure Synapse Analytics, and Azure Data Lake Storage.

• Extensive SQL Server development experience, including performance tuning and query optimization.

• Experience designing and maintaining enterprise ETL/ELT pipelines.

• Strong understanding of data warehouse, lakehouse, and dimensional modeling concepts.

• Experience with workflow automation using Power Automate or similar automation platforms.

• Exposure to AI, Copilot, or machine learning data integration is highly desirable.

• Experience with Git, DevOps, and CI/CD pipelines.

• Knowledge of Power BI semantic models is an advantage.

• Strong analytical, problem-solving, and communication skills.

• Ability to work independently while collaborating effectively within a cross-functional team.

Our Values:

• Own It, Every Time – Responsibility is our standard.

• Make Things Happen – We act decisively and with purpose.

• Relationships Matter – We collaborate with intent.

• Integrity is Everything – No shortcuts. No compromise.

What we offer:

• Annual Ticket Home - 2,500 AED a year offered after 1 year of employment

• VISA Sponsorship

• Health Insurance

• Annual Discretionary Bonus Pool – rewarding high performance

• Monthly $100 Core Values Nominations – recognition for living our values

• Quarterly Core Values Winner – exclusive dinner with our Directors

• Yearly Core Values Champion – an all-inclusive paid work trip to one of our global offices

• Work from Other Offices – flexibility to work remotely from our worldwide locations (at employee’s expense)