DynamoDB-Based User Analytics System Development
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.
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.