SOFTWARE DEVELOPER

Roman Health Pharmacy LLC; Córdoba; Presencial; MXN 400,000 - 600,000; Jornada completa

Descripción de la vacante

A healthcare technology company is seeking a skilled professional to lead the extraction and integration of Microsoft 365 data into a proprietary data warehouse. Responsibilities include designing data extraction architectures, building reliable data pipelines, and ensuring compliance with governance standards. The candidate should have over 5 years of experience integrating with Microsoft 365 and a strong background in data management, security, and Azure services. This role offers a monthly salary of $2,500 to $2,700.

Formación

• 5+ years building integrations with Microsoft 365.
• Proven delivery of data pipelines/ETL from M365 workloads.
• Strong expertise in OAuth 2.0 and permissions consent.

Responsabilidades

• Conduct stakeholder interviews and data inventory across M365 workloads.
• Design the extraction architecture using Microsoft Graph.
• Build robust pipelines to extract content and metadata.

Conocimientos

Building integrations with Microsoft 365

Microsoft Graph API

Data pipelines/ETL

OAuth 2.0

Azure AD app registrations

C#/.NET or Python

PowerShell for automation

Data modeling and transformation

CI/CD (GitHub Actions/Azure DevOps)

Descripción del empleo

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

$2,500 - $2,700 a month