
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

Full Stack Developer responsible for managing back-end services and the interchange of data between the server and the users.
Your primary focus will be the development of all server side logic, definition and maintenance of the central database, and ensuring high performance and responsiveness to requests from the front-end. You will also be responsible for integrating the frontend elements built by your co-workers into the application. Therefore, a basic understanding of frontend technologies is necessary as well.
We are looking to recruit a candidate for a role that will require:
- Create and consume restful APIs
- Design, develop, and maintain internal and external applications
- Build efficient, testable, and reusable modules
- Write high quality, structured application/interface code and documentation
- Identify solutions through research and collaboration that resolves the root of problems as they arise
- Define functional and technical requirements for application software to develop skills and knowledge
- Troubleshoot, test and maintain the core product software and databases to ensure strong optimization and functionality
- Contribute in all phases of the development lifecycle
Requirement
∙ Proficient in Node.JS and ReactJS development stack
∙ 2+ years’ experience designing, querying, and updating databases in MySQL/nosql
∙ Basic understanding of web technologies including HTML, CSS, JavaScript, AJAX etc.
∙ Passion for best design and coding practices and a desire to develop new bold ideas
∙ Good to have knowledge of AWS, Redis, ElasticSearch
Requirements
- 3+ years of overall application development experience
- 5 years of Java 8, J2EE, Spring Boot, Spring MVC, JPA
- 2 years of Angular 8+, TypeScript, JavaScript, HTML, CSS
- Expert knowledge of SQL and PL SQL programming with MySQL database
- Strong knowledge of Maven, Junit, Mockito, GitLab, GitHub, and Jira
- Nice to have Docker implementation experience
- Experienced with TDD test driven development and automated unit testing including UI unit testing frameworks
- Expert knowledge of JSON RESTful web service development
- Experience with code reviews development of coding standards practices improving the quality in the software code
- Ability to work independently, take initiative to ensure efficient and timely resolution of production issues
- Excellent problem-solving design development and debugging skills
- Ability to solve problems using an analytical approach decisive fast moving quick and constructive resolutions of conflicts and a can-do attitude
- Expert knowledge in Agile Scrum practices Software Development and Application Life Cycle Management
Full Stack Developer Job Description
Position: Full Stack Developer
Department: Technology/Engineering
Location: Pune
Type: Full Time
Job Overview:
As a Full Stack Developer at Invvy Consultancy & IT Solutions, you will be responsible for both front-end and back-end development, playing a crucial role in designing and implementing user-centric web applications. You will collaborate with cross-functional teams including designers, product managers, and other developers to create seamless, intuitive, and high-performance digital solutions.
Responsibilities:
Front-End Development:
Develop visually appealing and user-friendly front-end interfaces using modern web technologies such as C# Coding, HTML5, CSS3, and JavaScript frameworks (e.g., React, Angular, Vue.js).
Collaborate with UX/UI designers to ensure the best user experience and responsive design across various devices and platforms.
Implement interactive features, animations, and dynamic content to enhance user engagement.
Optimize application performance for speed and scalability.
Back-End Development:
Design, develop, and maintain the back-end architecture using server-side technologies (e.g., Node.js, Python, Ruby on Rails, Java, .NET).
Create and manage databases, including data modeling, querying, and optimization.
Implement APIs and web services to facilitate seamless communication between front-end and back-end systems.
Ensure security and data protection by implementing proper authentication, authorization, and encryption measures.
Collaborate with DevOps teams to deploy and manage applications in cloud environments (e.g., AWS, Azure, Google Cloud).
Qualifications:
Bachelor's degree in Computer Science, Engineering, or a related field (or equivalent experience).
Proven experience as a Full Stack Developer or similar role.
Proficiency in front-end development technologies like HTML5, CSS3, JavaScript, and popular frameworks (React, Angular, Vue.js, etc.).
Strong experience with back-end programming languages and frameworks (Node.js, Python, Ruby on Rails, Java, .NET, etc.).
Familiarity with database systems (SQL and NoSQL) and their integration with web applications.
Knowledge of web security best practices and application performance optimization.
About Company:
Propelius Technologies is a next generation software development studio focused on developing cutting edge Web and Mobile Applications on JavaScript based technologies like ReactJS, React Native and Node.js. We have domain expertise in SAAS, FinTech, LegalTech and InsuranceTech.
About the Role:
As a Senior Developer, you will be responsible for developing and maintaining high-quality web applications using ReactJS and NodeJS. You will work closely with the development team to design and implement new features, as well as maintain and improve existing ones. You will also be responsible for ensuring the application is performant and scalable.
Roles & Responsibilities:
- Developing and designing front end web architecture
- Building interactive consumer data from multiple systems
- Define code architecture decisions to support high-performance products
- Translate wireframes and PSD Designs into functional web applications
- Work with development teams and managers to ideate software solutions
- Developing well-functioning databases and applications
- Conduct and participate in project planning & scheduling and design discussions
- Test software to ensure efficiency
- Address and improve any technical issues
Skills Required :
- In-depth knowledge of NodeJS, ExpressJS or Restify
- Ability to bind UI elements to JavaScript object models
- Experience creating RESTful services with Node.js
- Proficiency in OOP and database concepts
- Proven experience in front & back-end development
- Ability to create front end applications using HTML5, Angular, LESS/SASS
- Knowledge of modern frameworks and design patterns
- Ability to create Unit and Integration tests to ensure the quality of code
- Strong problem-solving skills
- Good communication skills
- Strong analytical thinking
- Self-motivated
- Strong will and discipline
Perks you receive:
- Competitive Salary - Oh Yes!! This is a must.
- 5 days working - As you want it :)
- Opportunity to work with top professionals
- Platform to learn new technologies and grow yourself - We believe in learning & evolving
- Open Culture - No politics, Views are appreciated always!!
- Monthly Celebrations
About the Position
We are looking for a passionate and experienced software engineer to join our team at Mumbai. In this role, your primary responsibilities will be to take ownership of developing user facing applications and features in an agile manner. You will design and implement scalable and performant front-end solutions from scratch, while also taking a hard look at the existing ones.
What you will do at QI?
- Design, develop and deliver new user-facing apps and feature and improve existing ones
- Take ownership of product(s), and contribute to dev cycles and sprints planning
- Ensure technical feasibility of UI/UX design, share inputs with other teams including product, design and QA
- Optimize applications for performance, user experience and SEO
- Build reusable code and libraries. Contribute to open source projects.
- Stay up-to-date with new technologies with an eye of constantly adapting and improving our systems and methods.
Basic Job requirements
- 2 years + work experience in a similar role
- Strong experience in HTML5, CSS, DOM and front-end tooling ecosystem (Gulp,Grunt, Webpack)
- Excellent concepts and command over JavaScript
- Strong concepts and commercial experience in Vue.js
- Solid foundation in software development ( algorithm design, data structure, SDLC)
- Good concepts of unit testing and automation testing for UI components
- Good understanding of web app performance including Google Core Web Vitals metrics.
Location - Remote
Good to have
- Basic knowledge of REST API and relational databases
- Basic understanding of browser internals
- Familiarity with web components and shadow DOM
- Exposure to progressive web app design.
About QuantInsti®
QuantInsti® was started in 2010, by the founders from iRage – a leading quant and algo trading firm in India. From its early days focused on bridging the industry knowledge gap in the field of high-frequency trading, we have come a long way in the last decade. Today, we have a user base from 180+ countries with a growth rate much over 50% year-on-year.
At QuantInsti®, we swear by our goal of revolutionizing the way people approach the financial markets by empowering individuals and institutions with bleeding edge education and technologies. We offer high quality https://www.quantinsti.com/epat">learning experience and best-in-class https://quantra.quantinsti.com/">courses geared towards a global audience in quantitative trading and investing. Our in-house developed technology aims to bring institutional grade tools and https://quantra-blueshift.quantinsti.com/">platforms to democratize systematic and quantitative trading.
We achieve this by putting technology at the core of our business. We have a complex ecosystem of microservices and applications deployed over a fully cloud-based infrastructure. Our tech stack includes Node.js, Vue.js, Python and Docker. The team is driven by user experience, with strong focus on delivering scalable software solutions to complex and evolving business goals.
Why you should join us?
At QuantInsti, we work at the cutting edge of FinTech and EdTech offerings. We work with the newest technologies with a goal of delivering best experience to our users in a scalable manner, with high-performance and availability. If you love to be challenged intellectually, rest assured we have plenty of them for you. We follow an open and free work culture, where you are encouraged to ask questions, learn and teach. We offer a fast-paced environment where you take ownership of what you design and deliver. If you are looking for a move where you will find a reason to wake up every morning and rush to work, come join us.
- Proficiency with fundamental front end languages such as HTML, CSS and JavaScript.
- Familiarity with JavaScript frameworks such as Angular JS, React.
- Proficiency with server side languages such as Python, Java, PHP and .Net.
- Familiarity with database technology such as MySQL, Oracle and MongoDB.
- Excellent verbal communication skills.
Full Stack Developer
Skills:
-
Proficiency with JavaScript and HTML5
-
Minimum 2+ years of hands-on experience with AngularJS and Angular Frameworks
-
Experience with Java, JSON, Spring Boot and Hibernate
-
Experience with MYSQL databases
-
Familiarity with Linux environments
-
Experience with GIT
-
Hands on experience with AWS S3 is preferred
-
Experience with web servers & application servers such as Apache and Nginx is good to have
Responsibilities:
-
Design and develop client-side and server-side architecture
-
Develop and manage well-functioning database
-
Implementation of approved user interface
-
Design and construction of REST APIs
-
Server management and deployment for the relevant environment






