1499 Senior Microsoft 365 Data Integration

This is a remote position.

Responsibilities

Discovery and Planning

• Conduct stakeholder interviews and perform a data inventory across Microsoft 365 workloads (SharePoint Online, OneDrive, Teams, Exchange Online, Entra ID/Azure AD).

• Define scope, data models, mappings, 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 applicable).

• 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 and libraries, sites/drives/items, OneDrive, Teams channels and files, mailbox metadata, directory objects, audit and usage reports).

• Handle throttling, pagination, retries, delta synchronization, change tracking, and idempotent upserts.

• Transform and map data to target schemas; stage data (e.g., files/JSON/CSV/Parquet) and load it into the proprietary data warehouse via APIs, connectors, or batch loads.

Compliance and Governance

• Comply with data residency, retention, MIP sensitivity labels, DLP, eDiscovery, and auditing requirements.

• Navigate protected endpoints (e.g., Teams message exports) and approval processes; propose compliant alternatives when required.

Requisitos

Skills and Experience

• 5+ years building integrations with Microsoft 365, including advanced use of the Microsoft Graph API .

• Proven experience delivering data pipelines / ETL from Microsoft 365 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, and Conditional Access impacts.

  • Microsoft Graph SDKs and REST (C#/.NET or Python preferred); PowerShell for automation; Graph Explorer and Postman.

  • Handling Graph constraints: throttling, batching, pagination, delta queries, webhooks/subscriptions .

  • Data modeling and transformation ; SQL; schema evolution; metadata and lineage.

• Experience integrating custom/proprietary data warehouses (API-based or batch ingestion), including building connectors or staging layers.

• Solid understanding of Microsoft 365 security, compliance, and governance (retention, sensitivity labels, DLP, eDiscovery/audit).

• Self-starter able to operate independently in a part-time capacity, with excellent communication and documentation skills.

• Experience with Azure services (Functions, Logic Apps, Data Factory, Storage) for orchestration and staging.

• Familiarity with Graph Data Connect , SharePoint REST/CSOM , and nuances related to the deprecation of Exchange Web Services .

• Experience with CI/CD (GitHub Actions / Azure DevOps), containerization , and Infrastructure as Code (Bicep / Terraform).

• Background in performance optimization for large tenants (rate-limit strategies, parallelization, and backoff).