SEO Executive

Role & Responsibilities:

As a Product Designer (Growth), you'll be the design force behind our growth initiatives—obsessing over conversion funnels, user onboarding, engagement mechanics, and monetization touchpoints. You'll combine deep UX expertise with growth hacking mindset, leveraging data and experimentation to design experiences that drive measurable business impact. We're looking for a metrics-driven, hypothesis-oriented designer who thrives on turning insights into scalable growth levers.

What You’ll Do-

• Drive growth-focused design initiatives across acquisition, activation, retention, and revenue optimization
• Design and optimize conversion funnels from first touch to long-term engagement, focusing on key growth metrics (CAC, LTV, retention rates, conversion rates)
• Lead experimentation through design—create A/B tests, landing page variants, onboarding flows, and feature experiments that drive statistically significant improvements
• Own critical growth touchpoints including signup flows, profile completion, subscription conversions, re-engagement campaigns, and referral mechanisms
• Translate growth insights into design solutions—turn user behavior data, cohort analyses, and business requirements into high-impact user experiences
• Design scalable growth systems—create templates, frameworks, and design patterns that enable rapid testing and iteration across growth initiatives
• Collaborate with Growth PMs, Data Analysts, and Engineers to identify growth opportunities, prioritize experiments, and measure design impact on key business metrics
• Optimize post-launch performance through continuous testing, user feedback integration, and data-driven design iterations
• Establish growth design culture by championing experimentation, sharing learnings, and mentoring team members on growth-focused design thinking

Growth-Specific Focus Areas:

• User acquisition and conversion optimization
• Onboarding and activation experience design
• Subscription and monetization flow optimization
• Retention and re-engagement campaign design
• Referral and viral growth mechanism design
• Personalization and recommendation interface design

Ideal Candidate

• Masters/Bachelor's from premier institutions (IIT, BITS, NID)
• 5 -8 years of full-stack product design experience with proven growth impact
• Strong portfolio demonstrating conversion optimization and growth-focused design solutions
• Experience with growth experimentation, A/B testing, and data-informed design decisions
• Proficiency in Figma, prototyping tools, analytics platforms, and growth measurement tools
• Understanding of subscription business models, pricing psychology, and monetization strategies
• Experience designing for both web and mobile platforms at scale
• Strong analytical mindset with ability to translate business metrics into design solutions
• Knowledge of user acquisition channels and performance marketing touchpoints

Bonus Traits:

• Experience in subscription-based or marketplace products
• Background in conversion rate optimization (CRO)
• Understanding of international market expansion and localization
• Experience with AI-powered personalization and recommendation systems

Key Responsibilities:

• Identify and acquire new clients for stock broking services
• Promote products like Equity, F&O, Commodity, and Mutual Funds
• Generate leads through calls, field visits, social media, and references
• Assist clients in opening Demat & Trading accounts
• Maintain strong relationships with existing clients
• Achieve monthly and quarterly sales targets
• Provide basic market information and guide clients to advisors
• Follow up with prospects and convert them into active investors

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

Must Have

1. Angular 13+

2. Understanding of Cloud architecture

3. Node.js + Expressjs +MongoDB (Localization Project)

Management skills required

1. Drive scrum meetings (Daily sync-up, Weekly planning meetings, Monthly meetings)

2. JIRA Understanding, including JIRA Reports, Releases

3. Code Review

4. Document preparation for any new feature/requirements using confluence

5. Track team timesheet reports

6. Communication with External team members  

This is a remote position.

About Company

Our client is angle funded,  growth stage B2B SaaS startup that enables a seamless and streamlined collaboration between big pharma, bio-techs and their external manufacturing partners.

Job Profile

• Develop all user-facing products in React.JS
  
• Build reusable components and front-end libraries for future use.
  
• Translate designs and wireframes into high quality code
  
• Focus on code maintainability and performance of application.
• Provide technical advice and assists in solving programming problems

• Strong proficiency in JavaScript, including DOM manipulation and the JavaScript object model
• Good foundation in design and a knack for designing interactions and elegant interfaces
• Thorough understanding of React.js and its core principles
• Good to have experience with popular React.js workflows (such as Flux or Redux)
• Experience with data structure libraries
• Familiarity with RESTful APIs
• Familiarity with modern front-end build pipelines and tools
• A knack for bench-marking and optimization
• Familiarity with code versioning tools (such as Git)
• Proficient in industry standard best practices such as Design Patterns, Coding Standards, Coding module, Prototypes etc.
• Experience in using debugging tools used for profiling/optimizing performance
• Experience in debugging, tuning and optimizing UI components

Desired Candidate Profile