Microsoft Dynamics 365 F&O Data Architect

The HR Ally; Bengaluru; Remote; INR 3,500,000 - 7,000,000; Part time

Job summary

The HR Ally seeks an experienced Microsoft Dynamics 365 F&O Data Architect for a 6-month contract (with extension). The role is remote from India with US EST hours, requiring 8+ years in enterprise data architecture and ERP data integration.

You will design target-state D365 F&O data architecture, data models, and data governance to enable reliable financial and operational reporting. You will partner with BI developers and analysts to implement canonical data models, secure data sharing, and

Qualifications

• Extensive experience designing enterprise data solutions for Microsoft Dynamics 365 Finance & Operations in complex environments.
• Strong knowledge of the D365 F&O data model, data entities, dimensions, and cross-module relationships.
• Experience architecting ERP data integration, reporting, data warehousing, and semantic-layer solutions.
• Proficiency with Azure data technologies and related analytics tools (Power BI, Dataverse, Synapse).
• Experience with Snowflake and Talend ETL tools.
• Ability to design source-to-target mappings, data quality rules, and technical design documents.

Responsibilities

• Define target-state data architecture for D365 F&O reporting and analytics.
• Interpret ERP data models across finance, procurement, inventory, and sales.
• Design canonical and semantic data models for datasets, measures, and hierarchies.
• Design patterns for extracting and integrating D365 F&O data with the data platform.
• Collaborate with BI teams to create trusted datasets and reports.
• Own data dictionary, mappings, lineage, and metadata for the BI stream.
• Define data quality controls and reconciliation strategies.
• Plan historical data retention and cutover during transition.
• Ensure security, governance, and compliance in analytics solutions.
• Oversee architecture reviews and production-readiness for data/BI deliverables.

Skills

D365 F&O data model

Azure data stack

SQL

Data warehousing

Dimensional modelling

Tools

Snowflake

Talend ETL

Power BI

Azure Synapse

Job description

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.