
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
Job Title : Generalist Fullstack Engineer (Java / Node.js / React / AI-Driven Engineering)
Experience : 5 to 12 Years
Location : Bengaluru (Koramangala) – Hybrid (3 Days WFO)
Employment Model : C2H
Joining : Immediate to 20 Days Notice Only
Open Positions : 4
About the Role :
We are hiring a hands-on Generalist Fullstack Engineer for a high-impact engineering team. This is a 90% coding role focused on building scalable products across frontend, backend, cloud, and modern AI-enabled engineering practices.
Mandatory Skills :
Full Stack Development (Frontend + Backend), JavaScript / Java / Node.js / Python / Go, ReactJS or modern UI frameworks, Microservices, AWS, Docker, Kubernetes, SQL/NoSQL, CI/CD, Terraform (IaC), Automated Testing (TDD), AI-enabled software delivery, and strong hands-on coding experience.
Key Requirements :
- 5 to 12 years of software development experience.
- Strong expertise in JavaScript, Java, Node.js, Python, or Go.
- Hands-on experience with ReactJS / modern frontend frameworks.
- Strong backend depth with microservices & event-driven architecture.
- Experience with AWS, Docker, Kubernetes.
- Exposure to AI tools/frameworks in software delivery.
- Strong understanding of SQL/NoSQL databases & data modelling.
- Experience with CI/CD, automated testing, Terraform (IaC).
- Working knowledge of TDD, pair programming, continuous integration, security best practices.
Roles & Responsibilities :
- Develop and own production-grade full-stack applications.
- Build AI-first engineering workflows to improve delivery efficiency.
- Drive architecture decisions and engineering best practices.
- Deliver scalable cloud-native solutions.
- Collaborate across product, QA, design, and architecture teams.
- Improve system reliability through monitoring, automation, and testing.
Ideal Candidate :
✔ Strong end-to-end ownership (Frontend + Backend).
✔ Deep hands-on coding mindset (not people-management focused).
✔ Strong AWS + SQL exposure.
✔ Experience building and managing UI state and frontend components.
✔ Stable career progression (avoid frequent job changes).
Interview Process :
- Technical Round – GT (Assemble)
- Technical Round – Client
- Technical Round – Client
- HR Discussion & Offer
Job description:
About Us
AtDrive Infotech is a forward-thinking IT company delivering innovative, scalable, and intelligent web solutions using modern technologies. We focus on building high-performance applications and integrating AI-driven capabilities to enhance user experience and business efficiency.
We are looking for an experienced Angular/Node.js Team Lead who can drive technical excellence, lead development teams, and ensure successful delivery of scalable applications.
Key Responsibilities
- Lead the design, development, and deployment of scalable web applications using Angular and Node.js.
- Provide technical leadership and mentor developers to maintain coding standards and best practices.
- Manage the end-to-end development lifecycle, including requirement analysis, development, testing, deployment, and maintenance.
- Assign tasks, track progress, and ensure timely delivery of project milestones.
- Design and maintain RESTful APIs and backend services.
- Review code, identify technical risks, and optimize system performance.
- Collaborate with clients and stakeholders to translate business requirements into technical solutions.
- Participate in Agile/Scrum ceremonies such as sprint planning, reviews, and stand-ups.
- Drive the implementation of AI-powered features and integrations where applicable.
- Ensure quality through testing, debugging, and performance optimization.
Qualifications
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
- 5+ years of total experience in web development.
- Minimum 1 year of experience leading or coordinating development teams.
Required Technical Skills
- Strong expertise in Angular for enterprise-level frontend development.
- Proficiency in Node.js for scalable backend development.
- Advanced knowledge of MySQL database design and optimization.
- Strong experience in REST API development and third-party integrations.
- Hands-on experience with:
- JavaScript
- HTML5
- CSS3
- Bootstrap
- jQuery
- Experience working with MVC architecture.
- Familiarity with AJAX and JSON/XML.
- Strong knowledge of Git/version control systems.
AI Skills (Required)
- Understanding of AI concepts and their application in web development.
- Experience integrating AI-powered APIs (e.g., chatbots, automation tools).
- Basic understanding of AI workflows and automation tools is preferred.
Leadership & Collaboration Skills
- Experience leading small teams (2–5 developers).
- Ability to mentor team members and support technical growth.
- Strong task management and delivery tracking skills.
- Experience working in Agile/Scrum environments.
- Ability to manage multiple priorities and deadlines effectively.
Client Communication Skills
- Strong written and verbal communication skills in English.
- Ability to gather requirements and communicate project updates to clients.
- Ability to explain technical concepts clearly to non-technical stakeholders.
Personal Attributes
- Strong leadership and problem-solving skills.
- Self-motivated and proactive mindset.
- Ability to work in a fast-paced environment.
- Strong sense of ownership and accountability.
- Ability to multitask while maintaining quality standards.
Evaluation Criteria
Candidates will be evaluated based on:
- Angular Development & Architecture Skills
- Node.js Backend Development Expertise
- MySQL Database Skills
- API Development Capability
- AI Integration Knowledge
- Team Leadership Experience
- Communication & Problem-Solving Ability
Why Join Us?
Join AtDrive Infotech and work on innovative projects that leverage modern web technologies and AI integration. We provide opportunities to lead teams, solve complex challenges, and contribute to impactful digital solutions.
Schedule
- Day shift
- Monday to Friday (Mon-Sat during Probation)
Job Types: Full-time, Permanent
Benefits:
- Health insurance
- Paid sick time
- Paid time off
- Work from home
Work Location: Remote
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.
The ideal candidate would be part of the initial Tech team to lead the technology development and transform the firm's vision into deliverables through technology applications. The candidate has upto 5 years of experience in application development and has a strong foothold in both backend and front-end development.
Roles and Responsibilities:
1. Writing python codes for various market data which includes maths and statistical models, fundamental analysis, and sentiment studies. Proficient in Python with a good understanding of various libraries such as Pandas, Numpy, SciPy.
2. Build and develop the efficient architecture of the product to improve the performance and computing speed, with a good understanding of the Django framework.
3. Deploy and maintain the product on a cloud server, handling asynchronous tasks. Good understanding of AWS, Azure, or other cloud infrastructure.
4. Manage data and database, a good understanding of PostgreSQL, MongoDB, or other databases.
5. Fluent in integrating systems using API's.
6. Understanding of front-end applications like Angular, React, Vuejs, and other java applications.
7. Lead, train, and guide the team of junior developers.
8. Understanding and application of Machine learning is a plus.
Benefits of working with us:
- More responsibilities and more opportunities
- The chance to exponentially grow in your career, as Inuvest grows
- Enhance your skill-sets and knowledge
- Opportunity to learn about how the capital market functions and its complexities.
- Feel empowered and change things - We value ideas and suggestions
- Work in an inclusive culture where transparency, creativity, accountability, and ownership are encouraged
- Work with futuristic technologies - AI/ML
Additional Perks:
1. Stock Options
2. Flexible work hours and work from home
As a full stack engineer, you will build new features for our internal tools, including https://medium.com/@Smartcow_ai/tlt-lightning-ff47659f7804">lightning. Architect, develop, test, and deliver independently.
Responsibilities
- Design, test, build and deploy web applications for internal and external use
- Design and implement scalable APIs and backend services
- Convert high-level requirements into detailed, usable and intuitive UI
- Involved in the execution of project from design stage
Skills:
- 3+ years full-stack python developer with exposure to web frameworks like Django or Flask
- Experience building APIs for rapidly iterating product and restful APIs and development of service layer using python's flask framework
- Proficient in writing unit test cases using Pytest package
- Proficient on Reactjs, Angular, & VueJs (GTH),
- Knowledge of DB and API schema designing
- Knowledge with OpenCV and ML workflow is added advantage
- HTML/CSS/JavaScript and JavaScript framework
- Database level programming using both SQL (MySQL, PostgreSQL) and No SQL (MongoDB/Casandra) and designing the database level stored procedures and persistence logic.
- Knowledge with Nvidia libraries is an added advantage
- Experience working with Web Application development, docker, Unix/Linux environments
- Understanding of machine learning, information retrieval, neural networks, networking, developing large software systems (stands out from crowd)
Responsibilities:
- Development and Integration of user-facing design elements with server-side logic.
- Design and develop backend API services and databases to serve frontend applications.
- Code for multi-platform environments.
- Build reusable code and libraries for future use.
- Ensure responsiveness of applications.
- Optimization of the application for maximum speed and scalability.
Skills and Qualifications:
- Basic understanding of front-end technologies and platforms, such as JavaScript, HTML5, and CSS3.
- Proficient in Angular JS or ReactJS, Node.js and JavaScript.
- Integration of multiple data sources and databases into one system.
- Management of hosting environment, including database administration and scaling an application to support load changes.
- Understanding differences between multiple delivery platforms such as mobile vs desktop, and optimizing output to match the specific platform.
- Creating database schemas that represent and support business processes in one or more database technologies such as Mongo, MySQL etc.
- Implementing automated testing platforms and unit tests.
- Proficient knowledge of a back-end programming language. (Depending on the specific case, a developer should have the knowledge of one or more of Python, Ruby, JavaScript etc.)
- Proficient understanding of code versioning tools, such as Git.
Academic Qualifications:
- Engineering degree from a reputed institute
If you're early in your career (0-4 years of experience), want to learn about real-world product building, and still make decent money, this opportunity would be a great fit.
We need you –
1. to be a full-stack developer
2. can articulate and write well
3. to be a generalist
4. to have a passion for learning, and applying the knowledge
5. to be self-managed and disciplined
If you are someone who can relate to all the statements below, you're the one we are looking for.
1. Built and scrubbed many side projects
2. Have at least a dozen ideas in their backlog that they want to get to someday
3. You've taught yourself skills using Internet
Technical Roles and Responsibilities
- Demonstrate a systematic and disciplined architecture, system design and programming approach following a standard software development lifecycle
- Meticulous attention to detail and strong focus on clear and practical documentation
- Work closely with senior management, Development Manager, Project Manager, and a team of developers.
- Design, Code, Unit Test and support Software components
- Deliver quality software in a time following standard software development processes
- Analyze problems raised in software development or production environments and provide timely solutions
- Develop, prepare and maintain system documentation, including program descriptions, operational procedures etc.
- Act as the second line of support during production problems.
Mandatory Skills:
Software Engineering
u Strong experience in agile methodologies and test driven development.
u Experience in software development using open source technologies.
u Experience in automated software testing.
u Knowledge in domain-driven design, design patterns and enterprise integration patterns.
u Must have experience in delivering software via complete Continuous Integration and Continuous Delivery (CI/CD) pipeline.
Software Development
u Must be able to code in Java (SpingBoot and Spring Cloud Services).
u Experience in some of the technologies below:
o PaaS: Pivotal Cloud Foundy/Openshift/ AWS/ Azure/ Docker/ Kubernetes
o Data: MySQL/ Postgres/ Oracle/ MongoDB/ Elasticsearch
o Cache: Redis/ Memcached
o UI: HTML5,Bootstrap, CSS, Angular 4/ ReactJS/RxJS
- Strong knowledge in CI/CD toolset such as Ansible, Artifactory, Jenkins, BitBucket, SonarQube, Fortify, Flyway, Jira and Confluence.
- Strong knowledge in automated testing toolset such as jUnit, Mockito, cucumber, Selenium etc.
- Strong knowledge in scripting languages such as Groovy and Linux shell.









