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.
