Node.js Developer Needed for REST API Integration with Power BI & PostgreSQL
Only freelancers located in the U.S. may apply.U.S. located freelancers only
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/weekHourly
- 1-3 monthsDuration
- IntermediateExperience Level
- Remote Job
- Ongoing projectProject Type
Skills and Expertise
Activity on this job
- Proposals:20 to 50
- Interviewing:0
- Invites sent:0
- Unanswered invites:0
About the client
- USARichland1:54 PM
Explore similar jobs on Upwork
How it works
Create your free profileHighlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you wantApply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securelyFrom contract to payment, we help you work safely and get paid securely.
About Upwork
- 4.9/5(Average rating of clients by professionals)
- G2 2021#1 freelance platform
- 49,000+Signed contract every week
- $2.3BFreelancers 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