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 structuresG/L, Sales, Purchasing, Inventory, Jobs, etc.
- Experience with ETL tools (SSIS, Azure Data Factory, or similar).
