Business Intelligence & Automation Specialist

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.

Required Qualifications

• Bachelors or masters degree in computer science, Data Analytics, Information Systems, or related field.
• 5-7+ years of total BI experience, with 5+ years in Power BI development.
• Mandatory experience with Dynamics 365 F&O (Finance & Operations) data structures, entity store, data entities, and Azure SQL/BYOD.
• Strong experience with:
• DAX, M (Power Query), SQL, Data Modeling
• OData, Data Lake, and API-based integrations
• Azure AI, ML, Fabric, Synapse, ADF
• Experience in integrating AI/ML models within Power BI reports.
• Solid understanding of financial, supply chain, and retail processes within D365.

Preferred Skills

• Experience with Microsoft Fabric architecture, Lakehouse, Data Activator, and AI experiences.
• Knowledge of CI/CD and Git for BI development.
• Familiarity with ERP reporting (D365, SAP, Oracle) is a plus.
• Experience in enterprise Retail, Telecom, or E-Commerce analytics environments.

Soft Skills

• Strong analytical and problem-solving capabilities.
• Excellent communication and stakeholder-management skills.
• Ability to manage multiple projects and work under tight timelines.
• Leadership qualities with the ability to mentor junior BI developers.

WORK ENVIRONMENT

Location: Gurgaon, Haryana

On-Call: Mandatory participation in emergency response roster

Collaboration: Regular coordination with Qatar and GCC teams; meetings aligned to Middle East hours

Travel: Domestic/international travel may be required

High-pressure, fast-paced client-facing operations with strict SLA commitments