Business Intelligence Developer

Confidential; Dubai; On-site; AED 180,000 - 240,000; Full time

Job summary

Confidential seeks a BI Developer proficient 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 and reports that drive informed decision-making.

You will collaborate with BC consultants, ERP teams, and stakeholders to ensure data accuracy, performance, and usability across finance, operations, and sales.

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).

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.
• Ensure BI outputs align with business requirements and ERP logic.
• 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.
• 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.
• 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.
• 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.

Skills

Power BI

SQL

Data modeling

ETL

DAX

Power Query (M)

API/ETL integration

Education

Bachelor’s degree in Computer Science, Information Systems, or related field

Tools

SSIS

Azure Data Factory

SQL Server

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).