Back to Careers
Oct 29, 2026
Data Engineering
Remote
8 - 12 Years
Microsoft Dynamics 365 F&O Data Architect
Job ID:
MT139
Oct 29, 2026
Data Engineering
Remote
8 - 12 Years
Job Description
The Microsoft Dynamics 365 Finance & Operations (D365 F&O) Data Architect will lead data architecture and technical design for Business Intelligence (BI) and data analytics. The role ensures Finance and Operations data is structured, governed, integrated, and available for reliable enterprise reporting, analytics, and downstream data products.
The architect will collaborate with ERP implementation, business, integration, data platform, and BI teams to translate operational and analytical requirements into scalable solutions supporting the transition from legacy systems to D365 F&O and the future-state enterprise data platform.
Key Responsibilities
1. Data Architecture
Define target-state architecture for D365 F&O reporting and analytics across source, integration, storage, semantic, consumption, security, and lineage layers.
Ensure scalable, maintainable, and governed enterprise data architecture.
2. ERP Data Model Expertise
Interpret D365 F&O tables, data entities, business events, dimensions, legal entities, reference data, and transactional structures.
Understand data relationships across Finance, Procurement, Inventory, Sales, and related domains.
3. Analytical Data Design
Design canonical, dimensional, and semantic models.
Develop reusable, business-friendly datasets, measures, and hierarchies.
4. Data Extraction and Integration
Design data extraction and integration patterns for batch, near-real-time, historical, and reconciliation requirements.
Evaluate supported export, replication, API, event-based, and entity-based integration approaches.
5. Reporting Enablement
Collaborate with BI developers and business analysts to deliver trusted datasets for financial, operational, inventory, sales, and management reporting.
6. Data Mapping and Documentation
Govern data dictionaries, source-to-target mappings, transformation rules, interface specifications, data lineage, and technical metadata.
7. Data Quality and Reconciliation
Define controls for data completeness, accuracy, timeliness, duplication, balance reconciliation, and exception handling across D365 F&O, legacy systems, data platforms, and reports.
8. Migration and Historical Data
Define requirements for historical data retention, legacy access, cutover, opening balances, comparative reporting, and coexistence during transition.
9. Security and Governance
Ensure role-based access, segregation of duties, privacy, retention, auditability, and enterprise data governance requirements.
10. Non-Functional Design
Define performance, scalability, availability, recoverability, supportability, monitoring, and data-refresh requirements.
11. Architecture Assurance and Delivery Leadership
Review solution designs, integrations, customizations, and vendor deliverables against enterprise architecture principles and Microsoft-recommended patterns.
Support estimation, planning, dependency management, design decisions, risk resolution, testing, cutover, knowledge transfer, and production readiness.
Required Qualifications and Experience
Extensive experience designing enterprise data solutions for D365 F&O in complex, multi-entity environments.
Strong 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 (ADLS), Microsoft Fabric, OneLake, Azure Data Factory (ADF), Azure SQL, Dataverse, Synapse, and Power BI.
Strong understanding of Snowflake 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 solutions.
Excellent communication and facilitation skills, with the ability to collaborate across Finance and Operations stakeholders, functional consultants, technical teams, delivery partners, and executives.
Experience working within large ERP transformation programmes using Agile, hybrid, or stage-gated delivery methodologies.
Preferred Qualifications
Microsoft certifications in Dynamics 365 Finance, Supply Chain Management, Power BI, Fabric, Azure Data, or Solution Architecture.
Experience in retail, distribution, inventory, merchandising, franchise, or multi-company operating models.
Experience modernizing legacy ERP reporting and transitioning from direct operational reporting to governed enterprise data products.
Important: Strong communication skills are essential for this role.
The architect will collaborate with ERP implementation, business, integration, data platform, and BI teams to translate operational and analytical requirements into scalable solutions supporting the transition from legacy systems to D365 F&O and the future-state enterprise data platform.
Key Responsibilities
1. Data Architecture
Define target-state architecture for D365 F&O reporting and analytics across source, integration, storage, semantic, consumption, security, and lineage layers.
Ensure scalable, maintainable, and governed enterprise data architecture.
2. ERP Data Model Expertise
Interpret D365 F&O tables, data entities, business events, dimensions, legal entities, reference data, and transactional structures.
Understand data relationships across Finance, Procurement, Inventory, Sales, and related domains.
3. Analytical Data Design
Design canonical, dimensional, and semantic models.
Develop reusable, business-friendly datasets, measures, and hierarchies.
4. Data Extraction and Integration
Design data extraction and integration patterns for batch, near-real-time, historical, and reconciliation requirements.
Evaluate supported export, replication, API, event-based, and entity-based integration approaches.
5. Reporting Enablement
Collaborate with BI developers and business analysts to deliver trusted datasets for financial, operational, inventory, sales, and management reporting.
6. Data Mapping and Documentation
Govern data dictionaries, source-to-target mappings, transformation rules, interface specifications, data lineage, and technical metadata.
7. Data Quality and Reconciliation
Define controls for data completeness, accuracy, timeliness, duplication, balance reconciliation, and exception handling across D365 F&O, legacy systems, data platforms, and reports.
8. Migration and Historical Data
Define requirements for historical data retention, legacy access, cutover, opening balances, comparative reporting, and coexistence during transition.
9. Security and Governance
Ensure role-based access, segregation of duties, privacy, retention, auditability, and enterprise data governance requirements.
10. Non-Functional Design
Define performance, scalability, availability, recoverability, supportability, monitoring, and data-refresh requirements.
11. Architecture Assurance and Delivery Leadership
Review solution designs, integrations, customizations, and vendor deliverables against enterprise architecture principles and Microsoft-recommended patterns.
Support estimation, planning, dependency management, design decisions, risk resolution, testing, cutover, knowledge transfer, and production readiness.
Required Qualifications and Experience
Extensive experience designing enterprise data solutions for D365 F&O in complex, multi-entity environments.
Strong 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 (ADLS), Microsoft Fabric, OneLake, Azure Data Factory (ADF), Azure SQL, Dataverse, Synapse, and Power BI.
Strong understanding of Snowflake 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 solutions.
Excellent communication and facilitation skills, with the ability to collaborate across Finance and Operations stakeholders, functional consultants, technical teams, delivery partners, and executives.
Experience working within large ERP transformation programmes using Agile, hybrid, or stage-gated delivery methodologies.
Preferred Qualifications
Microsoft certifications in Dynamics 365 Finance, Supply Chain Management, Power BI, Fabric, Azure Data, or Solution Architecture.
Experience in retail, distribution, inventory, merchandising, franchise, or multi-company operating models.
Experience modernizing legacy ERP reporting and transitioning from direct operational reporting to governed enterprise data products.
Important: Strong communication skills are essential for this role.
Job Overview
Location
Remote
Job Type
Contract
Key Skills
Microsoft Dynamics 365 F&O, D365 F&O Data Architecture, D365 F&O Data Model, D365 F&O Tables & Data Entities, Finance & Financial Dimensions, Procurement & Inventory Data, Azure Data Lake Storage (ADLS), Microsoft Fabric & OneLake, Azure Data Factory (ADF), Azure Synapse & Azure SQL, Snowflake, Talend ETL, Power BI & Semantic Modelling, SQL, Dimensional Data Modelling, ERP Data Integration, Source-to-Target Mapping, Data Lineage & Metadata Management, Data Quality & Financial Reconciliation, Data Migration & Governance.