Microsoft Dynamics 365 F&O Data Architect
Mohammad YasirCanadaSENIORPosted 47m ago
Microsoft Dynamics 365 Finance & OperationsD365 F&OEnterprise Data ArchitectureData WarehousingLakehouse solutionsMicrosoft FabricOneLakeAzure Data Lake StorageAzure Data FactoryAzure SQLDataverseAzure Synapse AnalyticsPower BISnowflakeTalend ETLD365 F&O data extractionreplicationAPIsevent-based integrationDimensional Data ModelingData VaultCanonical Data ModelingSQLMetadata ManagementMaster Data ManagementSource-to-Target MappingData LineageData QualityReconciliationData GovernanceSecurityHistorical Data Migration
About the Role
We are looking for an experienced Microsoft Dynamics 365 Finance & Operations (D365 F&O) Data Architect to lead enterprise data architecture, integration, and analytical data design for a large-scale ERP transformation program.
Key Responsibilities
• Define target-state data architecture for D365 F&O reporting and analytics
• Design scalable data models and enterprise integration patterns
• Enable trusted datasets and semantic models for Power BI reporting
• Establish data quality, reconciliation, and governance standards
• Lead data migration and historical data management strategies
• Collaborate with ERP, BI, Data Engineering, Finance, and Supply Chain teams
• Drive architecture reviews, technical documentation, and production readiness
Requirements
• Extensive experience with Microsoft Dynamics 365 Finance & Operations (D365 F&O)
• Strong understanding of D365 F&O Tables, Data Entities, Financial Dimensions, and Legal Entities
• Experience with Finance, Procurement, Inventory, Sales, and cross-module data relationships
• Expertise in Enterprise Data Architecture, Data Warehousing, and Lakehouse solutions
• Strong knowledge of Microsoft Fabric, OneLake, Azure Data Lake Storage (ADLS), and Azure Data Factory (ADF)
• Experience with Azure SQL, Dataverse, Azure Synapse Analytics, and Power BI
• Strong hands-on knowledge of Snowflake and Talend ETL
• Experience with D365 F&O data extraction, replication, APIs, and event-based integration
• Expertise in Dimensional Data Modeling, Data Vault, and Canonical Data Modeling
• Strong SQL, Metadata Management, and Master Data Management skills
• Experience with Source-to-Target Mapping, Data Lineage, Data Quality, and Reconciliation
• Understanding of Data Governance, Security, and Historical Data Migration