Senior Data Engineer Hantec Trader On-site Fast Track available

HireHouse; Dubai; On-site; AED 260,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 dinner

Core values champion trip

Work from other offices

Job summary

Hantec Markets in Dubai seeks a Senior Data Engineer to design, build, and optimize scalable data platforms using the Microsoft data ecosystem. You will develop modern data pipelines, automate workflows, and support AI initiatives across the organization.

Join a team delivering clean datasets, governance, and reliable BI-ready data while collaborating with analysts and cross-functional partners. A strong emphasis on performance, security, and scalable solutions is evident throughout the role.

Qualifications

• 5+ years of experience as a Data Engineer or Senior Data Engineer.
• Strong experience with Microsoft Fabric.
• Hands-on Azure Data Factory, Synapse Analytics, and Data Lake Storage.
• Extensive SQL Server development with performance tuning.
• Experience designing enterprise ETL/ELT pipelines.
• Knowledge of data warehouse, lakehouse, and dimensional modeling.
• Experience with workflow automation using Power Automate.
• Exposure to AI/Copilot or ML data integration is desirable.
• Experience with Git, DevOps, and CI/CD pipelines.
• Knowledge of Power BI semantic models is a plus.
• Strong analytical, problem-solving, and communication skills.
• Ability to work independently and with cross-functional teams.

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.

Skills

Microsoft Fabric

Azure Data Factory

Azure Synapse Analytics

Azure Data Lake Storage

SQL Server

ETL/ELT pipelines

Data warehouse

Lakehouse

Dimensional modeling

Power Automate

AI/Copilot data integration

Git/DevOps/CI-CD

Power BI semantic models

Analytical thinking

Cross-functional collaboration

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.

Important note: As part of the application, candidates are required to provide a summary of the key projects they have worked on, clearly outlining their role, responsibilities, technologies used, and contributions to each project. This will help us better understand their hands‑on experience and technical expertise.

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)