Full Stack Engineer

We are seeking a Full Stack Developer to join our team working on a sophisticated portfolio management platform. This is a monthly rolling contract position with the potential for long-term engagement based on mutual fit., Your primary responsibilities will fall within ONE of the following three areas based on your strengths and project priorities:

1. Admin Panel & AI Pipeline Development

Focus Area: Backend administration and document processing automation

Core Responsibilities:

• Develop and enhance the admin dashboard
• Implement and optimize the AI-powered document ingestion pipeline
• Design and implement server actions for admin workflows
• Build file upload and processing systems
• Create validation and error handling for bulk data imports (CSV, XLSX, PDF)
• Optimize database queries and create PostgreSQL functions for admin operations
• Implement Row-Level Security (RLS) policies for multi-tenant data access

Ideal Skills:

• Strong backend development experience
• Familiarity with LangChain, OpenAI API, Anthropic API, and LLM pipelines
• Experience with document processing and data extraction
• Knowledge of vector databases and semantic search
• PostgreSQL expertise including functions, triggers, and RLS

1. Client-Facing Application & New Features

Focus Area: User-facing product development and feature expansion

Core Responsibilities:

• Build and enhance client-facing dashboards and visualization components
• Develop new features for the portfolio management interface:
• Performance analyses
• Interactive charts and data visualizations using ApexCharts
• Directory pages with search, filtering, and export capabilities
• Reporting interfaces
• Implement responsive UI components using React, TypeScript, and Tailwind CSS
• Create server actions for data fetching and business logic
• Optimize application performance and user experience
• Work with complex financial calculations
• Integrate third-party APIs

Ideal Skills:

• Strong React and Next.js experience with App Router
• Proficiency in TypeScript and modern frontend patterns
• Experience with data visualization libraries (ApexCharts, Chart.js, etc.)
• Understanding of financial concepts (portfolio management, performance metrics)
• UI/UX sensibility with Tailwind CSS and component libraries

1. Testing, Audit Queries & Bug Resolution

Focus Area: Quality assurance, database optimization, and issue resolution

Core Responsibilities:

• Write comprehensive Cypress E2E tests for critical user workflows:
• Authentication and authorization flows
• Portfolio navigation and data viewing
• Data upload and ingestion processes
• Report generation and downloads
• Settings and user management
• Develop audit queries and database reports:
• Data integrity checks across tables
• Financial calculation validation
• Multi-currency conversion accuracy
• Performance metric verification
• Create custom PostgreSQL functions for auditing and reporting
• Write SQL queries to analyze data quality and consistency
• Debug and resolve production issues:
• Investigate QA-reported bugs
• Fix calculation errors in financial logic
• Resolve UI/UX issues and edge cases
• Optimize slow database queries
• Implement error handling and logging improvements
• Perform code reviews and suggest refactoring opportunities

• Next.js 14+ with App Router and Server Components
• React 18+ with TypeScript
• TypeScript (advanced proficiency required)
• Supabase (PostgreSQL, PostgREST API, Auth, Storage)
• Cypress for E2E testing
• AWS Bedrock and OpenAI / Anthropic API (for AI pipeline work)
• ApexCharts or similar data visualization libraries
• PostgreSQL including:
• Complex queries with joins, aggregations, and CTEs
• Custom functions and triggers
• Row-Level Security (RLS) policies

Nice to Have

• Financial/fintech application experience
• Experience with multi-currency applications
• Background in data-intensive applications, * Strong testing background with Cypress or similar E2E frameworks
• Advanced PostgreSQL/SQL expertise
• Experience writing audit queries and data validation logic
• Debugging and troubleshooting skills
• Attention to detail for financial accuracy

Type: Monthly Rolling Contract

Duration: Renewable monthly based on mutual agreement

Termination: Either party can end with 30 days notice

Trial Period: First month serves as mutual evaluation period

Rate: Competitive hourly or monthly rate based on experience