Business Intelligence Developer
An AI agent that applies to roles like this on employers' own sites. 25 applications free, no card needed.
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).
Skills
SalesErpFinanceIf a job posting appears fraudulent, asks for payment, contains misleading information, or violates our guidelines, please report it immediately. Our team will review it promptly, Jobaaj does not charge any fee from the applicants.
Similar Jobs
View allLooking for something similar?
New Accounting & Finance roles in Dubai.
One email a day. Unsubscribe any time.

