Companies in this catalog do not charge applicants. Never send money to apply.
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.
