D365 F&O Data Architect

About the role

The D365 F&O Data Architect is responsible for designing, governing, and optimizing the end-to-end data architecture for Microsoft Dynamics 365 Finance & Operations. The opportunity includes designing data architecture for Finance, Supply Chain, Manufacturing, and Operations modules, defining data models, canonical schemas, and enterprise data standards aligned with business processes, enabling enterprise reporting using Power BI, and supporting KPI definition, semantic modeling, and reconciliation with F&O source data.

Responsibilities

• 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.
• Enable enterprise reporting using Power BI, ensuring optimal data models and performance.
• Support KPI definition, semantic modeling, and reconciliation with F&O source data.
• 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.
• Collaborate with F&O functional consultants, solution architects, data engineers, and business SMEs.
• Provide architectural guidance and reviews for F&O data related design decisions.

Requirements

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

Qualifications

Commensurate with experience.

Skills

• Dynamics 365 F&O data architecture / analytics / integrations
• Microsoft Dynamics 365 Finance & Operations data model and entities
• Data Management Framework (DMF)
• BYOD
• Azure Data Lake
• Power BI
• SQL
• Azure Data Lake, Synapse, Databricks, SQL
• Power BI (data modeling, performance optimization)
• Finance and/or Supply Chain business processes

Benefits

• Paid vacation
• Paid sick leave
• 10 paid holidays
• Bereavement leave
• Jury duty leave
• 401(k) Retirement Plan with employer matching
• Medical, dental, and vision insurance
• Accidental death and disability insurance
• Short- and long-term disability benefits
• Health Savings Account (HSA)
• Flexible Spending Account (FSA)