Power BI Developer

Accountability & Responsibilities of Role:

1. Power BI Development & Advanced Visualization

• Design, build, and deploy enterprise-level Power BI dashboards and reports.
• Develop complex data models using

  DAX, Power Query (M), and incremental refresh

  .
• Deliver data-driven insights for Finance, SCM, Sales, Procurement, HR, and E-Commerce.

2. D365 F&O Data Integration

• Extract, transform, and model data from D365 F&O tables, entities, and Data Lakes.
• Work with Entity Store, BYOD (Bring Your Own Database), and OData for optimized reporting.
• Develop solutions aligned with D365 F&O processes including:
• Financials (GL, AP, AR, Fixed Assets)
• Procurement & Sourcing
• Inventory & Warehouse
• Sales & Marketing
• Retail & POS Operations
• Collaborate with D365 functional and technical teams to ensure data accuracy and consistency.

3. AI & Machine Learning Integration

• Integrate Azure AI, Copilot, and Machine Learning models into Power BI.
• Develop AI-powered dashboards for forecasting, trend analysis, anomaly detection, and predictions.
• Work with Python/R to incorporate ML insights into D365-centric reports.

4. Data Engineering & Automation

• Build automated data pipelines using

  Azure Data Factory, ADLS, Fabric Dataflows

  and ETL/ELT methods.
• Optimize data refresh schedules, dataflows, and staging models.
• Implement data governance, lineage, and documentation across BI assets.

5. Security, Governance & Compliance

• Implement Row-Level Security (RLS) and object-level security for D365-related datasets.
• Ensure compliance with internal controls, audit requirements, and data governance frameworks.
• Maintain best practices for BI architecture, workspace structure, and naming standards.

6. Cross-Functional Collaboration

• Work with Finance, Supply Chain, Retail, and HR teams to understand reporting needs.
• Translate business KPIs into user-friendly dashboards and analytical models.
• Conduct end-user training sessions and provide ongoing support.

7. Troubleshooting & Optimization

• Perform root cause analysis and resolve BI performance issues.
• Monitor D365 F&O data pipelines and job executions.
• Continuously improve existing dashboards, dataflows, and models.