Senior Consultant - Data Engineering
Posted
Summary
Senior Data Engineering consultant designing scalable Snowflake data platforms for MAIR Group's retail operations — building ELT pipelines, integrating retail systems (POS, ERP, e-commerce), and using Snowflake Cortex AI for personalization, demand forecasting, and analytics. Core stack: Snowflake, SQL, Python, dbt/Airflow, cloud, and BI tools.
Job Description:
Senior Consultant – Data Engineering
Role Purpose
We are looking for a Data Engineering Consultant with strong expertise in Snowflake and Cortex AI to support retail data transformation initiatives. This role focuses on enabling advanced analytics across customer, sales, inventory, and supply chain domains, and leveraging AI-driven insights to improve business outcomes such as 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 to enable AI-driven use cases such as: Customer segmentation & personalization, Product recommendations, promo analysis
- Integrate data from multiple retail systems (ERP, OMS, WMS, e-commerce platforms)
- Develop data models for key retail metrics (sales, margins, inventory turnover, basket analysis)
- Ensure data quality, governance, and compliance across datasets
- Optimize Snowflake performance and cost for large-scale retail workloads
- Collaborate with business stakeholders (merchandising, marketing, supply chain teams)
- Enable near real-time analytics for inventory and order tracking
Required Qualifications & Experience
- 5+ years of experience in Data Engineering, preferably in retail or e-commerce
- Strong hands-on experience with Snowflake Data Cloud
- Experience with Snowflake Cortex (AI/ML functions, LLM-powered analytics)
- Advanced SQL and strong Python skills
- Experience with ETL/ELT tools (dbt, Airflow, etc.)
- Strong understanding of retail data models and KPIs
- Experience with cloud platforms (AWS, Azure, or GCP)
- Experience with BI tools (Tableau, Power BI, Looker)
- Snowflake or cloud certifications (good to have)
Core Competencies
- Strong analytical and problem-solving mindset
- Ability to translate retail business needs into data solutions
- Excellent communication with both technical and business teams
- Agile delivery and stakeholder management
Key Performance Indicators (KPIs)
- Data Platform Performance and Success
- Data Quality & Reliability KPIs
- Performance improvements ( data sync speed, batch jobs, sync time)
- Reduction in time to generate business reports
- SOPs and policies compliance