Full Stack Engineer
Summary
Full stack engineer on a long-term W2 contract in San Jose (hybrid, 3 days onsite): optimizing complex SQL against distributed query engines (Trino/Presto, Spark SQL, Athena), building scalable backend services and REST APIs in Java or Python, and developing data-intensive React/TypeScript UIs with dashboards and editable grids.
Full Stack Engineer
Engagement: Long term contract (W2)
Location: San Jose CA (Hybrid - 3-day Onsite)
Job Overview
We are looking for a skilled Full Stack Engineer with strong expertise in SQL, distributed query engines, backend development, and modern frontend technologies. The ideal candidate should have hands-on experience building scalable backend services, developing RESTful APIs, and creating interactive, data-intensive frontend applications.
The candidate will work across the technology stack, contributing to the design, development, and delivery of high-performance applications while collaborating with cross-functional engineering teams.
Key Responsibilities
- Design, develop, and optimize complex SQL queries to support large-scale data processing and analysis.
- Work with distributed query engines such as Trino, Presto, Apache Spark SQL, AWS Athena, or similar technologies.
- Develop scalable backend services and applications using Java or Python.
- Design, build, and maintain RESTful APIs and backend integrations.
- Develop responsive and interactive frontend applications using React.js and TypeScript.
- Build data-intensive user interfaces incorporating interactive dashboards, charts, visualizations, and editable data grids.
- Optimize application performance, scalability, and responsiveness across frontend and backend components.
- Collaborate with product managers, designers, and engineering teams to translate business requirements into technical solutions.
- Participate in code reviews, debugging, testing, and continuous improvement of application architecture and development practices.
Required Technical Skills
1. SQL & Distributed Query Engines
- Strong SQL programming and query optimization skills.
- Hands-on experience with distributed query engines such as:
- Trino / Presto
- Apache Spark SQL
- AWS Athena
- Other comparable distributed query technologies.
2. Backend Development
- Strong programming experience in Java or Python.
- Experience designing and developing RESTful APIs.
- Understanding of backend architecture, application scalability, and performance optimization.
3. Frontend Development
- Strong hands-on experience with React.js and TypeScript.
- Experience developing complex, data-heavy user interfaces.
- Familiarity with charting and data visualization libraries.
- Experience working with editable data grids and interactive tabular interfaces.
Preferred Qualifications
- Experience building end-to-end full-stack applications.
- Understanding of distributed systems and large-scale data processing.
- Familiarity with modern software development practices, including Git, code reviews, testing, and CI/CD.
- Strong analytical, problem-solving, and debugging skills.
- Ability to work independently and collaborate effectively within a fast-paced engineering environment.
Skills
Sign in to read and join the discussion.