caferemote
The HR Ally

Microsoft Dynamics 365 F&O Data Architect

Remote India Contract Posted 9 days ago
Apply now
Work from
India
Contract
Contract
Posted
11 November 2026
Apply by
10 January 2027

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

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.

Requirements

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

Nice to have

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

Discussion

No comments yet. Ask a question or share a tip about this role.

Apply now

More jobs from The HR Ally

View company →

Senior Active Directory (AD) Security Consultant-Australia Only

The HR Ally
Remote Australia Contract

Location: Anywhere in Australia (Onshore – Australian-based candidates only) Duration: 20 Days Employment Type: Contract Start: Immediate / ASAP About the…

yesterday DevOps and Sysadmin

Tech BA - India Remote

The HR Ally
Remote India Contract

Role: Tech BA Location: India – Remote (work US EST hours) Experience: 5 to 8 yrs of experience Contract: 6 months contract + possible extension NOTE:…

10 days ago Data

Similar remote jobs

Browse all →

AI Safety Expert - Bilingual

mercor
Remote United States Contract $17 – $25 / hour

About the job Mercor connects elite creative and technical talent with leading AI research labs. Headquartered in San Francisco, our investors include Benchmark , General Catalyst , Peter…

2h ago Data

Senior AI & Transformation Enablement Specialist

Datasite
Remote United States Full-time $83K – $141K / year

About us Datasite is the essential infrastructure for M&A. Also comprising Grata, Blueflame AI, and Sherpany, we help dealbreakers find opportunities, manage transactions, and make key…

3h ago Data

Business Analyst III Claims, DRG

Centene Corporation
Remote United States Full-time $70K – $126K / year

Position Purpose: Perform various analysis and interpretation to link business needs and objectives for assigned function. Key Details: Must be authorized to work in the U.S. without the…

3h ago Data

Functional Consultant – Epicor Kinetic (Operations & Supply Chain) – 100% Remote

TeccWeb
Remote United States Full-time

About Teccweb Teccweb is an Epicor Service Partner specializing in the implementation and optimization of Epicor Kinetic for mid-market manufacturers and distributors across North America.…

3h ago Data

Product Owner

Dev Partners
Remote Philippines Full-time

💻 We Are Hiring- Product Owner | 100% Remote We are seeking an experienced Product Owner to oversee and coordinate the ongoing maintenance, enhancement, and continuous improvement of an…

3h ago Data

Mechanical Engineer III

DLB Associates
Remote United States Full-time $105K – $135K / year

DLB Associates is a premier engineering and consulting firm specializing in innovative, mission-critical solutions across hyperscale data centers, advanced infrastructure, and…

4h ago Data

Get remote jobs the moment they are posted

Choose your categories and skills. We push matching jobs to your device. No email, ever.