PostgreSQL Lead

About One Impression

One Impression is one of the world’s largest influencer marketing platforms, working with 300+ global brands like Unilever, Nestle, and Amazon to connect with a diverse creator network. Our platform empowers brands and creators to collaborate seamlessly and scale their reach. To capture a significant share of global media ad spend, One Impression is quickly becoming the industry’s go-to influencer marketing platform.

Job Overview

We are looking for a seasoned Senior Frontend Engineer (SDE III) with over five years of experience to lead, mentor, and grow a high-performing engineering team. The ideal candidate will have extensive hands-on experience in software development, deep technical expertise, and a proven track record of successfully leading large-scale engineering teams and projects. This role requires strategic leadership, the ability to manage complex technical challenges, and the ability to drive innovation while ensuring operational excellence.

As a Frontend Lead, you will collaborate with key stakeholders across the business, product management, and operations to ensure alignment with the organization’s goals and play a critical role in shaping the technology roadmap and engineering culture.

Key Responsibilities:

• Leadership and Team Development: Lead and inspire a team of engineers, fostering a culture of innovation, accountability, and continuous improvement. Manage the hiring, training, and career development of engineering staff.
• Strategic Planning: Work closely with senior leadership to develop and implement engineering strategies that support business objectives. Define technology roadmaps and ensure alignment with organizational goals.
• Technical Excellence: Guide the team in designing and implementing scalable, robust software systems. Drive the adoption of best practices in architecture, coding standards, and software testing to ensure high-quality product delivery.
• Project and Program Management: Oversee the successful delivery of engineering projects, ensuring deadlines, quality standards, and budget constraints are met. Use agile methodologies to manage the development process and resolve bottlenecks.
• Cross-functional collaboration: Collaborate with Product Management, Design, Business, and Operations teams to define project requirements and deliverables. Ensure the smooth integration of engineering efforts across the organization.
• Risk Management: Anticipate and mitigate technical risks and roadblocks. Proactively identify areas of technical debt and drive initiatives to reduce it.
• Stakeholder Communication: Act as the technical point of contact for stakeholders, providing regular updates on project progress, resource allocation, and performance metrics. Communicate complex technical concepts to non-technical stakeholders.

Required Qualifications:

• Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related field
• 5+ years of experience in software engineering.
• Proven track record of successfully delivering large-scale, high-impact software projects.
• Strong understanding of software architecture, design patterns, and scalable system design.
• Expertise in multiple programming languages and modern development frameworks. For this we require expertise in JS/React, and React Native.
• Experience working with REST APIsMust have a knack for developing good looking frontend apps.
• Experience with cloud infrastructure (AWS), microservices, and distributed systems.
• Experience in delivering full-stack B2B/SaaS applications including mobile applications, web frontend, and a scalable backend.
• Excellent problem-solving skills, with the ability to diagnose and resolve complex technical challenges.
• Strong communication and interpersonal skills, with the ability to influence and inspire teams and stakeholders at all levels.

Why Join One Impression?

- Be a part of one of the largest influencer marketing platforms globally, working with top brands and influencers.

- Opportunity to lead and shape a fast-growing marketplace product.

- Competitive salary and benefits package.

- A collaborative and innovative work culture in a rapidly scaling company.

Our Mission

To make video as accessible to machines as text and voice are today.

At lookup, we believe the world's most valuable asset is trapped. Video is everywhere, but it's unsearchable—a black box of insight that no one can open or atleast open affordably. We’re changing that. We're building the search engine for the visual world, so anyone can find or do anything with video just by asking.

Text is queryable. Voice is transcribed. Video, the largest and richest data source of all, is still a black box. A computer can't understand it, and so its value remains trapped.

Our mission at lookup is to fix this.

About the Role

We are looking for founding Backend Engineers to build a highly performant, reliable, and scalable API platform that makes enterprise video knowledge readily available for video search, summarization, and natural‑language Q&A. You will partner closely with our ML team working on vision‑language models to productionize research and deliver fast, trustworthy APIs for customers.

Examples of technical challenges you will work on include: distributed video storage, a unified application framework and data model for indexing large video libraries, low‑latency clip retrieval, vector search at scale, and end‑to‑end build, test, deploy, and observability in cloud environments.

What You’ll Do:

• Design and build robust backend services and APIs (REST, gRPC) for vector search, video summarization, and video Q&A.
• Own API performance and reliability, including low‑latency retrieval, pagination, rate limiting, and backwards‑compatible versioning.
• Design schemas and tune queries in Postgres, and integrate with unstructured storage.
• Implement observability across metrics, logs, and traces. Set error budgets and SLOs.
• Write clear design docs and ship high‑quality, well‑tested code.
• Collaborate with ML engineers to integrate and productionize VLMs and retrieval pipelines.
• Take ownership of architecture from inception to production launch.

Who You Are:

• 3+ years of professional experience in backend development.
• Proven experience building and scaling polished WebSocket, gRPC, and REST APIs.
• Exposure to distributed systems and container orchestration (Docker and Kubernetes).
• Hands‑on experience with AWS.
• Strong knowledge of SQL (Postgres) and NoSQL (e.g., Cassandra), including schema design, query optimization, and scaling.
• Familiarity with our stack is a plus, but not mandatory: Python (FastAPI), Celery, Kafka, Postgres, Redis, Weaviate, React.
• Ability to diagnose complex issues, identify root causes, and implement effective fixes.
• Comfortable working in a fast‑paced startup environment.

Nice to have:

• Hands-on work with LLM agents, vector embeddings, or RAG applications.
• Building video streaming pipelines and storage systems at scale (FFmpeg, RTSP, WebRTC).
• Proficiency with modern frontend frameworks (React, TypeScript, Tailwind CSS) and responsive UI design.

Location & Culture

• Full-time, in-office role in Bangalore (we’re building fast and hands-on).
• Must be comfortable with a high-paced environment and collaboration across PST time zones for our US customers and investors.
• Expect startup speed — daily founder syncs, rapid design-to-prototype cycles, and a culture of deep ownership.

Why You’ll Love This Role

• Work on the frontier of video understanding and real-world AI — products that can redefine trust and automation.
• Build core APIs that make video queryable and power real customer use.
• Own systems end to end: performance, reliability, and developer experience.
• Work closely with founders and collaborate in person in Bangalore.
• Competitive salary with meaningful early equity.

Document Customer Interactions: Accurately record customer interactions, issues, and resolutions in our CRM system.

Escalate Complex Issues: Escalate complex or unresolved issues to the appropriate team or supervisor.

Provide Product/Service Information: Educate customers on our products and services, and guide them through using our platform.

Process Orders and Returns: Assist customers with placing orders, processing returns, and managing their accounts.

Gather Customer Feedback: Collect and analyze customer feedback to identify areas for improvement.

Maintain Product Knowledge: Stay up-to-date on product updates, company policies, and industry trends.

Meet Performance Metrics: Achieve and maintain established performance metrics, such as response time, resolution rate, and customer satisfaction scores.

Contribute to Team Goals: Collaborate with team members to achieve departmental goals and improve overall customer support processes.

Create Knowledge Base Articles/FAQ's: Depending on the role, you may be asked to create content to aid in customer self service.

The Product Management Analyst will play a crucial role in supporting the product management team by analyzing market trends, customer needs, and product performance. This individual will help in the creation, development, and management of products throughout their lifecycle. The ideal candidate will have strong analytical skills, a deep understanding of product management processes, and the ability to translate data into actionable insights.

Key Responsibilities:

• Market Research and Analysis:
• Conduct thorough market research to identify trends, opportunities, and competitive landscape.
• Analyze customer feedback and behavior to understand their needs and preferences.
• Monitor industry developments and report on their potential impact on our products.
• Data Analysis:
• Collect, analyze, and interpret data from various sources to inform product decisions.
• Develop and maintain dashboards and reports to track product performance and key metrics.
• Provide actionable insights and recommendations based on data analysis.

- We are looking for techies with a passion to develop high-performance web applications. 

- If you are interested and looking to build scalable and high-performance apps, then join us. We are building web app based on React with server-side rendering. For mobile, we are building PWA.

Roles & Responsibilities :

1. Build scalable web applications using ReactJS, Redux and other related libraries.

2. Integrating back-end API's with front-end.

3. Build reusable code and libraries for future use.

4. Optimize application performance and reduce page loading speed.

5. Solid experience in architecting and implementing highly scalable front-ends in modern technologies such as React or Vue.

6. Gathering requirements from design and technical staff and client on web development needs/Defining effective solutions for business and process problems.

• Own our user interfaces with an eye to lightning-fast performance and a great user experience
• Implement compelling and intuitive UIs, shaping the design and feel of the product alongside our founders
• Write a significant amount of code for new and existing features
• Ship high-quality code and architecture
• Mentor engineers on the team, developing their skills and helping advance their careers
• Help shape the future of our engineering organization

Requirements

• You have been building production web applications for 5+ years and know the systems from top to bottom
• You know SQL and have significant programming experience on the frontend with React
• You have a BS/MS/Ph.D. in a scientific field or equivalent experience
• You want to work in a fast-paced, high-growth startup environment that respects its engineers and customers
• Comfortable working with a 100% distributed engineering team, collaborating on GitHub, Slack, Zoom, etc. in the open and as a self-starter.

Bonus points

• You have backend experience building microservices
• You’ve contributed to open-source libraries and actively participate in the development community (blogging, meetups, tweeting, etc.)
• You have experience building interactive data visualizations
• You have worked in TypeScript, Java, Go

• You will be proficient in Agile methodologies of Software Development especially SCRUM.
• You will be able to successfully maintain discipline as informed by your seniors.
• You will regularly attend stand-ups and project discussions.
• You will be proficient in full stack dot net development especially web technologies.
• You will have an intermediate level skill set in web development using .net technology.
• You will have a fair understanding of the testing cycle to improve the quality of the software being developed.
• You will assist in writing software requirements documentation.
• You will assist your seniors in doing business analysis on live projects.
• You will assist in doing software testing as and when required.
• You will attend regular training sessions conducted by your seniors.
• You will strive towards writing better code which is more efficient and is also maintainable. 
• You will be proficient in team communication via the official channels such as email, project tracking tools, slack etc.