
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

Similar jobs
1) You will be building and maintaining an internal application used by our fundraising,
marketing and accounting teams. This is very different from building an application for
millions or even thousands of users.
2) The cycles are short - there are no wire frames,no UML diagrams, no TDD / BDD, and no hand-wringing over 41 shades of blue. Bugs will be fixed as soon as they are reported and user feedback will be incorporated quickly.
3) You may build a feature which gets used for two weeks and is then thrown
away. The application as a whole will be used indefinitely i.e. this is not until we get
something else.
4) Safeguard client data.
5) Listen to your colleagues and understand their requirements.
6) Develop new features for our web application and Test the features you develop.
7) Fix bugs found regardless of who introduced them.
8) Follow and improve the deployment process
9) Log, and read the logs.
10) You will occasionally be expected to describe your code in words
Position Details:
Role: JavaScript Developer
Reports to: Director - Technology
Location: Bengaluru, India
Type of contract: 12 months full-time consultancy contract
Salary: As per Industry standards

At least 7 years programming experience, some of them in JS/TypeScript.
Proven expert level knowledge in BE & FE development (NodeJS, React,
electron, npm/yarn, WebPack).
Experience with cloud (preferably AWS) and/or micro-services.
Proven experience mentoring junior developers, defining work procedures and coding conventions.
Experience working with various databases (preferably more than two).
Job description
Java Full Stack Developer
Contractual Role 12 months
Experience : 4 - 7
Work From Home
Primary Skills:
- Javascript
- HTML and CSS
- Springboot and Microservice
- Hibernate and React
- MySQL(SQL) and MongoDB (NoSQL)
- Angular 12,
- Proficient in Java
Create decoupled, interactive web UIs using JavaScript (Angular, jQuery)
Aid in the development and ongoing maintenance of our DevOps platform (Ansible)
Provide technical advice and recommendations for language and software choices.
Develop code that is cross-browser and cross-platform friendly
Collaborate with project stakeholders to ensure all requirements are met
Evaluate technologies and manage technical planning
Support and ongoing development for existing projects
Provide clean code and proper documentation for each project
Fix bugs and resolve ongoing issues
Strong writing and speaking skills (English)
Technical Requirements:
3 to 7 years of experience developing and deploying web sites and applications
Experienced with Flask / Pyramid / Falcon
Experience with Agile / SCRUM practices
Experience setting up and managing servers.
Experience hand-coding HTML and CSS
Experience with JavaScript development
Some experience with DevOps practices and platforms ( AWS )
e-commerce integration and custom development
Custom web-based application development experience (startup experience is a bonus)
Comfortable collaborating with designers, front-end developers, and other team members
Object-oriented design and development strategies
Web services / ReST API design is Key
Understanding of Microservices is a bonus
- Develop a deep understanding of the start-up ecosystem.
- Build customer facing technology product for global customers.
- Own the Product's frontend and backend development, building reusable, testable, and scalable code.
- Research, evaluate, analyse and implement technical requirements.
- Collaborate with product management teams to define and implement innovative solutions for the product direction, visuals and experience.
- Mentor Junior members of the team.
Requirements :
- 3 to 5 yrs of experience building scalable products, distributed applications product/services in JavaScript and one of angular/react.
- Min 2+ experience working on Node.js and its frameworks.
- Knowledge of both SQL and NoSQL database services and related tools with the expertise to create efficient schemas.
- Strong coding and problem solving skills.
- Understanding of multiple delivery platforms, such as mobile vs. web and developing responsive UI.
- Ability to own end-to-end deliveries, right from requirements till release.
- Excellent coding skills and ability to produce high quality, bug free and testable production grade code.
- Designing unit test cases, integrated test cases using Selenium and Protractor.
- Experience working in an Agile/Scrum development process.
-Ability to mentor junior members of the team.
- Ability to review code and continuously push for higher standards of development.
What makes you a great candidate
- Experience with connecting or consuming API's (REST, SOAP, GRAPHQL)
- IPAAS/ETL experience is a huge plus.
- An understanding of basic scripting. PHP is a plus
- Data modelling/data architecture/data warehousing experience
- Familiarity with CRM platforms
- Self-motivated, proactive team player Strong communication and interpersonal skills
- Bachelor’s Degree or higher in a related technical field
Your responsibilities
- Engage with Customer and Partner technical staff and developers to identify requirements
- Design their technical architecture and data model
- Assist & implement integrations, on-boarding, and deployment
- Verify the integrated solution with configuration audits and provide long-term support
- Onboard new customers for faster time-to-value
- Gather customer requirements, systems, data model, and custom metrics
- Recommend best-practice approaches
- Assist in other testing / QA activities in support of getting customers live
- Respond to Customer Support Service Requests and Escalations
- Maintain high customer satisfaction
- Partner with cross-functional teams
- Work with Product Management, Support, and Engineering to translate Customer business needs and product feedback into new solutions
- Assist the Sales teams in setting up prospective customers for success in on-boarding
- Act as a thought leader and Blendr advocate in webinars, blog postings, and speaking events
- Exhibit diplomacy, tact, and poise when working through customer issues and escalations
Designation - SDE II / III (3D team)
About Livspace
Livspace is India’s trusted interior design and renovation platform that connects interior designers, homeowners and vendors. For homeowners, Livspace is their one-stop destination for all things interiors. For interior designers and vendors, we’ve streamlined their workflow from design all the way to delivery through powerful and innovative technology.
We’re currently in nine Indian metro areas. We’ve made over 20,000 customers happy by delivering their dream homes to them. With over 3,500 interior designers on board, we’re the largest design community India has seen. We employ over 2000 passionate individuals who continue to grow and be a part of this exciting journey.
If you value autonomy, enjoy challenges, believe in getting things done and can work with minimal supervision, come join us.
Skills required (Must haves):
- Should have worked on Javascript for minimum 2 years. Frontend(Preferred) / Backend
- Should have knowledge of Web development
- Should have good logical thinking and able to code using best practices
- Should have knowledge of Angular JS or any MVC framework
Good to Have (Plus Points):
- Some knowledge of Python/java
- Some knowledge on Database (MySQL)
- Some knowledge of Three.js & 3D rendering tools in web-like blender, 3dsmax etc.
- Some knowledge of Geometry/mathematics knowledge
- Some functional knowledge of CSS Styling, though we are not looking for UI developer
What you will be working on:
- Active development of web based 3D Design tool which is used be interior designers to create awesome designs
- Creation of builder tool which helps in creating dynamic products (variable dimensions and finished) run time
- Development of rule engine which take care of ever growing product & design rules






