First Due

Position - SSE Reporting Location - Hyderabad (On-site) Company - First Due Role Overview We are seeking an exceptional Senior Software Engineer specializing in reporting and analytics to join our emergency response technology platform. This role demands a unique blend of advanced SQL expertise, database architecture proficiency, and hands-on reporting system development. You will be responsible for designing and optimizing complex reporting solutions that process millions of records, reviewing and enhancing database architectures for performance, and building scalable analytics platforms that empower Fire & EMS agencies with critical operational insights. The ideal candidate brings deep expertise in SQL optimization, proven experience with enterprise reporting tools, and a track record of transforming complex datasets into actionable intelligence. 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 About Company  First Due Suite is re-imagining how Fire & EMS agencies run their operation by offering best-of-breed Pre-Planning, Fire Prevention, Incident Reporting, Scheduling & Personnel, Assets & Inventory, Community Engagement, and Response – all in a single, cloud-based platform.Customers using First Due are transforming how they function, before, during, and after an incident - ultimately leading to better decisions and a safer community. Details Website Industry Software Development Company size 201-500 employees