Project Engineer/Project Manager

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

Game designers create the concepts and worlds of video games. They are involved with the design of the environment, story, characters, objectives and user experience of video games. 

Role and Responsibilities

They may be expected to deliver the following:

• Design and develop the original concept
• Construct level structure
• Storyboard the action of the game
• Conceive every element of the game including rules, setting, objects, vehicles, weapons, flora, fauna, etc, 
• Define user interface, menus and controls
• Generate the Game Design Document (GDD)
• Develop early prototypes
• Decide on the devices and platforms on which the game is played 
• Define the user experience 
• Work with programmers to design the back end of the game
• Research target audience to understand what they want in the game
• Lead the development process
• Produce sound effects, dialogue, musical score, sound mix and sound edit
• Manage quality assurance testing, and follow up on feedback
• Oversee the marketing and distribution roll-out
• Ongoing development and versions of the game

Game Designers should have a solid knowledge of 3D animation, illustration And programming languages.

• Must have good analytical and problem solving skills.
• Good Knowledge of OOPS, PHP, MVC frameworks.
• Write error free code and follow coding standards. Able to perform Code Review job.
• Work closely with QA person to assist in the testing process. 
• Perform R&D tasks if assigned and communicate with the Designer and UI team.
• Build reusable code and libraries for future use.
• Able to work closely with the team and meet the tight deadlines where necessary.
• Strong Communication Skills.

As a Go lang Developer, you will be working on Blockchain Layer 1.

● Advanced proficiency in Golang programming language, and good skills in languages such as C++,

Java, Solidity and Python (good to have).

● Extensive experience in back-end development, algorithms, and data structures.

● Extensive Knowledge of blockchain structure, protocol development or Smart Contract

● Writing clean, efficient, and reusable code that follows best practices and coding standards.

● knowledge of distributed and decentralized network protocols

● Knowledge of various decentralized ledger technologies and protocols

● Understanding of gossip protocol and consensus protocol

● Knowledge of best practices in data protection.

● Collaborating with managers to determine technology needs and envisaged functionalities.

● Creating application features and interfaces by using programming languages and writing multithreaded codes.

● Applying the latest cryptology techniques to protect digital transaction data against cyberattacks and information hacks.

● Maintaining client and server-side applications.

JD :

1yrs of B2B sales & Enterprise sales experience.

Lead generation/prospecting, client engagement, product-Demo.

Negotiation and closing deals, sales reporting.

Managing client relationships.

Strong understanding of selling SaaS technologies.

Strong verbal & written communication.

Demonstrated ability to develop new business opportunities.

Why LiftOff? 

We at LiftOff specialize in product creation, for our main forte lies in helping Entrepreneurs realize their dream. We have helped businesses and entrepreneurs launch more than 70 plus products.

Many on the team are serial entrepreneurs and have had a history of successful exits.

• 5+ years of experience, working on frontend technologies
• Individual contributor - responsible for the design, coding, and unit testing
• Should have good working experience in React and React Native
• Should have a good understanding of state management in frontend/UI applications
• Proficiency in Javascript / ECMAScript 6+
• Creating custom, general-use modules, and components that extend the elements and modules of React
• Good knowledge of data structures, problem-solving / algorithms
• Knowledge of creating custom / reusable components
• Should know OOP Concepts

We are a group of passionate people driven by a set of core values. We strive to make every process transparent and have flexible work timings along with great startup culture and vibe. There are no job designations because its a flat hierarchy.

Are you looking for a promising career with a well known ed-tech brand, which is looking to make life easier for kids and parents to understand basic concepts of learning? Then read on.

Our client aspires for equity in education along with profound, measurable societal impact. The company provides learning solutions such as digitalized educational contents, English speaking, school infrastructure, improvement and management solutions etc. for a spectrum of audiences ranging from children in schools and informal setting, to teachers, adults, and corporate. They've created significant reach and impact at scale; through their presence across 32 States and Union Territories and 478 districts of India, in 36,000 schools and with a network of around 300 Institutes of Skills, and 100 industrial clusters, they directly impact 15 million people on a daily basis.

What you need to have:

• Interpreting creative briefs to develop and produce creative concepts through execution on assigned brands
• Researching and understanding the target audiences, through online searches, reviews of existing research, interviews with subject matter experts and in-person meetings
• Writing original copy and editing content for a range of corporate marketing and communications materials
• Revising copy based on feedback/ direction
• Maintaining up-to-date knowledge of communication and industry trends
• Staying updated on appropriate style guidelines and brand voice for consistency in messaging

Desired Candidate Profile

• Bachelor’s degree in journalism, English, communications or related discipline
• Minimum 2-5 years professional copywriting experience with solid portfolio of work
• Exceptional writing and research skill
• Ability to work independently and with a team to meet deadlines
• Excellent organizational skill and multitasking ability
• Social media or content marketing experience a plus
• Proofreading experience and familiarity with standard style guides a plus
• Experience working with content management systems, WordPress, etc.
• A keen eye for detail and appreciation of great design