Database Engineer - Supabase - postgresql - setup for MFG Data - Frontend interface

Contract Full Stack Engineer – Manufacturing Data Platform Development Overview We are seeking an experienced full stack software engineer to design and implement a cloud-based manufacturing data platform to support device production testing, quality tracking, and manufacturing analytics. Our current manufacturing test workflow uses a Windows-based test application that logs production test data into Google Sheets. As we scale production and introduce contract manufacturing, we are transitioning to a structured cloud database architecture using Supabase and PostgreSQL. The contractor will be responsible for establishing the backend data infrastructure, assisting with integrating existing manufacturing test software with the new platform, and developing flexible data visualization and analytics tools for engineering and manufacturing teams. This is an opportunity to build a foundational manufacturing data system that will support production scaling, quality improvements, and future automation. Scope of Work 1. Database Architecture & Supabase Implementation Design and implement a production-ready database architecture using: Supabase PostgreSQL REST APIs Cloud-based authentication and security Responsibilities include: Define database schema for manufacturing test data Create tables and relationships for: - Device serial numbers - Production lots - Firmware versions - Hardware revisions - Test results - Calibration data - Operator information - Failure codes - Manufacturing history - Implement database indexing and optimization - Establish backup and data retention strategies - Configure user access permissions for internal teams and manufacturing partners 2. Manufacturing Test Software Integration Our existing Windows test application currently performs device testing and uploads results to Google Sheets. The contractor will: -Assist team members with replacing Google Sheets API integration with database/API integration -Develop secure REST API endpoints -Integrate authentication between the test application and backend -Design reliable data upload workflows -Handle offline operation and data synchronization considerations -Ensure robust error handling and logging Preferred experience: -C# / .NET desktop applications (current data gathering tools) -REST API development -Cloud database integration 3. Manufacturing Dashboard & Data Analytics Platform -Develop an intuitive interface for engineering, manufacturing, and quality teams. The platform should provide: High-Level Production Dashboards Examples: -Units tested per day/week/month -Production throughput -Pass/fail rates -First pass yield -Failure trends -Failure Analysis Tools Ability to analyze: -Failure categories -Failed test steps -Firmware correlation -Hardware revision correlation -Production lot trends -Time-based trends -Flexible Data Exploration The system should provide spreadsheet-like flexibility similar to Google Sheets pivot tables. Desired capabilities: -Dynamic filtering -Sorting -Grouping -Pivot-style summaries -Custom reports -Export capability (CSV/Excel) -User-defined views The implementation can be: -Web application -Desktop Windows application -Hybrid solution The priority is flexibility, maintainability, and ease of use by engineering teams. Technical Requirements Required experience: -PostgreSQL database design -Supabase platform experience -REST API development -Full stack application development -Data visualization/dashboard development -Cloud application architecture -Authentication and user management Preferred experience: -Quality systems -Production test software -Electronics manufacturing data -Statistical process control (SPC) -Yield analysis Preferred Technology Experience Backend: -PostgreSQL -Supabase -REST APIs -Python, Node.js, C#, or similar backend technologies Frontend: -React / Next.js -TypeScript -Dashboard frameworks -Data visualization libraries Desktop (optional): -C#/.NET -WPF -WinUI Analytics: -SQL reporting -Data aggregation -Pivot-style analysis tools Deliverables Phase 1 – Database Foundation -Supabase project setup -Database schema -Authentication system -API architecture documentation Phase 2 – Test Software Integration -Updated Windows tester integration -Data upload API -Error handling -Production validation Phase 3 – Manufacturing Dashboard -Production overview dashboard -Yield reporting -Failure analysis interface -Flexible data exploration tools Phase 4 – Documentation & Handoff -Database documentation -API documentation -Deployment instructions -Training for internal engineering team Contract position: Estimated duration: 3–6 months initially -Potential for ongoing support as manufacturing systems expand -Remote acceptable Ideal candidate: -Independent engineer comfortable owning architecture decisions -Able to work directly with engineering leadership -Comfortable building an initial system quickly while maintaining long-term scalability About the Product We are developing a battery-powered consumer electronics device transitioning from engineering prototypes into scaled manufacturing. The manufacturing data platform will become a critical component of our production infrastructure, supporting internal engineering teams and external manufacturing partners.