Associate Data Architect I

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.

data architecture,data governance,database management,data integration,