Senior Consultant - Data Engineering (Snowflake & Cortex AI)

About the role

MAIR Group is looking for a Data Engineering Consultant with strong expertise in Snowflake and Cortex AI to support retail data transformation initiatives in Abu Dhabi. The role enables advanced analytics across customer, sales, inventory and supply chain domains, using AI-driven insights to improve demand forecasting, personalization and operational efficiency.

Key responsibilities

• Design and implement scalable data platforms on Snowflake for retail analytics
• Build and optimize ELT pipelines for retail data (POS, e-commerce, CRM, inventory, supply chain)
• Leverage Snowflake Cortex for customer segmentation and personalization, product recommendations and promo analysis
• Integrate data from ERP, OMS, WMS and e-commerce platforms
• Develop data models for sales, margins, inventory turnover and basket analysis
• Ensure data quality, governance and compliance across datasets
• Optimize Snowflake performance and cost for large-scale retail workloads
• Collaborate with merchandising, marketing and supply chain teams and enable near real-time analytics for inventory and orders

Required profile

• 5+ years of experience in Data Engineering, preferably in retail or e-commerce
• Strong hands-on experience with Snowflake Data Cloud and Snowflake Cortex
• Advanced SQL and strong Python skills
• Experience with ETL/ELT tools (dbt, Airflow) and cloud platforms (AWS, Azure or GCP)
• Experience with BI tools (Tableau, Power BI, Looker); Snowflake or cloud certifications are good to have
• Ability to turn business needs into data solutions, communicate with technical and business teams, and manage agile delivery