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.

Requirements

5+ years building integrations with Microsoft 365, including advanced use of Microsoft Graph API.
Proven delivery of data pipelines/ETL from M365 workloads:
SharePoint Online and OneDrive (sites, lists, libraries, drives/files, permissions).
Teams (channels, files; familiarity with protected chat/meeting export APIs and compliance boundaries).
Exchange Online (mailbox and message metadata, calendars) and directory objects in Entra ID (Azure AD). Strong expertise in:
OAuth 2.0, Azure AD app registrations, permissions consent, service principals, Conditional Access impacts.
Graph SDKs and REST (C#/.NET or Python preferred); PowerShell for automation; Graph Explorer/Postman.
Handling Graph constraints: throttling, batching, pagination, delta queries, webhooks/subscriptions.
Data modeling and transformation; SQL; schema evolution; metadata and lineage.
Experience integrating with custom/proprietary data warehouses (API-based or batch ingestion), including building connectors or staging layers.
Solid understanding of M365 security, compliance, and governance (retention, labels, DLP, eDiscovery/audit).
Self-starter who can operate independently in a part-time capacity; excellent communication and documentation.
Experience with Azure services (Functions, Logic Apps, Data Factory, Storage) for orchestration and staging.
Familiarity with Graph Data Connect, SharePoint REST/CSOM, Exchange Web Services deprecation nuances.
CI/CD (GitHub Actions/Azure DevOps), containerization, and IaC (Bicep/Terraform).
Background in performance tuning for large tenants (rate-limit strategy, parallelization, backoff).

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills

Microsoft Graph APIdata pipelinesETLOAuth 2.0Graph SDKsC#PythonSQLdata modelingmetadata

Soft skills

excellent communicationdocumentationself-starterindependent operation