database developer
Budget: $3,000 – $5,000 USD
Project Title:
AWS-Powered Client Dashboard for Healthcare Data Management
Overview:
We are looking for an experienced React and AWS developer to build a secure, scalable, and user-friendly web application to manage healthcare client data. The application must provide real-time data visualization, role-based access control, and multiple data input methods, including JSON and CSV file uploads and direct data entry via forms.
The backend will be powered by AWS Cognito for user authentication and AWS DynamoDB for data storage, ensuring the highest levels of data security, accessibility, and performance. The application will be deployed using AWS Amplify or S3 with CloudFront for easy scaling and distribution. Familiarity with healthcare data privacy standards (e.g., HIPAA) is a plus.
Project Goals & Features:
? 1. User Authentication & Access Control (Amazon Cognito)
Implement AWS Cognito User Pools for handling user registration, login, and authentication.
Define user roles:
Admin: Full access to the dashboard, including the ability to upload files, manage users, and view all accounts.
Staff: Access to assigned accounts and overall account overview.
Client: Restricted access to their own account data only.
Implement role-based access controls to ensure users can only access data relevant to their role.
? 2. Data Storage & Management (Amazon DynamoDB)
Create two DynamoDB tables:
Users Table: Stores user-related information (userId, role, name, email, etc.).
Clients Table: Stores client-related data (userId, clientId, name, revenue, claimsSubmitted, claimsApproved, claimsDenied, data).
Apply AWS IAM Policies to restrict access to DynamoDB based on user roles.
Ensure efficient querying of data for visualization purposes.
? 3. Data Upload & Input Methods
JSON & CSV File Uploads (Admin Only):
Implement file upload components that allow .json and .csv file uploads.
Parse files using SheetJS (XLSX) for .csv files.
Store parsed data to DynamoDB under the appropriate user account.
Automatically refresh the dashboard after data upload.
Direct Data Entry Form:
Provide a form for adding client data manually.
Store the entered data to DynamoDB with the correct user association.
? 4. Data Visualization (Recharts Library)
Display data using interactive charts and graphs:
Bar Charts: Show cumulative data for all clients (revenue, claims, etc.).
Line Charts & Pie Charts: Display individual client data over time.
Overall View & Drill-Down Capability: Allow users to navigate between overall summaries and detailed client-specific views.
Implement search, filtering, and sorting functionalities for better usability.
? 5. Security & Access Management
Apply AWS Cognito’s Identity and Access Management (IAM) for secure data access.
Restrict access to resources based on user roles (Admins, Staff, Clients).
Implement proper data validation to prevent unauthorized data uploads.
? 6. Deployment & Hosting (AWS Amplify or S3/CloudFront)
Deploy the application using AWS Amplify for easy CI/CD and hosting.
Alternatively, configure deployment using Amazon S3 for static files and CloudFront for global distribution.
Ensure the application is highly available, scalable, and secure.
? 7. Testing & Quality Assurance
Test all functionalities for each user role (Admin, Staff, Client).
Validate file upload processes and confirm correct data storage in DynamoDB.
Test user authentication, data visualization, and data entry.
Implement automated and manual testing procedures.
? 8. Documentation & Handover
Provide clear documentation for:
Setting up AWS resources (Cognito, DynamoDB, Amplify).
Uploading files and entering data.
User roles and permissions management.
Data visualization functionalities.
Provide a comprehensive README file detailing the project setup, usage, and deployment procedures.
? Technical Requirements:
? Frontend:
React (with Tailwind CSS for styling)
AWS SDK (JavaScript) for interacting with AWS services.
Recharts for data visualization.
Support for CSV parsing using SheetJS (XLSX).
☁️ Backend (AWS Services):
Amazon Cognito: User authentication and role-based access.
Amazon DynamoDB: NoSQL Database for storing user and client data.
AWS Amplify / S3 & CloudFront: For application deployment and distribution.
? Timeline:
Estimated Timeline: 3 - 5 weeks (Based on complexity and developer availability).
? Budget:
Estimated Budget: $4,000 - $8,000 (Depending on experience and expertise).
? Preferred Skills:
Proven experience with AWS services (Cognito, DynamoDB, Amplify, S3, CloudFront).
Strong skills in React, JavaScript, Tailwind CSS, Recharts, and AWS SDK.
Familiarity with healthcare data privacy standards (e.g., HIPAA) is a plus.
Demonstrated ability to build scalable, secure, and efficient web applications.
? How to Apply:
Please provide:
Examples of past work using AWS services.
Proposed approach to building this application.
Estimated timeline and budget.
Confirmation of familiarity with handling sensitive healthcare data.
AWS-Powered Client Dashboard for Healthcare Data Management
Overview:
We are looking for an experienced React and AWS developer to build a secure, scalable, and user-friendly web application to manage healthcare client data. The application must provide real-time data visualization, role-based access control, and multiple data input methods, including JSON and CSV file uploads and direct data entry via forms.
The backend will be powered by AWS Cognito for user authentication and AWS DynamoDB for data storage, ensuring the highest levels of data security, accessibility, and performance. The application will be deployed using AWS Amplify or S3 with CloudFront for easy scaling and distribution. Familiarity with healthcare data privacy standards (e.g., HIPAA) is a plus.
Project Goals & Features:
? 1. User Authentication & Access Control (Amazon Cognito)
Implement AWS Cognito User Pools for handling user registration, login, and authentication.
Define user roles:
Admin: Full access to the dashboard, including the ability to upload files, manage users, and view all accounts.
Staff: Access to assigned accounts and overall account overview.
Client: Restricted access to their own account data only.
Implement role-based access controls to ensure users can only access data relevant to their role.
? 2. Data Storage & Management (Amazon DynamoDB)
Create two DynamoDB tables:
Users Table: Stores user-related information (userId, role, name, email, etc.).
Clients Table: Stores client-related data (userId, clientId, name, revenue, claimsSubmitted, claimsApproved, claimsDenied, data).
Apply AWS IAM Policies to restrict access to DynamoDB based on user roles.
Ensure efficient querying of data for visualization purposes.
? 3. Data Upload & Input Methods
JSON & CSV File Uploads (Admin Only):
Implement file upload components that allow .json and .csv file uploads.
Parse files using SheetJS (XLSX) for .csv files.
Store parsed data to DynamoDB under the appropriate user account.
Automatically refresh the dashboard after data upload.
Direct Data Entry Form:
Provide a form for adding client data manually.
Store the entered data to DynamoDB with the correct user association.
? 4. Data Visualization (Recharts Library)
Display data using interactive charts and graphs:
Bar Charts: Show cumulative data for all clients (revenue, claims, etc.).
Line Charts & Pie Charts: Display individual client data over time.
Overall View & Drill-Down Capability: Allow users to navigate between overall summaries and detailed client-specific views.
Implement search, filtering, and sorting functionalities for better usability.
? 5. Security & Access Management
Apply AWS Cognito’s Identity and Access Management (IAM) for secure data access.
Restrict access to resources based on user roles (Admins, Staff, Clients).
Implement proper data validation to prevent unauthorized data uploads.
? 6. Deployment & Hosting (AWS Amplify or S3/CloudFront)
Deploy the application using AWS Amplify for easy CI/CD and hosting.
Alternatively, configure deployment using Amazon S3 for static files and CloudFront for global distribution.
Ensure the application is highly available, scalable, and secure.
? 7. Testing & Quality Assurance
Test all functionalities for each user role (Admin, Staff, Client).
Validate file upload processes and confirm correct data storage in DynamoDB.
Test user authentication, data visualization, and data entry.
Implement automated and manual testing procedures.
? 8. Documentation & Handover
Provide clear documentation for:
Setting up AWS resources (Cognito, DynamoDB, Amplify).
Uploading files and entering data.
User roles and permissions management.
Data visualization functionalities.
Provide a comprehensive README file detailing the project setup, usage, and deployment procedures.
? Technical Requirements:
? Frontend:
React (with Tailwind CSS for styling)
AWS SDK (JavaScript) for interacting with AWS services.
Recharts for data visualization.
Support for CSV parsing using SheetJS (XLSX).
☁️ Backend (AWS Services):
Amazon Cognito: User authentication and role-based access.
Amazon DynamoDB: NoSQL Database for storing user and client data.
AWS Amplify / S3 & CloudFront: For application deployment and distribution.
? Timeline:
Estimated Timeline: 3 - 5 weeks (Based on complexity and developer availability).
? Budget:
Estimated Budget: $4,000 - $8,000 (Depending on experience and expertise).
? Preferred Skills:
Proven experience with AWS services (Cognito, DynamoDB, Amplify, S3, CloudFront).
Strong skills in React, JavaScript, Tailwind CSS, Recharts, and AWS SDK.
Familiarity with healthcare data privacy standards (e.g., HIPAA) is a plus.
Demonstrated ability to build scalable, secure, and efficient web applications.
? How to Apply:
Please provide:
Examples of past work using AWS services.
Proposed approach to building this application.
Estimated timeline and budget.
Confirmation of familiarity with handling sensitive healthcare data.