Dynamics 365 BC BI Developer - Dashboards & Analytics

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

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.