Data Engineer
Apparel Group · Dubai, Dubai, United Arab Emirates
Retail Apparel and Fashion · 1,001-5,000 employees
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
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