Senior Software Engineer

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 Overview:

We are looking for a seasoned Senior Backend Engineer (SDE III) with over 5 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 Backend 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 role we require expertise in Python/Django and API Development
• Experience with cloud infrastructure (AWS), microservices, and distributed systems.
• Good experience with MySQL and ElasticSearch. Slight experience with other NoSQL and SQL databases.
• Experience in DevOps, CI/CD pipelines, and infrastructure automation.
•  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.

Sound technical exposure in React, Node, API, Java, JPA, Hibernate, Kafka, REST API,

Postgre DB.

• Strong experience in systems design principles.

• Must have strong exposure in PSQL queries and stored procedures.

• Experience in Lending/Fintech domains will be preferable.

• Design, implement and maintain Java-based applications that can be high-volume and

low-latency.

• Familiarity with browser testing and debugging.

• Analyze user requirements to define business objectives.

• Identify and resolve any technical issues arising.

• Develop technical designs for application development.

• Conducting software analysis, programming, testing, and debugging.

• Manage Java and Java EE application development.

• Understanding of strategic handling of technical projects. i.e. adhering to stakeholder

expectations and processes.

What You’ll Do:

• Work closely with the core team to understand their needs and ensure that our products are meeting the needs of the market.
• Designing database structure that are easy to maintain, improves data consistency and are cost effective in terms of disk storage space
• Identify, prioritise and execute tasks in the software development life cycle
• Develop tools and applications by producing clean, efficient code
• Document and demonstrate solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments and clear code
• Build efficient, testable, and reusable PHP modules

What You’ll Bring

• Bachelor's in Computer Science, Software Engineering or a related field.
• A 5+ years of experience in developing desktop and mobile web applications
• Strong knowledge of core PHP with experience of working with MVC framework such as CodeIgniter & Laravel
• Experience with object-oriented PHP programming
• Experience with third party API integration
• Experience in managing AWS services
• Previous experience creating scalable applications
• Knowledge of multiple front-end languages and libraries (e.g. HTML/ CSS, JavaScript, XML, jQuery)

Job Description:-

Infrastructure as Code (IaC): Implement and maintain infrastructure as code using tools like Terraform or AWS CloudFormation, ensuring scalability and reliability of cloud resources.

Continuous Integration/Continuous Deployment (CI/CD): Establish and enhance CI/CD pipelines to automate build, test, and deployment processes, facilitating faster and more reliable releases.

Configuration Management: Manage and automate server configurations using tools like Ansible, Chef, or Puppet, ensuring consistency and compliance across environments.

Monitoring and Logging: Set up and maintain monitoring and logging solutions (e.g., CloudWatch, ELK stack) to proactively identify and troubleshoot issues within the AWS infrastructure.

Security and Compliance: Implement security best practices and compliance standards (e.g., AWS IAM, Security Groups) to protect data and resources. Conduct security audits and vulnerability assessments.

The Successful Applicant

AWS Proficiency: Extensive experience with Amazon Web Services (AWS) and its services, including EC2, S3, RDS, Lambda, and more. AWS Certified DevOps Engineer certification is a plus.

Infrastructure as Code (IaC): Proficiency in writing and maintaining infrastructure as code using tools like Terraform, AWS CloudFormation, or similar technologies.

CI/CD Tools: Strong knowledge of CI/CD tools such as Jenkins, Travis CI, or AWS CodePipeline. Ability to configure and optimize automated build and deployment pipelines.

Containerization: Hands-on experience with containerization technologies like Docker and container orchestration platforms like Kubernetes in AWS.

Scripting and Automation: Proficiency in scripting languages (e.g., Bash, Python) for automating tasks and managing infrastructure.

Monitoring and Logging Tools: Familiarity with monitoring and logging tools such as CloudWatch, ELK stack (Elasticsearch, Logstash, Kibana), Prometheus, Grafana, or Splunk.

Security and Compliance: Strong understanding of AWS security best practices, identity and access management (IAM), and compliance frameworks (e.g., HIPAA, GDPR).

Networking: Knowledge of AWS networking concepts, VPC, and routing. Experience with VPNs, Direct Connect, and other networking technologies is a plus.

Database Administration: Basic knowledge of database administration on AWS, including RDS, DynamoDB, or Aurora.

Collaboration and Communication: Excellent communication and teamwork skills to collaborate with cross-functional teams and convey technical information effectively.

Your Responsibilities :