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

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

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

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

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