The Sleep Company is hiring for Product Manager role

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

JTC provides software solutions to enterprises across the world. We believe that we can only succeed if and only if we have a passionate driven, and capable team. People are at the core of who we are.

We are looking for a person who will be responsible to understand our core values and translate them to create a workplace where our team feels proud to come to work every day.

Responsibilities:

1. Implement recruiting strategies to find the right person for each role in the organization, keeping diversity and inclusion as core values. This includes various activities such as sourcing candidates, scheduling interviews, and onboarding prospective team members.
2. Build the company's brand as a strong engineering company by holding hackathons, engaging with various local engineering groups, and other related initiatives.
3. Support HR functions (5% to 10%) when needed.

About you:

1. You are passionate and driven to build a great team.
2. You are someone who cares deeply about people and demonstrates deep empathy for team members of all backgrounds.
3. You have a willingness to roll up your sleeves and help the team get work done.

What you'll gain:

1. The ability to exercise creativity and leadership in your work.
2. The chance to build a great team that is on a mission to make the world a better place.
3. A team of highly selective, ambitious, and innovative co-workers.

Perks and Benefits:

1. Remote Friendly: You can work from place of your choice, including one time work from home setup reimbursement at the time of joining.
2. Comprehensive Health Insurance: INR 3L health insurance with a wide hospital coverage that covers your spouse, children and parents (with existing pre-conditions), including access to remote on call doctors.
3. Workation: Annual off-sites every year, fully paid, for the team to get together for a week to work and play.
4. Learning Opportunities: Access to best trainings for learning and skill advancements.
5. Time Offs: 12 paid leaves, 6 leaves per year on top of National and Regional holidays.
6. Paid Parental Leave: 6 months maternal and 1 month paternal.

This position is for our social media wing.

We would expect you to come armed with a sense of humor and an obsession with colors. Know your software, ditch the normal, and create more wacky Wednesdays than we could have ever imagined. You should be someone who can take direction from written or spoken ideas and convert them seamlessly into images, layouts, and other designs. You must be persistent and creative, with experience and demonstrated success in graphics designing.

This position is a full-time job at QBF Noida Sector 1 location.

Work Experience: 2+ years hands-on experience

Roles and Responsibilities

• Be part of the creative process from concept to completion.
• An intimate understanding of design, copy, and web best practices/guidelines, and a strong understanding of the latest creative trends.
• Possession of creative flair, versatility, conceptual/visual ability, and originality.
• Self-starter with a positive and enthusiastic attitude, the ability to work independently as well as in cross-functional groups and professionalism regarding time, costs, and deadlines.
• Stays abreast of the evolving technology and design landscape including the emergence of new standards and devices.
• Excellent communication skills, ability to multi-task in a fast-paced environment.
• Prioritize and manage work while adhering to project timelines in a fast-paced environment.
• Continually push your design experience and knowledge of new design trends and tools to help contribute to improved work processes within the team.
• Creative agency or editorial background a plus.
• Collaborates with the creative team in the production of marketing materials and media.
• Ensures visual communication and brand standards are met.
• Contributes innovative ideas to shape effective ad experiences across digital, mobile, print, and video platforms.
• Meet with internal clients to develop the materials needed.
• Meet deliverables timelines.
• Think creatively and develop new design concepts, graphics, and layouts.
• Prepare rough drafts and present your ideas.
• Illustrates concept by designing rough layout of art and copy regarding arrangement, size, type size and style, and related aesthetic concepts

Required Experience and Skills

• Bachelor's Degree in Graphics Designing or other relevant courses
• 2+ years of experience in graphics designing
• English: Fluent
• Adobe Photoshop, Adobe Illustrator, Video Editing is a must.

Perks

• 5 days working

How to apply

• Please share your CV along with the work portfolio.
• Applications without a portfolio will be rejected.

• Understand functional and non-functional testing requirements for APIs

• Document functional and non-functional testing scenarios and cases where needed, on one of the test management tools
• Identify or create data for testing 
• Automation framework design and implementation according to project structure
• Develop test automation scripts using tools like RestAssured and SoapUI
• Must be able to use all web methods like GET, PUT, POST, DELETE, etc.
• Validate feedback, response time, and error code
• Validate XML and JSON body using JSON Parser 
• Raise PR to check in code for test automation scripts
• Conduct peer reviews of test cases and automation scripts

Mandatory Skills


• Intermediate to advanced level skill in programming using Java and/or Python
• Intermediate to advanced level skill in using API test automation tools and developing test automation frameworks - RESTAssured, Postman, SoapUI, Karate, Robot
• Intermediate to advanced level skill in working with databases preferably SQL
• Configuration management - GIT • Build management - Maven
• Continuous Integration - Jenkins 
• Excellent verbal and written communication skills