Data Analytics Engineer

Join the House of AMOUAGE

Your Mission

We are currently looking for a dynamic and results-driven Data Analytics Engineer responsible for building, maintaining, and optimizing end-to-end data pipelines and analytical solutions within a Microsoft-first cloud ecosystem, supporting luxury retail, e-commerce, and supply chain operations.

Your Impact

• Built and maintained scalable data pipelines using Microsoft Fabric Data Factory, Azure Data Factory, and PySpark notebooks to ingest, transform, and deliver data across bronze, silver, and gold layers of the Medallion architecture.
• Developed and optimized SQL and PySpark transformation logic within Fabric Lakehouses and OneLake, ensuring data accuracy, consistency, and performance at scale.
• Extracted, loaded, and transformed data from Microsoft Dynamics 365 (Finance, Supply Chain, and Commerce) into the Fabric data platform using Dataflows Gen2, virtual tables, and API-based connectors.
• Developed and maintained Power BI reports and semantic models using Direct Lake mode, DAX measures, and star schema design to support commercial and operational stakeholders.
• Built practical Power Apps canvas and model-driven apps connected to Dynamics 365 and Fabric data, enabling business users to interact with and act on live data.
• Automated repetitive data and business workflows using Power Automate, including Dynamics 365 event-driven triggers and Fabric data alerts.
• Implemented data quality checks, validation rules, and anomaly detection within pipelines to maintain data integrity across all layers.
• Applied Microsoft Purview for data cataloguing, lineage tracking, and classification of sensitive data assets across Fabric and Dynamics environments.
• Collaborated with business analysts and stakeholders to translate requirements into analytical models, KPIs, and self-service reporting solutions.
• Participated in and contributed to POCs, testing, and iterative delivery of new Fabric and Power Platform features.

Your Journey With Us

The House of AMOUAGE has been on an aggressive growth trajectory within the fast-growing ultra luxury perfumes segment, unlocking tremendous personal and career development opportunities for our team members across multiple locations, including Muscat, Dubai, New York, Seoul and Kuala Lumpur.

Your Expertise

• Delivered near-real-time data pipelines connecting Dynamics 365 Supply Chain and Commerce data into Microsoft Fabric, reducing reporting lag from days to minutes.
• Built a suite of Power BI Direct Lake dashboards used daily by commercial and operations teams for performance tracking and decision making.
• Developed reusable Power Apps solutions that replaced manual spreadsheet processes, saving significant time across business teams.
• Improved pipeline reliability and data quality by implementing automated validation frameworks within Microsoft Fabric notebooks.
• Accelerated time-to-insight by building reusable transformation templates and semantic.

Technical Skills:

• Microsoft Fabric, PySpark, SQL, Dataflows Gen2, Azure Data Factory, OneLake, Power BI (DAX, Direct Lake) Power Apps (Canvas & Model-Driven), Power Automate, Microsoft, Dynamics 365 (Finance, SCM, Commerce) Microsoft Purview, Azure Data Lake Storage and Python.

The AMOUAGE Advantage

Join a House that has been creating luxury fragrance experiences since 1983. At AMOUAGE, you'll be part of a legacy that combines artisanal craftsmanship with modern innovation, bringing extraordinary olfactory experiences to clients worldwide.