Requirements
Bachelor's degree in Computer Science, Information Systems, or related field. 2-3+ years of experience as a BI Developer with hands-on experience integrating and reporting from Microsoft Dynamics 365 Business Central or Dynamics NAV. Strong SQL skills and proficiency with Power BI (DAX, Power Query, data modeling, data transformation). Experience with ETL tools and understanding of ERP/Business Central data structures.
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 ResponsibilitiesBI Development & ReportingDesign, 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 IntegrationExtract 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 & WarehousingBuild 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 OptimizationOptimize 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 CollaborationWork 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 QualificationsBachelor'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).