Node.js Developer Needed for REST API Integration with Power BI & PostgreSQL

Posted 4 days ago

Only freelancers located in the U.S. may apply.U.S. located freelancers only

Summary

Seeking proven and Node.js development experience to build a production-ready REST API backend that will authenticate to Microsoft Power BI via Azure AD service principal, generate time-limited embed tokens for secure dashboard rendering, and retrieve real-time operational metrics from Power BI datasets using DAX queries. The system will integrate with the Anthropic Claude API using healthcare-specific system prompts, persist all analyses and audit logs in PostgreSQL with immutable compliance tracking, and deploy to Azure App Service with robust error handling, logging, and monitoring. The engagement includes full integration testing and a comprehensive security review prior to launch. ⚠️ All data in the Lovable frontend is currently generated by React components using hardcoded mock objects. There is no backend API, no database persistence, and no real data sources. This is the scope of work for your backend engineer. The primary objective for the data engineer is to deliver a secure, multi-tenant backend, replace all mocked page data with live API responses, embed Power BI dashboards with row-level security, and stand up a Claude-driven analytical agent that operates over a governed semantic model. SUCCESS CRITERIA 1. All 3 endpoints deployed and tested 2. Frontend Dashboard.tsx renders real Power BI embed 3. Frontend AIInsights.tsx displays Claude analysis 4. ActionPlanContext replaced with server-backed CRUD 5. PostgreSQL audit log captures all API calls 6. Security review passed 7. Load test: 50 concurrent users, less than 300ms p95 8. Power BI RLS verified between test orgs 9. Documentation + runbooks delivered 10. Zero unhandled errors in production 11. Launch in mid-June 2026

  • Less than 30 hrs/week
    Hourly
  • 1-3 months
    Duration
  • Intermediate
    Experience Level
  • Remote Job
  • Ongoing project
    Project Type
Skills and Expertise
Mandatory skills
RESTful API
API
PostgreSQL Programming
Activity on this job
  • Proposals:20 to 50
  • Interviewing:
    0
  • Invites sent:
    0
  • Unanswered invites:
    0
About the client
Member since Apr 28, 2026
  • USA
    Richland8:58 PM

Explore similar jobs on Upwork

Cin 7 Core and QuickBooks Integration SpecialistFixed-price‐ Posted 1 month ago
Intuit QuickBooks
Accounting
Bookkeeping
Windows Administration
Git
WordPress
PHP
MySQL
JavaScript

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo