Business Intelligence Developer

International Luxury Group (ILG of Switzerland AG); Dubai; On-site; AED 180,000 - 240,000; Full time

Job summary

International Luxury Group (ILG of Switzerland AG) is seeking a BI Developer with strong expertise in Microsoft Dynamics 365 Business Central to design, build, and support end-to-end BI solutions. You will extract, transform, and model BC data and develop dashboards, reports, and analytical models that drive informed decision-making across the company.

You will collaborate with BC consultants, ERP teams, and stakeholders to ensure data accuracy, performance, and usability, delivering scalable BI

Qualifications

• 2-3+ years of experience as a BI Developer.
• Hands-on experience integrating and reporting from Microsoft Dynamics 365 Business Central or Dynamics NAV.
• Strong SQL skills and relational databases (SQL Server preferred).
• Proficiency with Power BI, including DAX, Power Query, data modeling, and data transformation.

Responsibilities

• Design, develop, and maintain dashboards and reports in Power BI / BI4Dynamics for BC & NAV.
• Build reusable datasets, semantic models, KPIs, and data flows for BC-based reporting.
• Extract data from Dynamics 365 BC using OData, APIs, Web Services, Azure Data Lake, or direct SQL.
• Build and maintain ETL pipelines to integrate BC data with data warehouse or analytics layer.
• Collaborate with BC functional teams to understand table structures, dimensions, posting flows, and business rules.
• Translate business needs into technical specifications and provide user training and documentation.

Skills

Power BI

SQL

ETL

Data modeling

DAX

Azure Data Factory

Dynamics 365 BC/NAV data

Education

Bachelor's degree in Computer Science / Information Systems

Tools

SQL Server

SSIS

Azure Data Factory

Job description

BI Developer with strong expertise in Microsoft Dynamics 365 Business Central (BC) to design, build, and support end-to-end BI solutions. The role involves extracting, transforming, and modeling BC data, and developing dashboards, reports, and analytical models that drive informed decision-making across the company.

The BI Developer will collaborate closely with functional BC consultants, ERP teams, and business stakeholders to ensure data accuracy, performance, and usability.

Key Responsibilities

BI Development & Reporting

• Design, develop, and maintain dashboards and reports in Power BI / BI4Dynamics for BC & NAV.
• Build reusable datasets, semantic models, KPIs, and data flows for BC-based reporting.
• Ensure BI outputs align with business requirements and ERP logic.

Business Central Data Integration

• Extract data from Microsoft Dynamics 365 Business Central using OData, APIs, Web Services, Azure Data Lake, or direct SQL (for on-prem BC/NAV).
• Build and maintain ETL pipelines to integrate BC data with the data warehouse or analytics layer.
• Collaborate with BC functional teams to understand table structures, dimensions, posting flows, and business rules.

Data Modeling & Warehousing

• Build and manage data models reflecting BC source structures (e.g., Customers, Vendors, Items, G/L, Sales, Purchasing, Inventory, Jobs).
• Implement data quality and validation checks for BC transactional and master data.

Performance Optimization

• Optimize slow BC APIs/queries used for BI extraction.
• Implement incremental refresh, partitioning, and query folding in Power BI or equivalent tools.
• Tune data models to improve report performance and refresh times.

Business Collaboration

• Work with finance, operations, supply chain, sales, and management teams to gather BI requirements.
• Translate business needs into technical specifications.
• Provide user support, training, and documentation for BI solutions.

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field.
• 2-3+ years of experience as a BI Developer.
• Hands-on experience integrating and reporting from Microsoft Dynamics 365 Business Central or Dynamics NAV.
• Strong SQL skills and experience with relational databases (SQL Server preferred).
• Proficient with Power BI, including DAX, Power Query (M), data modeling, and data transformation.
• Solid understanding of ERP / Business Central data structures-G/L, Sales, Purchasing, Inventory, Jobs, etc.
• Experience with ETL tools (SSIS, Azure Data Factory, or similar).