DynamoDB-Based User Analytics System Development

Job ID: 39365093

Budget: $30 – $250 USD

Looking for a backend developer to build a user analytics system based on DynamoDB.

Scope:

Create a new UserAnalytics table
-----------------------------------
Build a Lambda function that:

Queries a user's activities from the Activities table

Calculates:

Average activities per month

Ratio of romantic/intimate activities to all activities

Average cost per activity

Most common activity type

Most common location

Last romantic activity date

Total activities logged

Writes results back to UserAnalytics by userId

Set up an EventBridge rule to trigger Lambda every 6 hours

Lambda must handle DynamoDB pagination and partial failures cleanly
-----------
I will provide:

Activities table with seeded data

Example structures for Activities and UserAnalytics items
---------------
You will deliver:

Lambda code and deployment

IAM roles and policies

EventBridge schedule

End-to-end tested system that updates user analytics automatically
---------------------
Optional but preferred:

Ability to trigger a manual "Refresh My Stats" via API Gateway or AppSync

Priorities: fast reads, low compute costs, clean code.
Send timing and cost estimate with your proposal.