Team Lead Full Stack Developer

Key Responsibilities

Reporting & Analytics Development

• Design, develop, and maintain complex reporting solutions serving mission-critical emergency

response operations

• Build interactive dashboards and data visualizations that transform large datasets into

actionable insights

• Develop advanced analytics features including trend analysis, predictive metrics, and

operational intelligence

• Create self-service reporting capabilities enabling stakeholders to access critical data

independently

• Implement real-time and scheduled reporting systems with appropriate caching and

optimization strategies

SQL & Database Architecture

• Write and optimize complex SQL queries involving multiple joins, subqueries, CTEs, window

functions, and aggregations

• Review existing database architectures and identify performance bottlenecks and optimization

opportunities

• Design and implement database schema enhancements to support evolving reporting

requirements

• Develop and maintain stored procedures, functions, and views optimized for reporting

workloads

• Perform comprehensive query performance analysis and implement tuning strategies across

PostgreSQL and AWS Aurora environments

• Create efficient indexing strategies and data access patterns for large-scale datasets

• Establish data modeling best practices for dimensional and transactional reporting needs

Performance Optimization

• Conduct systematic performance analysis of reporting queries processing millions of records

• Implement query optimization techniques including execution plan analysis, index tuning, and

query refactoring

• Design and implement data aggregation strategies, materialized views, and summary tables for

improved performance

• Monitor and optimize database performance metrics including query response times, resource

utilization, and concurrency

• Develop ETL processes and data pipelines optimized for reporting and analytics workloads

• Implement caching strategies and data archival policies to maintain optimal system

performance

Technical Collaboration

• Partner with Product and stakeholder teams to translate business reporting requirements into

technical solutions

• Conduct code reviews focused on SQL quality, performance, and best practices

• Provide technical guidance to development teams on reporting architecture and database

optimization

• Document database schemas, reporting architectures, and optimization strategies

• Collaborate with DevOps on database infrastructure, monitoring, and scaling initiatives

Required Qualifications

Experience & Background

• 8+ years of software engineering experience with significant focus on reporting, analytics, or

business intelligence

• 5+ years of hands-on experience writing complex SQL in production environments

• 3+ years working with large-scale databases (millions+ records) and optimizing query

performance

• Proven track record developing enterprise reporting solutions and analytics platforms

• Experience conducting database architecture reviews and implementing performance

improvements

Technical Expertise - SQL & Databases

• Expert-level SQL proficiency including complex joins, subqueries, CTEs, window functions, and

advanced aggregations

• Deep PostgreSQL expertise with production experience in query optimization and performance

tuning

• Strong understanding of database internals including execution plans, indexing strategies, and

query optimization

• Experience with AWS Aurora or other cloud-based PostgreSQL solutions

• Proficiency in stored procedures, triggers, functions, and database programming

• Advanced knowledge of database design principles, normalization, and dimensional modeling

• Experience with database performance monitoring and profiling tools

• Strong programming skills in PHP (Yii framework or similar MVC frameworks preferred)

• Solid experience with Vue.js or similar modern JavaScript frameworks for building reporting

interfaces

What You'll Work With

• Databases: PostgreSQL, AWS Aurora, multi-tenant architectures

• Backend: PHP (Yii framework), RESTful APIs

• Frontend: Vue.js (Vue 2/3), modern JavaScript, data visualization libraries

• Infrastructure: AWS (RDS, Aurora, S3, Lambda), Postgres

• Tools: Git/GitHub, JIRA, Agile development workflows

Work Location

Hyderabad, India - On-site position with flexible working arrangements to accommodate both India

and onsite teams

Job Summary:

As a MERN Stack Developer, you will be responsible for designing, developing, and maintaining robust full-stack applications using MongoDB, Express.js, React.js, and Node.js. With 5+ years of experience, you’ll work closely with cross-functional teams to deliver secure, performant, and user-friendly solutions.

Key Responsibilities:

• Build end-to-end web applications using the MERN stack
• Write clean, maintainable, and efficient code
• Integrate RESTful APIs and third-party services
• Optimize applications for maximum performance and scalability
• Collaborate with product, QA, and DevOps teams throughout the SDLC
• Participate in code reviews, troubleshooting, and improvement initiatives

Required Skills & Qualifications:

• 5+ years of experience in full-stack development with MongoDB, Express, React, and Node.js
• Strong JavaScript/TypeScript skills (ES6+)
• Solid understanding of RESTful APIs, MVC architecture, and microservices
• Experience with Git and Agile methodologies
• Familiarity with responsive UI/UX best practices

Preferred Skills:

• Exposure to cloud platforms like AWS or Azure
• Experience with CI/CD pipelines and testing frameworks like Jest or Mocha
• Familiarity with containerization tools like Docker/Kubernetes

Big Picture (The Opportunity) : 

Do you take pride in your web development ability? Would you like to use your skills in an energetic atmosphere? Are you dedicated to the craft, write code that they are proud of and can hit the ground running , you’re in the right place.

What do we want from you ? (Our Expectations) : 

• To manage our back-end services and ensure a seamless interchange of data.
• You will be responsible for developing and coding all server-side logic and also to maintain the central database and respond to requests from front-end developers. 

What are you required to do ? (Your Responsibilities) 

• Writing back-end code and building efficient modules.
• Produce detailed specifications
• Developing back-end portals with an optimized database.
• Integrating data storage solutions.
• Responding to integration requests from front-end developers.
• Updating and altering application features to enhance performance.
• Troubleshoot, test and maintain the core product software and databases to ensure strong optimization and functionality
• Contribute in all phases of the development lifecycle
• Develop and deploy new features to facilitate related procedures and tools if necessary
• Work closely with the IT team in completing projects
• Troubleshoot and fix any issues relating to PHP programs
• Create scripts to facilitate client systems to meet performance and objectives
• Test and develop software for client applications
• Create documentation for software created
• Utilize source debuggers and write or modify client software
• Produce results effectively and within the deadlines set 

Roles and Responsibilities 

1) Understand client requirements and functionalities. 

2) Write well-designed, testable, efficient code. 

3) Responsible for solving complex technical issues. 

4) Ensure quality projects are delivered within defined timelines. 

5) Active involvement in client communication to understand functional requirements. 

6) Maintain high standards of quality for code, documentation and other deliverables. 

Required Skills 

1) Good experience in React

2) Hand on Node.JS./Express JS 

3) Database : MYSQL/MongoDB 

4) Experience in Java Script, Typescript. 

5)Good experience in HTML5, CSS3, JavaScript, Jquery 

6) Experience working in an Agile environment. 

7) Good communication skills.

🎉We are HIRING

⁠👩‍💻Full Stack Developer at Adizen.ai (http://adizen.ai/)

About Adizen.ai

⁠Adizen is a company founded in September 2023 by Jashan Suri and Bhanu Chaudhary. Jashan has graduated from IIT Delhi and worked at Sequoia Capital and Bain & Company. Meanwhile, Bhanu is an IIT Kanpur graduate and a 3X founder having founded multiple startups including FoodMonk.

⁠Adizen.ai is spearheading two major ventures: crafting a healthcare software solution primarily for the UK market, and designing a custom ERP system for a Mechanical, Electrical, and Plumbing (MEP) company to boost their operational efficacy and output.

Roles and Responsibilities 

⁠We're open to hiring a fresher, but we expect you to have experience working on projects.

Tech Stack: Our tech stack includes React, Node.js, Mongo DB, and Payload.

Timeline: Full time OR 6 months internship

Kindly fill this form!

https://forms.gle/oG7nB7iepg1WG2bCA

About Snaptrude: Figma for Building Design

Snaptrude helps design teams build more efficient & sustainable buildings in 1/10th of the time. Snaptrude instantly generates real-world data around climate impact, budget, compliance, etc helping teams make better design decisions. All this while enabling collaboration between team members and customers to gather feedback in real-time. Backed by Accel Partners with a team of 16 people. We are used by over 4k users globally.

Website:http://snaptrude.com/" target="_blank">http://snaptrude.com/

Location: Remote

Position: Full Stack Engineer

Responsibilities

• Build modular, reusable components and features
• Own & implement modules in the product with a huge amount of autonomy
• Find and address front-end performance issues
• Collaborate with a small and nimble team of engineers

Required Qualifications

• 1+ years of software development work experience, preferably with exposure to front-end Javascript frameworks like ReactJs
• Very strong fundamentals in Javascript programming
• An added benefit if familiar with ExpressJS and/or Django frameworks
• Strong fundamentals in Algorithms & Data Structures
• You learn quickly, regardless of the languages and technologies used
• You have experience taking ownership and shipping entire features end-to-end
• A strong focus on user experience. You're someone who's passionate about building beautiful, modern UI/UX that people love.

Extremely proactive with the ability to thrive in an unstructured and entrepreneurial environment. We offer extremely flexible working policies and the opportunity to be a part of a rapidly growing startup team. Please get in touch!