Backend Developer for OAuth and Social Media Analytics API Integration
Worldwide
We have a client reporting portal that currently pulls social media analytics through a third party provider. We are looking for an experienced backend developer to help us replace that provider with direct API connections to the major social platforms. Eventually, the portal will connect directly to Instagram, Facebook, YouTube, TikTok and LinkedIn. The goal is for clients to connect their own accounts securely through OAuth, without ever needing to provide passwords or API tokens. Our system should then securely store credentials, pull analytics on a schedule and save that data into our database. For the first phase, we want to keep things focused. You will review our existing portal and current integration, recommend the right architecture, design the OAuth and token storage process and build one working proof of concept. We expect to begin with either Meta or YouTube and will decide which platform makes the most sense after the initial technical review. The proof of concept should include: One working OAuth connection Secure access and refresh token storage A small set of account and content metrics pulled directly from the API Sample data saved into a test database Recommended database structure for future social metrics Documentation covering setup, permissions, risks and next steps Source code and setup instructions An estimate for completing the remaining platform integrations If the first phase goes well, there is a much larger project available. Future work would include Facebook and Instagram, YouTube, TikTok and LinkedIn integrations, scheduled data syncing, token refresh and reconnection, rate limit handling, failed sync alerts, historical snapshots, data normalization, dashboard integration, testing and deployment. We are ultimately looking to collect metrics such as followers, subscriber growth, views, reach, impressions, likes, comments, shares, saves, watch time, profile visits and individual content performance. We understand that available data varies depending on each platform and its approved permissions. You should have strong experience with OAuth 2.0, REST APIs, secure token storage, refresh tokens, databases, scheduled jobs, API rate limits and error handling. You must also have hands on experience with at least two of the following: Meta Graph API Instagram API Facebook API YouTube Data API YouTube Analytics API TikTok API LinkedIn API Experience completing Meta App Review, Google OAuth verification or similar platform approval processes would be a big advantage. Security is important to us. Authorization codes should be exchanged server side, tokens encrypted at rest, app secrets kept outside the main database and only the permissions actually required should be requested. All work will be completed using company owned repositories, developer apps, hosting accounts and cloud services. All code and documentation created during the project will belong to our company. We are looking for someone who communicates clearly, identifies platform limitations before promising features, documents their work properly and raises problems early. This is not a job where we want to become dependent on one developer. The code should be modular, understandable and easy for another developer to take over in the future. We plan to run the first phase as a fixed price project with funded milestones covering: Technical review and architecture OAuth and database proof of concept Testing, documentation and handover To apply, please start your proposal with the words **DIRECT API** so we know you have read the description. Then briefly tell us: Which social platform API you know best An OAuth integration you have built before How you handled token storage and renewal Whether you have completed Meta App Review, Google verification or another platform approval Which platform you believe presents the biggest challenge in this project and why What you would include in the first proof of concept What access you would need from us Anything you think could increase the project cost or timeline How you would prevent duplicate data during scheduled syncing A relevant code sample, case study or example of similar work Please do not send a generic agency introduction. We are specifically looking for someone with real experience in OAuth, social APIs, token security and analytics integrations.
- More than 30 hrs/weekHourly
- 3-6 monthsDuration
- ExpertExperience Level
$30.00
-
$40.00
Hourly- Remote Job
- Ongoing projectProject Type
Skills and Expertise
Activity on this job
- Proposals:50+
- Last viewed by client:5 days ago
- Interviewing:3
- Invites sent:0
- Unanswered invites:0
About the client
- United StatesLos Angeles9:16 PM
- $196K total spent107 hires, 25 active
- 10,020 hours
- Sales & MarketingSmall company (2-9 people)
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