Data Engineer

Key Responsibilities

• Retail Data Domain & System Exploration

  • Explore, profile, and understand data structures across various retail source systems (ERP, CRM, Supply Chain, E-Commerce, Inventory Management, etc.).

• Data Ingestion & Pipeline Development (ETL/ELT)

  • Build and maintain high-performance pipelines using SSIS and n8n to extract data from diverse source systems into the Data Warehouse.

• Advanced SQL & Query Optimization

  • Write, tune, and optimize highly complex SQL queries, stored procedures, and window functions to handle large-scale data transformation and complex business logic efficiently.

• Data Warehouse Management

  • Maintain and manage enterprise Data Warehouse architectures.

• Data Exploration & Cleansing

  • Explore, profile, and clean complex datasets across legacy and modern business systems to ensure high data accuracy and readiness for analytical consumption.

• Semantic Layer & SSAS Management

  • Build and optimize SSAS Tabular Models, managing data partitions, memory processing, and Row-Level Security (RLS).

• Data Technical Innovation

  • Drive technical innovation through AI integration and advanced data capabilities.

Qualifications

• Experience: 2–3 years of hands-on experience in Data Engineering, ETL Development, or Data Warehousing.

• Domain Knowledge: Strong familiarity with retail business domains (e.g., POS data, omnichannel sales, inventory movement, store operations, product hierarchies, promotions).

• Mandatory Core Skills:

  • SQL: Expert-level querying, indexing, and performance tuning.
  • Microsoft BI Stack: High proficiency in SSIS and SSAS (Tabular Models).

• ETL & Automation: Experience with n8n or similar orchestration tools; comfortable writing Python for data manipulation and task automation.

• Architecture & AI: solid understanding of Data Warehouse design principles and AI knowledge.

• Security & Governance: Clear understanding of data governance and Row-Level Security (RLS).

• Execution & Soft Skills: Strong commitment to project timelines, delivering quality data solutions under pressure in fast-paced environments.