Senior Software Engineer

Optomi, in partnership with a leading enterprise organization, is seeking a Senior Software Engineer to design and deliver scalable analytics, dashboards, reporting solutions, and lightweight applications using existing enterprise data. This is a senior, hands-on role focused on transforming complex business requirements into reliable, data-driven solutions across AWS and SQL environments. The right candidate will combine advanced SQL skills, AWS cloud expertise, dashboard development, software engineering, testing, and production troubleshooting. This is not a traditional ETL or task-execution role. The engineer will be expected to question assumptions, identify inefficiencies, challenge existing approaches, and drive better technical and business outcomes. What the Right Candidate Will Enjoy: Building analytics, dashboards, KPI reporting, and data-driven solutions used for business decision-making Working across AWS services including Athena, RDS, S3, Lambda, QuickSight, EC2, ECS, and API Gateway Solving complex technical and business problems across distributed cloud environments Designing reusable SQL queries, views, services, and automation tools Improving reporting efficiency, data accuracy, platform reliability, and application performance Using logs, metrics, and traces to troubleshoot production issues and identify root causes Influencing architectural decisions and challenging inefficient or outdated approaches Mentoring engineers, reviewing code, and helping establish technical standards Collabring with business stakeholders, product teams, engineers, and cross-functional technology groups Working in a senior role where strategic thinking, technical ownership, innovation, and continuous improvement are highly valued Experience of the Right Candidate: 8–10+ years of software development, cloud engineering, analytics engineering, or related technical experience 5+ years of hands-on AWS cloud platform experience Strong experience with AWS services including EC2, S3, Lambda, RDS, ECS, API Gateway, Athena, and IAM Advanced SQL experience, including complex queries, reusable views, optimization, and performance tuning Experience working with PostgreSQL, MySQL, Aurora, Hive, or similar database technologies Strong experience building analytics, dashboards, KPI reports, and data-visualization solutions Experience with QuickSight, Tableau, Power BI, or a similar business-intelligence platform Strong programming experience with Python, Node.js, Go, or a similar language Experience designing RESTful APIs and working with microservices architectures Experience with Infrastructure as Code using Terraform or CloudFormation Experience with AWS monitoring and troubleshooting tools including CloudWatch, CloudTrail, and X-Ray Experience analyzing logs, metrics, and traces across distributed systems Experience with CI/CD pipelines, with GitLab exposure preferred Experience validating data and performing regression, performance, unit, and end-to-end testing Experience supporting production systems, responding to incidents, and participating in on-call rotations Strong problem-solving, root-cause analysis, communication, and technical-leadership skills Proven ability to think strategically, challenge assumptions, and recommend better technical solutions Responsibilities of the Right Candidate: Build and optimize SQL-based analytics, dashboard, reporting, and business-insight solutions Analyze enterprise data using AWS services such as Athena, RDS, Hive, S3, and Aurora Develop and maintain dashboards, KPI reports, reusable queries, and reporting views Partner with stakeholders to define, refine, and validate business metrics and reporting logic Ensure the accuracy, consistency, reliability, and performance of analytics solutions Create lightweight automation, applications, APIs, and tools to reduce manual reporting effort Design and support cloud-based services using EC2, Lambda, ECS, API Gateway, and other AWS technologies Develop solutions using Python, Node.js, Go, or similar programming languages Design RESTful APIs and contribute to microservices-based architectures Implement and maintain AWS infrastructure using Terraform or CloudFormation Monitor and troubleshoot distributed systems using CloudWatch, CloudTrail, X-Ray, logs, metrics, and traces Perform systematic root-cause analysis and resolve complex production issues Conduct regression testing of dashboards and reports, query-performance testing, unit testing, and end-to-end testing Support production incidents and participate in on-call responsibilities when required Identify technical debt, reporting inefficiencies, performance issues, and opportunities for automation Challenge existing processes and propose more scalable, reliable, and effective solutions Mentor engineers, conduct code reviews, document technical designs, and maintain engineering standards Collaborate with engineering, product, analytics, business, security, and infrastructure teams Nice-to-Have Experience: Amazon QuickSight expertise AWS Solutions Architect or AWS DevOps Engineer certification Serverless architecture experience Frontend application development or support experience using React, Angular, or Vue.js Angular exposure for lightweight reporting or dashboard applications Experience with additional AWS services such as EMR and Glue Python scripting for reporting and workflow automation Experience with automated testing frameworks Experience working in a regulated industry Experience documenting architecture, troubleshooting procedures, and operational support guides #J-18808-Ljbffr Optomi