
About Prodio DesignWorks
About
Connect with the team
Similar jobs
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 Summary:
We are seeking a skilled MERN Stack Developer to join our dynamic development team. The ideal candidate will have hands-on experience in building modern web applications using MongoDB, Express.js, React.js, and Node.js. You will be responsible for designing and developing scalable, high-performance web applications and collaborating with cross-functional teams to deliver top-tier solutions.
Key Responsibilities:
- Develop and maintain responsive web applications using the MERN stack.
- Design, build, and maintain RESTful APIs and integrate third-party services.
- Collaborate with UI/UX designers, product managers, and other developers to deliver seamless user experiences.
- Optimize applications for performance and scalability.
- Write clean, maintainable, and efficient code.
- Participate in code reviews and provide constructive feedback.
- Debug and troubleshoot issues across the full stack.
- Implement security and data protection best practices.
JOB PURPOSE
A Senior Associate Java WCS Technologist is considered as a senior contributor for complex modules of work by bringing deep core technology expertise and relevant business subject matter expertise to the table.
JOB RESPONSIBILITIES
- Sr. Associate, Technology plays a significant role during the design and implementation of the technological solution for our clients.
- A Sr. Associate, Technology is involved in ensuring a quality technical design that satisfies the business requirements of the client.
- A Sr. Associate, Technology is often involved in package evaluations and recommendations, communicating the technological details of the project to the business users and workshops with the clients. Sr. Associate, Technology also participates in gathering business requirements and assessing existing architectures and resources.
- Sr. Associate, Technology provides leadership to the team by taking responsibility for a specific component or track of the project architecture. By taking on this level of responsibility, a Sr. Associate, Technology spends more time overseeing the tasks required to implement a solution rather than performing the tasks directly. This includes planning, estimation, resource management, issue resolution and quality assurance. A Sr. Associate, Technology is also responsible for coordinating and communicating with the other tracks and disciplines involved in the project.
- In performing the essential functions of this role, the work is fast-paced, moderately noisy and team-based. Additionally, frequent overnight travel is required.
- Prepares the technical design of the more complex technology components within the module (one or more of client/web presentation tier, server tier, data access and data model, integration component, package function customization)
- Participates in and in some cases drives design reviews of other modules and provides insightful comments to improve the design quality and design conformance to standards
- Assists the architect in articulating the pros and cons of using a certain technology stack/package or component or design pattern versus another to the clients and project team and drives selection of technologies, designs to come up with the optimal architecture
- Implements slice of application (EAR) and proofs of concept (spike solution) to prove any new technologies or integration scenarios in the module
- For package implementations, aids the Architect of the project to perform the gap analysis between business requirements and the package features and design the configuration, customizations, extensions, interfaces required to meet the requirements
- Provides innovative solutions to project level technical issues
- Critiques a design created by another designer and helps identify design and performance improvements
- Interacts with a set of clients (client senior developers and architects) to create technology specifications from business requirements for one of the modules within the project
- In some scenarios, collaborates with client developers to design, build, test and deploy the module components and integrate with the rest of the modules
- Raises and drives to closure with the client any technical design and implementation issues in the module and also in the interfaces and interactions with other modules
- Estimates the implementation and deployment of the module based on design architecture, testing strategy and overall project plan
- Assists the architect in coming up with the overall estimates for the project along with any key risks and issues and their mitigation
- Reports progress and issues to the Manager in a timely manner. In particular, to relay issues that might impact on quality or the ability to deliver to timescales or estimates
- Works with team on the development of standards, processes and procedures related to application security, upgrade management, capacity planning, application deployment, performance monitoring/tuning, and failover and disaster recovery
- Mentors the team on the best techniques to debug and troubleshoot design and implementation defects and issues
- Shares point of view on technology stack, package and latest technology and business trends in one or more relevant areas (e.g. eCommerce, Content Management).
- Documents the technical design using UML, suitable design patterns in the form of technical design narrative, object models, sequence diagrams, collaboration diagrams
SKILL REQUIREMENTS
Experience in: J2EE - Application Servers, Java - ORM, Java - Spring Framework, Core
Java, SQL Development Languages, Java - Web, Presentation Frameworks, Java - Messaging
Implementation, Java Web Services, Planning/ Execution & Tracking, Scoping and
Estimating, Data Modeling, High Availability and Failover Applications, High Throughput / Transaction Application, Logical Architecture Design, OOAD and UML, Package / Vendor Selection, Performance / Capacity Planning, Application, Security.
Ability to abstract detail into larger (repeatable) patterns, familiarity with user centered analysis and evaluation techniques
Understanding of the project life cycle process to effectively be able to manage a sub-
Business Knowledge: Domain experience on Enterprise data warehouse would be a plus.
Personal Attributes: a. Strong and innovative approach to problem solving and finding solutions b. Excellent communicator (written and verbal, formal and informal) c. Flexible and proactive/self-motivated working style with strong personal ownership of problem resolution d. Ability to multi-task under pressure and work independently with minimal supervision. e. Ability to prioritize when under pressure
EXPERIENCE
2-8 years
EDUCATION
Full Time Bachelor’s / Master’s degree (Science or Engineering preferred)
🚀 Hiring: MERN Stack Developer
⭐ Experience: 3+ Years
📍 Location: Mumbai ( Andheri East)
⭐ Work Mode:- 5 Days Work From Office
⏱️ Notice Period: Immediate Joiners
(Only immediate joiners & candidates serving notice period)
We are looking for a MERN Stack Developer skilled in MongoDB, Express.js, React.js, and Node.js to build scalable, high-performing web applications.
💫 What We’re Looking For:
✅ Proficiency in React.js, Node.js, Express.js, MongoDB
✅Strong in JavaScript (ES6+), REST APIs, Git
✅Good problem-solving & debugging skills
About SuperHuman Race
In 2016, we started imagining a world where 'good' is valued and rewarded. Based on this lofty mission of making the world a better place, powered by human kindness, we started looking for our answers in data and technology. At the SuperHuman Race, we take pride in using creativity and data to solve intersections. In working out these solutions, we discover the engineers, the architects, and the authors that live and breathe deep inside the colorful fabric of society. We automate social purposes for organizations and deliver impact-related insights to all of our users. At the core of the SuperHuman Race is the belief that while good work is important and aspiring to make an impact is necessary, it cannot be sustainable unless it is also fun!
Job Summary
We are looking for a Front-End Developer who is passionate about pushing mobile technologies to their limits. You will work with our team of talented engineers to design, build, and enhance the next generation of our mobile applications. This role will give you the opportunity to work on impactful projects while collaborating with cross-functional teams to create secure, scalable, and user-friendly Android solutions.
Key Responsibilities:
- Translate UI/UX design wireframes into high-quality, responsive code.
- Develop new user-facing features to enhance the user experience.
- Ensure cross-browser compatibility and optimize applications for maximum speed and scalability.
- Integrate front-end components with back-end services and APIs.
- Maintain and improve existing user interface components.
- Write well-documented, reusable, and efficient code.
- Balance functional and aesthetic design for a seamless user journey.
- Identify and troubleshoot performance bottlenecks and bugs.
- Ensure design and implementation are aligned with the overall architecture and technical standards.
- Collaborate closely with designers and developers to ensure smooth integration and delivery.
Qualifications:
- Bachelor’s degree in Computer Science, Engineering, or a related field.
- 2+ years of professional experience in front-end development.
- Strong proficiency in HTML5, CSS3, JavaScript, and jQuery.
- Experience with Bootstrap and responsive web design principles.
- Proficiency in Git or other version control systems.
- Understanding of cross-platform optimization and mobile responsiveness.
- Familiarity with front-end build tools (Webpack, Gulp, or similar).
- Experience with front-end frameworks (React, Vue.js, or Angular) is a plus.
- Basic understanding of PHP and RESTful API integration
- Familiarity with image editing tools such as Figma, Adobe XD, Photoshop, or Gimp.
- Strong problem-solving, analytical, and debugging skills.
Preferred Skills:
- Strong understanding of scalable front-end architecture and reusable components.
- Experience in performance optimization and accessibility standards.
- Knowledge of SEO principles and best practices.
- Familiarity with testing frameworks (Jest, Mocha, Cypress).
- Attention to detail and an eye for clean, intuitive UI/UX design.
- Ability to collaborate in a team-oriented, agile environment.
Why Join Us?
- Build purpose-driven digital experiences that create measurable social and environmental impact.
- Work with a talented, mission-driven team across sustainability, tech, and design.
- Exposure to cutting-edge technologies and international projects.
- 5 Days Working.
- Informal Dress Code.
- Paid Time Off and Work-from-Home Flexibility (as required).
How to apply?
Send your resume and portfolio (if available) with a brief overview of your work, current CTC & Notice Period details to arman at mysuperhumanrace . com
Subject: Application for Full Stack Developer
At SHR, we believe in meritocracy and are proud of the diverse team we have built. We welcome talent from all regions, geographies, languages, backgrounds, cultures, genders, and age groups in our attempt to accelerate progress and deliver on our shared goals of sustainability & equity.
- Experience with front-end technologies such as Angular or React with Redux.
- Experience working in NodeJS with Express
- Experience with PHP development using any one of it's framework will be considered as a value add
- Experience working with SQL or NoSQL databases, the ability to write efficient queries and benchmark/profile them
- Mastery of object oriented JavaScript, ES6, HTML, and CSS/SASS/StyledComponents
- Experience in RESTful API development
- Strong understanding of asynchronous programming
- Experience with performance debugging and benchmarking
- Experience with testing frameworks like Karma, mocha, or jest
- Experience with Git version control
- Understanding of CI/CD
- Strong attention to design detail (UI/UX).












