Microsoft Dynamics 365 F&O Data Architect

Job Title: Microsoft Dynamics 365 F&O Data Architect



Work Arrangement: Remote USA and Canada



Employment Type: Contract Job Summary

We are seeking an experienced Microsoft Dynamics 365 Finance and Operations Data Architect to lead data architecture and technical design for enterprise Business Intelligence and data analytics initiatives.

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.

The ideal candidate will bring deep expertise in Microsoft Dynamics 365 F&O data architecture, enterprise data modeling, Microsoft Fabric, OneLake, Azure Data Lake, Azure Data Factory, Power BI, Dataverse, Synapse, Snowflake, data integration, governance, and ERP transformation .

Key Responsibilities

• Define target-state data architecture for D365 F&O reporting and analytics , including source, integration, storage, semantic, consumption, security, and lineage layers.
• Interpret D365 F&O tables, data entities, business events, dimensions, legal entities, reference data, and transactional structures.
• Design canonical, dimensional, and semantic data models for enterprise reporting and analytics.
• Define integration patterns for extracting and integrating D365 F&O data with enterprise data platforms.
• Design solutions supporting near-real-time, batch, historical, and reconciliation requirements .
• Partner with BI developers and business analysts to create trusted datasets and reporting solutions.
• Own or govern data dictionaries, source-to-target mappings, transformation rules, lineage, interface specifications, and technical metadata.
• Establish controls for data completeness, accuracy, timeliness, duplication, reconciliation, and exception handling.
• Define architecture for historical-data retention, legacy access, cutover, opening balances, comparative reporting, and coexistence during transformation.
• Ensure analytical solutions comply with security, role-based access, segregation of duties, privacy, retention, and auditability requirements.
• Define performance, scalability, availability, recoverability, supportability, monitoring, and refresh requirements.
• Review solution designs, integrations, customizations, and technical deliverables.
• Support planning, estimation, dependency management, risk resolution, testing, cutover, knowledge transfer, and production readiness.

Required Qualifications

• Extensive experience designing enterprise data solutions for Microsoft Dynamics 365 Finance and Operations in complex environments.
• Strong knowledge of the D365 F&O logical and physical data model.
• Experience with data entities, financial dimensions, legal entities, inventory, sales, and cross-module data relationships.
• Experience architecting ERP data integration, reporting, data warehousing, lakehouse, and semantic-layer solutions.
• Strong knowledge of Microsoft data and analytics technologies, including:
  • Microsoft Fabric
  • OneLake
  • Azure Data Lake Storage
  • Azure Data Factory
  • Azure SQL
  • Dataverse
  • Synapse
  • Power BI
• Understanding of Snowflake and Talend ETL .
• Experience with D365 F&O data access and integration patterns, including supported exports, replication, APIs, events, and entity-based approaches.
• Strong proficiency in SQL, dimensional modeling, data-vault or canonical modeling, metadata management, master and reference data, and data lifecycle practices .
• Experience defining source-to-target mappings, reconciliation controls, data-quality rules, testing strategies, and technical documentation.
• Strong understanding of enterprise data governance, security, lineage, retention, and auditability .
• Excellent communication and facilitation skills with the ability to work across business and technical teams.
• Experience supporting large ERP transformation programs.

Preferred Qualifications

• Microsoft certifications related to Dynamics 365 Finance, Supply Chain Management, Power BI, Microsoft Fabric, Azure Data, or Solution Architecture .
• Experience in retail, distribution, inventory, merchandising, franchise, or multi-company operating environments.
• Experience modernizing legacy ERP reporting and transitioning to governed enterprise data products.

Key Deliverables

• D365 F&O BI and analytics integration architecture and design standards.
• Business and technical data dictionaries.
• Source-to-target mappings, lineage, and transformation specifications.
• Domain and governed semantic data models.
• Data quality, reconciliation, security, retention, and monitoring controls.
• Historical-data and legacy-reporting transition strategy.
• Architecture decisions, design reviews, risk management, dependency tracking, and production-readiness assessments.