Summary
Spear AI is a company serving the national security industry, and they are seeking a versatile Full-Stack Engineer to develop complete, end-to-end web applications. The role involves implementing responsive user interfaces, business logic, database optimization, API integrations, and ensuring cross-platform compatibility.
Responsibilities
- Implementing responsive user interfaces
- Implementing business logic
- Building and optimizing databases
- Creating API integrations
- Ensuring cross-platform compatibility
Skills
- Experience with both front-end and back-end development
- Strong comfort in relational databases
- Tailwind CSS
- TypeScript
- React / Next.js
- Experience with modern build tools (Vite, Webpack)
- Server-side rendering (SSR)
- React Error boundaries and suspense
- Familiar with RESTful APIs (GraphQL is a plus)
- State management (React Context, Zustand, Redux, etc.)
- Node.js
- Python / mypy
- Authentication and authorization (OAuth, JWT, etc.)
- Validation (Zod, Valibot, etc.)
- Logging and monitoring (Sentry, etc.)
- Unit testing and integration testing (Vitest, etc.)
- Relational databases (PostgreSQL, MySQL, etc.)
- Data modeling
- Schema migrations
- Advanced SQL concepts (window functions, CTEs, materialized views, stored procedures, and triggers)
- Performance optimization (indexing, EXPLAIN ANALYZE, etc.)
- ETL and data pipelines
- CI/CD (GitHub Actions, GitLab Pipelines, etc.)
- Docker
- Docker Compose (Kubernetes is a plus)
- Infrastructure as Code (Pulumi, Terraform, etc.)
- Semantic Versioning
- Deployment strategies
- Feature flags
- Linting / formatting (ESLint, Prettier, etc.)
- AWS or other cloud providers
- Willingness to receive a Secret or Top Secret/SCI security clearance
- Experience with Kafka, RedPanda, or other streaming platforms
Qualifications
Must Haves
- Experience with both front-end and back-end development
- Strong comfort in relational databases
- Tailwind CSS
- TypeScript
- React / Next.js
- Experience with modern build tools (Vite, Webpack)
- Server-side rendering (SSR)
- React Error boundaries and suspense
- Familiar with RESTful APIs (GraphQL is a plus)
- State management (React Context, Zustand, Redux, etc.)
- Node.js
- Python / mypy
- Authentication and authorization (OAuth, JWT, etc.)
- Validation (Zod, Valibot, etc.)
- Logging and monitoring (Sentry, etc.)
- Unit testing and integration testing (Vitest, etc.)
- Relational databases (PostgreSQL, MySQL, etc.)
- Data modeling
- Schema migrations
- Advanced SQL concepts (window functions, CTEs, materialized views, stored procedures, and triggers)
- Performance optimization (indexing, EXPLAIN ANALYZE, etc.)
- ETL and data pipelines
- CI/CD (GitHub Actions, GitLab Pipelines, etc.)
- Docker
- Docker Compose (Kubernetes is a plus)
- Infrastructure as Code (Pulumi, Terraform, etc.)
- Semantic Versioning
- Deployment strategies
- Feature flags
- Linting / formatting (ESLint, Prettier, etc.)
- AWS or other cloud providers
- Willingness to receive a Secret or Top Secret/SCI security clearance
Nice to Haves
- Experience with Kafka, RedPanda, or other streaming platforms