Key Responsibilities

Design, develop, and maintain full-stack web applications using React / Next.js on the frontend and Django or FastAPI on the backend.

Build secure, scalable RESTful and async APIs; integrate with third-party services as needed.

Manage PostgreSQL databases with effective schema design, migrations, and optimized queries.

Work with Snowflake for data warehousing needs build and maintain data models, write performant queries, and integrate warehouse data into application layers.

Translate UI/UX wireframes into responsive, accessible, high-quality frontend components.

Implement authentication, authorization, and session management (JWT, OAuth2).

Set up and manage AWS infrastructure for deployments, CI/CD pipelines, and horizontal scalability.

Leverage AI-assisted development tools (Cursor, Claude Code) to accelerate coding workflows, generate boilerplate, write tests, and improve code reviews.

Write clean, maintainable, and well-documented code with comprehensive test coverage.

Troubleshoot, debug, and optimize performance across the entire stack.

Technical Skills

Frontend

React.js, Next.js, TypeScript, Tailwind CSS

State management (Redux, Context API, Zustand)

Responsive and accessible UI design principles

Component-driven architecture and design systems

Backend

Python (Django / Django REST Framework / FastAPI)

REST and async API design; WebSocket support

Authentication and authorization (JWT, OAuth2, session-based)

ORM and data modeling (Django ORM, SQLAlchemy, Tortoise ORM)

Task queues and background processing (Celery, Redis)

Database & Data Warehousing

PostgreSQL schema design, migrations, indexing, and performance tuning

Snowflake data warehousing, writing optimized SQL queries, managing schemas, stages, and pipes for data ingestion

Experience connecting application backends to Snowflake using Python connectors (snowflake-connector-python, SQLAlchemy with Snowflake dialect)

Experience with Redis or other caching layers

Cloud & D Key Responsibilities