About the job

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