Job Title - Microsoft Dynamics 365 F&O; Data Architect

Experience Required - 8+ Years

Timezone - IST

Work Mode: Remote

Position Summary The Microsoft Dynamics 365 Finance & Operations (D365 F&O;) Data Architect will lead data architecture and technical design for the Business Intelligence (BI) and data analytics stream. The role ensures Finance and Operations data is structured, governed, integrated, and available for trusted enterprise reporting, analytics, and downstream data products.

Working across ERP implementation, business, integration, data platform, and BI teams, the architect will translate operational and analytical requirements into scalable designs supporting the transition from legacy systems to D365 F&O; and the future-state enterprise data platform.

Key Responsibilities

Data architecture

Define target-state architecture for D365 F&O; reporting and analytics across source, integration, storage, semantic,

consumption, security, and lineage layers.

ERP data model expertise

Interpret D365 F&O; tables, data entities, business events, dimensions, legal entities, reference data, and transactional structures across finance, procurement, inventory, sales, and related domains.

Analytical data design

Design canonical, dimensional, and semantic models that turn complex ERP data into reusable, business-friendly datasets,

measures, and hierarchies.

Data extraction and integration

Design extraction and integration patterns for the enterprise data platform, covering near-real-time, batch, historical, and reconciliation needs.

Reporting enablement

Partner with BI developers and business analysts on trusted datasets and reporting for financial, operational, inventory,

sales, and management reporting.

Data mapping and documentation

Own or govern data dictionaries, source-to-target mappings, transformation rules, interface specifications, lineage,



and technical metadata for the PE365 BI and analytics stream.

Data quality and reconciliation

Define controls for completeness, accuracy, timeliness, duplication, balance reconciliation, and exception handling across

D365 F&O;, legacy sources, the data platform, and reports.

Migration and history

Set analytical requirements for historical retention, legacy access, cutover, opening balances, comparative reporting, and coexistence during transition.

Security and governance

Ensure role-based access, segregation of duties, privacy, retention, auditability, and enterprise data governance requirements are met.

Non-functional design

Define performance, scalability, availability, recoverability, supportability, monitoring, and data-refresh requirements.

Architecture assurance

Review solution designs, integrations, customisations, and vendor deliverables against enterprise architecture principles and Microsoft-recommended patterns.

Delivery leadership

Support estimation, planning, dependency management, design decisions, risk resolution, testing, cutover, knowledge transfer, and production readiness for data and BI deliverables.

Required Qualifications & Experience

- Extensive experience designing enterprise data solutions for D365 F&O; in complex, multi-entity environments.
- Solid knowledge of the D365 F&O; logical and physical data model, data entities, financial dimensions, legal entities,

inventory, sales data domains, and cross-module relationships.




- Experience architecting ERP data integration, reporting, data warehousing, lakehouse, and semantic-layer solutions.
- Strong understanding of Microsoft data and analytics technologies, including Azure Data Lake Storage, Microsoft Fabric,

OneLake, Azure Data Factory, Azure SQL, Dataverse, Synapse, Power BI, and related integration services.
- Strong understanding of the Snowflake platform and Talend ETL.
- Experience with D365 F&O; data access and integration patterns, including supported export, replication, API, event-based,

and entity-based approaches.
- Proficiency in dimensional modelling, data vault or canonical modelling concepts, SQL, metadata management, master and reference data, and data lifecycle practices.
- Experience defining source-to-target mappings, reconciliation controls, data-quality rules, test strategies, and technical design documentation.
- Ability to assess standard functionality and custom extensions, identify downstream data impacts, and recommend sustainable alternatives.
- Excellent communication and facilitation skills, translating between finance and operations stakeholders, functional consultants, technical teams, delivery partners, and executives.
- Experience working within a large ERP transformation using Agile, hybrid, or stage-gated delivery methods.

Preferred Qualifications

- Microsoft certification in Dynamics 365 Finance, Supply Chain Management, Power BI, Fabric, Azure Data, or solution architecture.
- Experience with retail, distribution, inventory, merchandising, franchise, or multi-company operating models.
- Experience modernising legacy ERP reporting and moving from direct operational reporting to governed enterprise data products.

Candidate note: Strong communication skills are essential for this role.

📌 MSF & O Data Architect (Delhi)
🏢 Ekloud
📍 Delhi