Senior API Integrator (Azure + Power BI)

Employment Type: Contract / Project-Based (Remote)
Experience Level: Senior (3+ years API integrations; Azure + Power BI)
Salary/Rate: $18–$35/hour (contract)
Hours Required: Flexible; 2–4 hours/day overlap with America/Chicago
Shift: Flexible (with overlap)

Job Description:
Build reliable, refreshable integrations from business apps into Azure (Blob/SQL/Lake) and surface data in Power BI. You will implement secure auth, pagination, incremental loads, logging/alerts, and provide concise documentation and handoff.

Tools/Tech: Azure Logic Apps, Azure Functions, Azure Data Factory, Azure SQL/Blob/Lake, Power BI (datasets/dataflows), Python and/or PowerShell, Azure AD App Registrations, Key Vault, App Insights/Log Analytics.

Target Platforms (initial wave):
Neos, Filevine, QuickBooks, RingCentral, Sakari, Case Status, Meta/Facebook/Instagram, YouTube, TikTok, Mailchimp, Sprout Social, Microsoft 365, Google Analytics, ActivTrak, Clockify, CallRail. (Phased delivery.)

Responsibilities:

Map APIs (auth/scopes, pagination, rate limits, webhooks); confirm field coverage.

Implement connectors (Logic Apps/Functions/ADF) landing raw + curated layers in Azure.

Design incremental, idempotent loads with retries/backoff and basic DQ checks.

Wire Power BI with scheduled refresh; implement logging/alerts.

Provide a short runbook, env/Key Vault map, and test to prod steps.

Qualifications:

3+ yrs production REST integrations (OAuth2/token refresh, JSON, pagination, webhooks).

Strong Azure (Logic Apps or Functions; ADF; App Registrations; Key Vault; App Insights/Log Analytics).

Azure SQL/Blob/Lake; ELT/ETL patterns; Power BI connectivity.

Python and/or PowerShell; clear written English and documentation.

Nice to Have:
Experience with any listed platforms; BI modeling basics; CI/CD (Bicep/Terraform/GitHub Actions).

How to Apply (single message):

“API Integrator – [Name] – [$Rate/hr USD] – [Hours/week]”

2–3 production integrations (stack, auth, error handling, refresh cadence)

Azure + Power BI example (scheduling/monitoring)

20–30 lines showing pagination + retry/backoff (Python or PowerShell)

Availability vs America/Chicago