Role description
Microsoft Dynamics 365 Finance & Operations - Data Architect
Experience
8-14 years overall IT experience
6+ years in Dynamics 365 F&O data architecture / analytics / integrations
Role Overview
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. This role ensures scalable, secure, and high quality data flows across F&O, reporting platforms, and enterprise systems, enabling analytics, regulatory reporting, and data driven decision making.
Key Responsibilities
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.
- Establish patterns for transactional, analytical, and historical data consumption.
Data Integration & Platforms
- Architect data movement from D365 F&O using:
- Data Management Framework (DMF)
- BYOD
- Azure Data Lake (Export to Data Lake)
- Design integrations with Azure Data Lake, Azure Synapse, Databricks, SQL, and downstream BI platforms.
- Collaborate with integration teams on batch, near real time, and event based data flows.
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.
- Partner with functional teams to translate reporting and analytics requirements into scalable data solutions.
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.
- Contribute to documentation such as data dictionaries, architecture diagrams, and design standards.
Mandatory
- 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.
Skills
data architecture,microsoft dynamics 365 finance and operations,data governance,data integration,supply chain
About UST
UST is a global digital transformation solutions provider. For more than 20 years, UST has worked side by side with the world’s best companies to make a real impact through transformation. Powered by technology, inspired by people and led by purpose, UST partners with their clients from design to operation. With deep domain expertise and a future-proof philosophy, UST embeds innovation and agility into their clients’ organizations. With over 30,000 employees in 30 countries, UST builds for boundless impact—touching billions of lives in the process.
