Apparel Group

Data Engineer

Apparel Group · Dubai, Dubai, United Arab Emirates

Retail Apparel and Fashion · 1,001-5,000 employees

8 h ago
Senior (5-10 yrs) Full-time United Arab Emirates
Log in to apply, save this posting, or score it against your profile with AI.

About the role

Design and maintain enterprise BI solutions using MicroStrategy ONE, including the development of semantic models, dashboards, and AI-driven analytics. The role involves optimizing data architecture and managing the end-to-end BI lifecycle from data ingestion to insight delivery.

What they look for

MicroStrategy ONE SQL Python ETL Data Modelling Dimensional Modelling Strategy AI Amazon Redshift Snowflake Azure Synapse Databricks PySpark Pandas Business Intelligence Data Warehousing Semantic Layer Development

Requirements

Requires over 5 years of BI development experience with strong proficiency in MicroStrategy, SQL, Python, and ETL tools. A bachelor's degree in Computer Science or a related field is required.

Full description

Key Responsibilities MicroStrategy Development & BI Delivery

  • Design, develop, and maintain enterprise BI solutions using MicroStrategy ONE (latest versions).
  • Develop complete BI applications including:

o Schema objects o Attributes and hierarchies o Facts, metrics, filters, prompts o Advanced reports and dashboards o Dossiers and interactive visualizations

  • Translate business requirements into scalable BI solutions.
  • Build reusable semantic models and reporting frameworks.
  • Implement advanced MicroStrategy features including:

o Intelligent Cubes o Caching strategies o Incremental refresh o Derived metrics o Advanced analytics functions o Transaction services (where applicable) Strategy AI / AI Analytics Capabilities

  • Hands-on experience with Strategy AI features:

o Creating and configuring AI Agents o Developing conversational analytics experiences o Using AI-assisted insights generation o Implementing Auto Narratives / natural language explanations o Leveraging AI-powered dashboard and visualization capabilities

  • Enable business users to interact with data using AI-driven analytics.
  • Evaluate opportunities to automate reporting and insight generation using AI capabilities.

Data Modelling & Data Architecture

  • Strong understanding of dimensional modelling concepts:

o Star schema o Snowflake schema o Fact and dimension modelling o Slowly Changing Dimensions (SCD)

  • Design logical and physical data models for BI consumption.
  • Optimize semantic layers for scalability and performance.
  • Perform data validation and reconciliation between source systems and BI outputs.

SQL & Data Engineering

  • Write complex SQL queries for Data extraction, Transformation, Validation and Performance tuning.
  • Strong knowledge of Joins, Window functions, CTEs, Stored procedures and Query optimization techniques.
  • Experience working with enterprise databases/data warehouses such as Amazon Redshift, Oracle, SQL Server, Snowflake, Azure Synapse, Databricks.

ETL / Data Integration

  • Experience working with any enterprise ETL/data integration tool such as Matillion, Informatica, Azure Data Factory or Other cloud ETL platforms
  • Understand ETL pipeline design, scheduling, monitoring, and troubleshooting.
  • Work closely with data engineering teams to ensure reliable data availability.

Python & Automation

  • Use Python for Data analysis, Automation, Data validation, API integrations and Reporting utilities.
  • Experience with Python libraries such as Pandas, NumPy, Requests and PySpark (preferred).

Performance Optimization & Support

  • Monitor and optimize MicroStrategy reports, dashboards, and cubes.
  • Troubleshoot performance issues across SQL layer, Data model, MicroStrategy objects and Application layer.
  • Perform root cause analysis and implement improvements.
  • Support production BI environments and resolve user issues.

________________________________________ Required Skills & Experience Mandatory

  • 5+ years of experience in Business Intelligence development.
  • Strong hands-on experience with MicroStrategy platform.
  • Experience with MicroStrategy ONE / Strategy One latest versions.
  • End-to-end MicroStrategy development experience:

o Modelling → Metadata → Reports → Dashboards → Deployment.

  • Strong SQL development skills.
  • Experience with at least one ETL tool.
  • Python scripting experience.
  • Strong understanding of data warehousing concepts.
  • Experience working with large enterprise datasets.

Preferred

  • Experience implementing Strategy AI solutions.
  • Experience creating AI Agents and conversational analytics solutions.
  • Experience migrating/upgrading MicroStrategy environments.
  • Knowledge of BI governance, security, and user access management.
  • Experience with cloud data platforms (Azure/AWS/GCP).
  • Experience in retail, finance, supply chain, or enterprise analytics domains.

________________________________________ Education Bachelor’s degree in Computer Science, Information Technology, Engineering, Data Analytics, or related field. ________________________________________ Key Competencies

  • Strong analytical and problem-solving skills
  • Ability to translate business needs into technical solutions
  • Excellent communication skills
  • Ability to work independently and collaborate with cross-functional teams
  • Strong ownership mindset and attention to detail