Summary We need an experienced AWS/backend developer to deliver pre-aggregated user KPIs, time-series endpoints for charting, and upcoming payment endpoints. The goal: provide small, fast endpoints the frontend can call (single request per dashboard load) and ensure data correctness, caching and tests.
Scope of work Build (or finalize) the following endpoints (or confirm/extend existing):
1. GET /user/{user_id}/kpis Returns: portfolio_value, total_appreciation, monthly_earning, monthly_payout, last_updated Pre-aggregated for fast reads
2. GET /user/{user_id}/upcoming-payments?days=30 Returns scheduled installments due in the next X days (property, amount, due_date)
3. GET /market/history/{area_key}?days={n} Returns time-series: [{date, price_per_sqm, valuation}] for charting
(Optional) GET /user/{id}/portfolio-snapshot/latest — aggregated per-property snapshot
Data sources & responsibilities: - Use DynamoDB table (PropertyValuations) for historical price/sqm series. - Use Monthly Snapshot Engine (Lambda) for latest snapshot/purchase_price/current_value. - Map OCR outputs (SPA) to PaymentSchedule table to compute upcoming payments.
Ensure: -Composite key time-series queries on DynamoDB are efficient and paginated -Caching layer or TTL to prevent too many DLD API calls (redis or in-Lambda cache) -Proper authentication and secure handling of API keys -Unit tests and integration tests -Swagger/OpenAPI doc for endpoints and example responses -Provide a brief data model summary and documentation for frontend mapping.
Deliverables - Implemented endpoints deployed to the existing AWS account (or provided as serverless Lambda + API Gateway definitions) - Postman collection / OpenAPI spec - Tests and instructions to run them - Short runbook describing cron/timing of snapshot ingestion and where the KPIs derive from
Acceptance criteria - /user/{user_id}/kpis returns accurate numbers for sample user (manual cross-check) - /market/history/{area_key} returns at least the last 90 days or the available historical records (non-empty) - /user/{id}/upcoming-payments lists the correct installments for sample user - All endpoints respond within acceptable latency (
Data Analytics Testing Category: BigQuery, Business Intelligence, Data Analysis, Data Modeling, Data Warehousing, ETL, Redshift, Snowflake, SQL, Testing / QA Budget: ₹1500 - ₹12500 INR
21-Feb-2026 22:52 GMT
YouTube Vlog Editor Category: Adobe Premiere Pro, After Effects, Video Editing, Video Post Editing, Video Processing, Video Services Budget: $30 - $250 USD
Adaptive Resource Research Support Category: Customer Service, Customer Support, Data Analysis, Data Collection, Data Entry, Data Management, Report Writing, Research, Research Writing, Statistics Budget: $250 - $750 USD
Sci-Fi ARPG Development Category: 3D Animation, 3D Art, 3D Modelling, 3D Rendering, Game Design, Game Development, Unity, Unreal Engine Budget: $15 - $25 USD
21-Feb-2026 22:39 GMT
Realistic Mangonados Storybook Art Category: 2D Drawing, Art Consulting, Art Installation, Caricature & Cartoons, Digital Art, Illustration, Photoshop Budget: $250 - $750 USD
