DW Architect and Engg.

HEXAWARE • United States,

10d

About The Position

This role involves inventorying and reverse-engineering business-critical M365 and Power Platform workloads, including SharePoint lists and libraries, Dataverse tables, Power Apps, and Power Automate flows, to pinpoint the location of business processes and critical data. The position requires documenting entities and process flows within these applications, including informal processes outside core enterprise systems. A key responsibility is producing source-to-target mappings (Bronze → Silver → Gold) for M365 sources, detailing transformation rules and data quality defects. The role also includes defining M365 contributions to DNA crosswalk keys, reconciling identifiers against core enterprise systems, and collaborating with Security and Compliance to ensure data extraction adheres to sensitivity labeling, retention, and access requirements. Additionally, the position involves defining data quality gates and confidence scoring for M365-sourced KPIs, stewarding them through certification, and supporting pipeline development, automated testing, and validation of Gold outputs.

Requirements

• 4+ years working with the Microsoft 365 and Power Platform stack in a data, integration or solution capacity.
• Hands-on experience with Dataverse, SharePoint Online data structures, Microsoft Graph API, and Power Platform dataflows.
• Demonstrated ability to reverse-engineer distributed or informally governed application estates into a coherent entity model.
• Strong SQL and data-profiling skills.
• Working knowledge of M365 security, sensitivity labelling and compliance constraints as they affect data extraction.

Responsibilities

• Inventory and reverse-engineer business-critical M365 and Power Platform workloads (SharePoint lists and libraries, Dataverse tables, Power Apps, Power Automate flows) to identify where business processes and business-critical data genuinely live.
• Document the true entities and process flows carried in these applications, including shadow processes that have grown up outside core enterprise systems.
• Produce Bronze → Silver → Gold source-to-target mappings for the in-scope M365 sources, including transformation rules and data-quality defects.
• Define the M365 contribution to DNA crosswalk keys and reconcile identifiers (people, projects, sites, assets) against the core enterprise systems.
• Work with Security and Compliance to ensure extraction respects sensitivity labelling, retention, and identity/access requirements.
• Define data-quality gates and confidence scoring for M365-sourced KPIs and steward them through certification.
• Support pipeline development, automated testing, and validation of Gold outputs.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed