Position : D365 F&O Data Architect : Only USA
Location : Bothell WA (Onsite/Remote)
Type of Job : Contract : 12 Months
Experience : 15+ Years
Data Architecture & Design
Design end to end data architecture for D365 F&O, covering Finance, Supply Chain, Manufacturing, and Operations modules.
Define data models, canonical schemas, and enterprise data standards aligned with business processes.
Data Integration & Platforms
Architect data movement from D365 F&O using:
Data Management Framework (DMF)
BYOD
Azure Data Lake (Export to Data Lake)
Analytics & Reporting Enablement
Enable enterprise reporting using Power BI, ensuring optimal data models and performance.
Support KPI definition, semantic modeling, and reconciliation with F&O source data.
Data Governance & Quality
Define and enforce data governance, including:
Data ownership
Data definitions and lineage
Master and reference data strategy
Implement data quality controls, validation rules, and reconciliation processes.
Ensure compliance with security, audit, and regulatory requirements.
Collaboration & Leadership
Work closely with F&O functional consultants, solution architects, data engineers, and business SMEs.
Provide architectural guidance and reviews for F&O data related design decisions.
This position description identifies the responsibilities and tasks typically associated with the performance of the position. Other relevant essential functions may be required.
What you need:
8-14 years overall IT experience
6+ years in Dynamics 365 F&O data architecture / analytics / integrations
Strong hands-on experience with Microsoft Dynamics 365 Finance & Operations data model and entities.
Deep understanding of DMF, BYOD, and Export to Data Lake patterns.
Strong SQL skills and experience handling large enterprise datasets.
Experience designing data solutions on Azure (Data Lake, Synapse, Databricks, SQL).
Experience enabling analytics using Power BI (data modeling, performance optimization).
Solid understanding of Finance and/or Supply Chain business processes.
