SOFTWARE DEVELOPER
You will lead discovery, design secure app permissions, build reliable extract/transform/load pipelines, and deliver production-ready integrations with documentation and handoff. Seeking a hands-on SME who can scope, plan, and execute the end-to-end extraction of Microsoft 365 data via Microsoft Graph (and related APIs) and integrate it into a proprietary data warehousing system.
Responsibilities
• Discovery and Planning
• Conduct stakeholder interviews and data inventory across M365 workloads (SharePoint Online, OneDrive, Teams, Exchange Online, Entra ID/Azure AD).
• Define scope, data models, mapping, and success criteria; produce a project plan with milestones, risks, and estimates.
• Architecture and Security
• Design the extraction architecture using Microsoft Graph and related services (Graph SDKs, delta queries, subscriptions/webhooks, Graph Data Connect where appropriate).
• Implement Azure AD app registrations, OAuth 2.0 flows, and least-privilege permissions (delegated vs. application) aligned with Conditional Access and tenant policies.
• Data Extraction and Integration
• Build robust pipelines to extract content and metadata (e.g., SharePoint lists/libraries, sites/drives/items, OneDrive, Teams channels/files, mailbox metadata, directory objects, audit/usage reports).
• Handle throttling, pagination, retries, delta sync, change tracking, and idempotent upserts.
• Transform and map data to target schemas; stage data (e.g., files/JSON/CSV/Parquet) and load into the proprietary data warehouse via APIs, connectors, or batch loads.
• Compliance and Governance
• Respect data residency, retention, MIP sensitivity labels, DLP, eDiscovery, and auditing requirements.
• Navigate protected endpoints (e.g., Teams messages export) and approval processes; propose compliant alternatives when needed.
Skills
• 5+ years building integrations with Microsoft 365, including advanced use of Microsoft Graph API.
• Proven delivery of data pipelines/ETL from M365 workloads:...