Job Role: Microsoft Dynamics 365 F&O; Data Architect

Job Type: Contract

Location: Remote 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 of the PE365 program. The role will ensure that Finance and Operations data is structured, governed, integrated, and made available for trusted enterprise reporting, analytics, and downstream data products. Working across the ERP implementation, business, integration, data platform, and BI teams, the Data Architect will translate operational and analytical requirements into scalable designs that support the transition from legacy systems to D365 F&O; and the future-state enterprise data platform.

Key Responsibilities

- Data architecture: Define the target-state data architecture for D365 F&O; reporting and analytics, including 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 operational domains.
- Analytical data design: Design canonical, dimensional, and semantic models that convert complex ERP data into reusable and business-friendly datasets, measures, and hierarchies.
- Data extraction and integration: Recommend and design appropriate patterns for extracting and integrating D365 F&O; data with the enterprise data platform, including near-real-time, batch, historical, and reconciliation requirements.
- Reporting enablement: Partner with BI developers and business analysts to define trusted datasets and reporting solutions for financial, operational, inventory, sales, and management reporting.
- Data mapping and documentation: Own or govern the data dictionary, source-to-target mappings, transformation rules, interface specifications, lineage, and technical metadata required by the PE365 BI and analytics stream.
- Data quality and reconciliation: Define controls for completeness, accuracy, timeliness, duplication, balance reconciliation, and exception handling between D365 F&O;, legacy sources, the data platform, and reports.
- Migration and history: Establish analytical requirements and architecture for historical data retention, legacy data access, cutover, opening balances,



comparative reporting, and coexistence during transition.
- Security and governance: Ensure analytical solutions comply with role-based access, segregation of duties, privacy, retention, auditability, and enterprise data governance standards.
- Non-functional design: Define performance, scalability, availability, recoverability, supportability, monitoring, and data refresh requirements.
- Architecture assurance: Review solution designs, integrations, customizations, and vendor deliverables for alignment with 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 and Experience
- Extensive experience designing enterprise data solutions for Microsoft Dynamics 365 Finance & Operations 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 data relationships.
- Demonstrated experience architecting ERP data integration, reporting, data warehousing, lakehouse, and semantic-layer solutions.
- Strong understanding of Microsoft data and analytics technologies such as Azure Data Lake Storage, Microsoft Fabric, OneLake, Azure Data Factory, Azure SQL, Dataverse, Synapse, Power BI, and related integration services.
- Strong understanding of Snowflake platform, Talend ETL tool.
- Experience with D365 F&O; data access and integration patterns, such as supported export, replication, API, event, 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.
- Solid communication and facilitation skills, with the ability to translate 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 modernizing legacy ERP reporting and transitioning from direct operational reporting to governed enterprise data products.

Key Deliverables
- PE365 BI reporting and analytics integration patterns and design standards.
- Business and technical data dictionary, source-to-target mappings, lineage, and transformation specifications.
- Domain data models and governed semantic models for priority reporting areas.
- Data quality, reconciliation, security, retention, and monitoring controls.
- Historical data, coexistence, cutover, and legacy reporting strategy.
- Architecture decisions, design reviews, risks, dependencies, and production-readiness assessments.

Measures of Success
- Priority PE365 reports and analytical data products are delivered with accurate, reconciled, traceable, and timely data.
- Data architecture decisions reduce custom point-to-point solutions, duplicated logic, and direct dependency on operational tables.
- Business definitions, mappings, ownership, lineage, and controls are documented and adopted by delivery and support teams.
- The solution meets agreed performance, security, audit, scalability, and supportability requirements.
- Legacy reporting and historical data transition without material disruption to finance and operations users.

Key Working Relationships The role will work closely with the PE365 Program Manager, Enterprise Architecture, BI and Analytics, Data Engineering, Data Governance, Finance, Supply Chain and Operations leaders, D365 functional and technical leads, integration and security teams, implementation partners, and application support teams.

📌 Microsoft Dynamics 365 F&O Data Architect (India)
🏢 Ignisov Consulting Services
📍 India