Microsoft Dynamics 365 F&O Data Architect

Role: Microsoft Dynamics 365 F&O Data Architect
Location: India – Remote (work US EST hours)

Experience: 8+ yrs of experience

Contract: 6 months contract + possible extension

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.
• Strong 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.

Originally posted on Himalayas