Data Warehouse Architect

Job Summary

To support critical business processes, the full-time Data Warehouse Architect will inventory and reverse-engineer M365 and Power Platform workloads, documenting entities and process flows while ensuring data quality and compliance in a remote environment.

Key responsibilities

• Inventory and document business-critical M365 and Power Platform workloads, including SharePoint and Dataverse
• Produce source-to-target mappings and define transformation rules for data extraction processes
• Collaborate with Security and Compliance teams to ensure data extraction adheres to sensitivity and retention requirements

Required qualifications

• 4+ years of experience with Microsoft 365 and Power Platform in a data, integration, or solution capacity
• Hands-on experience with Dataverse, SharePoint Online, Microsoft Graph API, and Power Platform dataflows
• Proven ability to reverse-engineer distributed application estates into coherent entity models
• Strong SQL and data profiling skills
• Working knowledge of M365 security and compliance constraints related to data extraction