Lead II - Data Engineering

UST; Bengaluru; On-site; INR 1,500,000 - 2,500,000; Full time

Job summary

UST in Bengaluru is looking for a Data Architect for Microsoft Dynamics 365 Finance & Operations. The ideal candidate will have 8-14 years of IT experience, with 6+ years focusing on data architecture and integration in Dynamics 365. Responsibilities include designing end-to-end data architecture, ensuring data governance, and enabling analytics using Power BI. Strong SQL skills and experience with Azure Data Lake, Synapse, and Databricks are essential. The role offers the opportunity to collaborate with functional teams and lead data-related design decisions.

Qualifications

• 8-14 years of overall IT experience.
• 6+ years in Dynamics 365 Finance & Operations data architecture.
• Strong hands-on experience with Dynamics 365 data model.
• Deep understanding of DMF, BYOD, and data export patterns.
• Strong SQL skills with large enterprise datasets.
• Experience designing data solutions on Azure.

Responsibilities

• Design end-to-end data architecture for D365 F&O.
• Define data models and enterprise data standards.
• Architect data movement using DMF, BYOD, and Azure Data Lake.
• Enable reporting via Power BI; support KPI definition.
• Implement data governance and quality controls.

Skills

Data architecture

Microsoft Dynamics 365 Finance and Operations

Data governance

Data integration

Supply chain

Tools

Azure Data Lake

Azure Synapse

Databricks

Power BI

SQL

Job description

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