Data Engineer at Apparel Group | Dubai, AE | Rezi

Data Engineer at Apparel Group

Data Engineer

Apparel Group · Dubai, AE

3 weeks ago

Data Engineer

Apparel Group · Dubai, AE

22 days ago
Resume preview

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

Responsibilities

  • Design, develop, and maintain enterprise BI solutions using MicroStrategy ONE (latest versions).
  • Develop complete BI applications including schema objects, attributes and hierarchies, facts, metrics, filters, prompts, advanced reports and dashboards, and dossiers and interactive visualizations.
  • Translate business requirements into scalable BI solutions.
  • Build reusable semantic models and reporting frameworks.
  • Implement advanced MicroStrategy features including Intelligent Cubes, caching strategies, incremental refresh, derived metrics, advanced analytics functions, and transaction services.
  • Create and configure AI Agents, develop conversational analytics experiences, use AI-assisted insights generation, implement Auto Narratives, and leverage 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.
  • 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.
  • Write complex SQL queries for Data extraction, Transformation, Validation and Performance tuning.
  • Write complex SQL queries utilizing 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.
  • Experience working with enterprise ETL/data integration tools 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.
  • Use Python for Data analysis, Automation, Data validation, API integrations and Reporting utilities.
  • Experience with Python libraries such as Pandas, NumPy, Requests and PySpark.
  • 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.

Requirements

  • 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: 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.
  • 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.
  • 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.

Skills

  • MicroStrategy ONE
  • Schema objects
  • Attributes and hierarchies
  • Facts, metrics, filters, prompts
  • Advanced reports and dashboards
  • Dossiers and interactive visualizations
  • Intelligent Cubes
  • Caching strategies
  • Incremental refresh
  • Derived metrics
  • Advanced analytics functions
  • Transaction services
  • Strategy AI features
  • AI Agents
  • Conversational analytics
  • AI-assisted insights generation
  • Auto Narratives
  • AI-powered dashboard and visualization capabilities
  • Dimensional modelling
  • Star schema
  • Snowflake schema
  • Fact and dimension modelling
  • Slowly Changing Dimensions (SCD)
  • SQL
  • Data extraction
  • Data Transformation
  • Data Validation
  • Performance tuning
  • Joins
  • Window functions
  • CTEs
  • Stored procedures
  • Query optimization
  • Amazon Redshift
  • Oracle
  • SQL Server
  • Snowflake
  • Azure Synapse
  • Databricks
  • ETL
  • Matillion
  • Informatica
  • Azure Data Factory
  • Cloud ETL platforms
  • ETL pipeline design
  • ETL scheduling
  • ETL monitoring
  • ETL troubleshooting
  • Python
  • Pandas
  • NumPy
  • Requests
  • PySpark
  • BI governance
  • BI security
  • User access management
  • Azure
  • AWS
  • GCP
  • Retail analytics
  • Finance analytics
  • Supply chain analytics
  • Enterprise analytics

Experience Level

  • 5+ years of experience in Business Intelligence development

Education Level

  • Bachelor’s degree in Computer Science, Information Technology, Engineering, Data Analytics, or related field.