W&P Management, LLC is a corporate employer supporting various businesses within the outdoor power equipment and power sports industries. They are seeking a Senior Software Engineer to design, develop, and maintain backend services, optimize SQL queries, and enhance a reporting platform while collaborating with internal stakeholders.
Responsibilities:
- Design, develop, and maintain backend services using Java within an AWS-hosted environment
- Develop and optimize complex SQL queries in PostgreSQL to support reporting, data processing, and system integrations
- Design and implement database schema changes using a migration-based approach (e.g., Flyway), ensuring all changes are version-controlled, repeatable, and production-safe
- Analyze and improve performance of existing reports and scheduled jobs, including query optimization, indexing strategies, and execution planning
- Support and enhance a reporting platform that includes 50+ custom reports and scheduled report delivery functionality
- Build and maintain integrations with third-party systems including ChannelAdvisor (Rithum), Funnel.io, DealerSpike PartSmart, and other external data sources
- Monitor application health using logs, dashboards, and system alerts; investigate and resolve production issues related to application performance, data integrity, and system integrations
- Develop and maintain data-driven user interface components, including reports, dashboards, and chart visualizations
- Implement and modify HTML, CSS, and lightweight JavaScript to support user interaction and data presentation
- Work within a Docker-based development and deployment environment
- Collaborate with internal stakeholders to understand business requirements and translate them into technical solutions
- Document system behavior, database structures, and integration logic to reduce reliance on individual contributors
- Work across the full stack when needed, with primary focus on backend systems and data processing
Requirements:
- Bachelor's degree in Computer Science, Information Technology, or a related field is preferred
- 5+ years of backend development experience, preferably in Java
- Strong expertise in SQL, with demonstrated experience in PostgreSQL or similar relational databases
- Experience designing and optimizing database schemas, indexes, and complex queries for performance
- Experience working with database migration tools such as Flyway or Liquibase
- Experience building and maintaining integrations with external APIs and third-party systems
- Familiarity with AWS services and cloud-based application environments
- Experience working with Docker and containerized applications
- Experience working with HTML, CSS, and JavaScript to build or modify data-driven user interfaces (e.g., reports, dashboards, charts)
- Comfortable contributing to both backend and frontend layers in a practical full-stack capacity, with primary strength in backend and data systems
- Ability to work independently in an existing codebase with limited documentation
- Strong problem-solving and debugging skills in production environments
- Effective communication skills and ability to collaborate with both technical and non-technical stakeholders
- Experience building internal business tools or reporting systems is a plus