SOFTGIC S.A.S. logo

1499 Senior Microsoft 365 Data Integration

SOFTGIC S.A.S.
Full-time
Remote
United States

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).