Sr. Engineer / Asst. Manager – Estimation (E&I)

Job Description: Data Analyst

About the Role

We are seeking a highly skilled Data Analyst with strong expertise in SQL/PostgreSQL, Python (Pandas), Data Visualization, and Business Intelligence tools to join our team. The candidate will be responsible for analyzing large-scale datasets, identifying trends, generating actionable insights, and supporting business decisions across marketing, sales, operations, and customer experience..

Key Responsibilities

• Data Extraction & Management
• 
  
• Write complex SQL queries in PostgreSQL to extract, clean, and transform large datasets.
• 
  
• Ensure accuracy, reliability, and consistency of data across different platforms.
• 
  
• Data Analysis & Insights
• 
  
• Conduct deep-dive analyses to understand customer behavior, funnel drop-offs, product performance, campaign effectiveness, and sales trends.
• 
  
• Perform cohort, LTV (lifetime value), retention, and churn analysis to identify opportunities for growth.
• 
  
• Provide recommendations to improve conversion rates, average order value (AOV), and repeat purchase rates.
• 
  
• Business Intelligence & Visualization
• 
  
• Build and maintain interactive dashboards and reports using BI tools (e.g., PowerBI, Metabase or Looker).
• 
  
• Create visualizations that simplify complex datasets for stakeholders and management.
• 
  
• Python (Pandas)
• 
  
• Use Python (Pandas, NumPy) for advanced analytics.
• 
  
• Collaboration & Stakeholder Management
• 
  
• Work closely with product, operations, and leadership teams to provide insights that drive decision-making.
• 
  
• Communicate findings in a clear, concise, and actionable manner to both technical and non-technical stakeholders.
• 
  

Required Skills

• SQL/PostgreSQL
• 
  
• Complex joins, window functions, CTEs, aggregations, query optimization.
• 
  
• Python (Pandas & Analytics)
• 
  
• Data wrangling, cleaning, transformations, exploratory data analysis (EDA).
• 
  
• Libraries: Pandas, NumPy, Matplotlib, Seaborn
• 
  
• Data Visualization & BI Tools
• 
  
• Expertise in creating dashboards and reports using Metabase or Looker.
• 
  
• Ability to translate raw data into meaningful visual insights.
• 
  
• Business Intelligence
• 
  
• Strong analytical reasoning to connect data insights with e-commerce KPIs.
• 
  
• Experience in funnel analysis, customer journey mapping, and retention analysis.
• 
  
• Analytics & E-commerce Knowledge
• 
  
• Understanding of metrics like CAC, ROAS, LTV, churn, contribution margin.
• 
  
• General Skills
• 
  
• Strong communication and presentation skills.
• 
  
• Ability to work cross-functionally in fast-paced environments.
• 
  
• Problem-solving mindset with attention to detail.

Education: Bachelor’s degree in Data Science, Computer Science, data processing

Job Title: Data Engineer

Location: Pune, India

Experience: 5 to 9 years

Job Description:

We are seeking a talented and experienced Data Engineer to join our team in Pune. The ideal candidate will have a strong background in data engineering with expertise in Python, AWS, Spark, and Scala. This role is critical to our data infrastructure, ensuring that our data pipelines are robust, efficient, and scalable.

Required Skills:

• Python: Advanced proficiency with extensive experience in building data pipelines.
• AWS: Hands-on experience with AWS services such as S3, Lambda, Redshift, Glue, and EMR.
• Spark: Proficient in using Apache Spark for large-scale data processing.
• Scala: Working knowledge of Scala for Spark programming.
• Strong understanding of data warehousing concepts and ETL processes.
• Experience with SQL and relational databases.
• Familiarity with data governance and security best practices.
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills.

• Work closely with Product Managers to drive product improvements through data-driven decisions.
• Conduct analysis to determine new project pilot settings, new features, user behavior, and in-app behavior.
• Present insights and recommendations to leadership using high-quality visualizations and concise messaging.
• Own the implementation of data collection and tracking, and coordinate with the engineering and product team.
• Create and maintain dashboards for product and business teams.
• Lead and own the analysis of highly complex data sources, identifying trends and patterns in data, and provide insights/recommendations based on analysis results
• Track feature success of new launches, and set systems to identify causation of change in metrics post every release.
• Deep dive on experiment results, and present insights for the supporting the subsequent product decisions.

Responsibilities

• Installing and configuring Informatica components, including high availability; managing server activations and de-activations for all environments; ensuring that all systems and procedures adhere to organizational best practices
• Day to day administration of the Informatica Suite of services (PowerCenter, IDS, Metadata, Glossary and Analyst).
• Informatica capacity planning and on-going monitoring (e.g. CPU, Memory, etc.) to proactively increase capacity as needed.
• Manage backup and security of Data Integration Infrastructure.
• Design, develop, and maintain all data warehouse, data marts, and ETL functions for the organization as a part of an infrastructure team.
• Consult with users, management, vendors, and technicians to assess computing needs and system requirements.
• Develop and interpret organizational goals, policies, and procedures.
• Evaluate the organization's technology use and needs and recommend improvements, such as software upgrades.
• Prepare and review operational reports or project progress reports.
• Assist in the daily operations of the Architecture Team , analyzing workflow, establishing priorities, developing standards, and setting deadlines.
• Work with vendors to manage support SLA’s and influence vendor product roadmap
• Provide leadership and guidance in technical meetings, define standards and assist/provide status updates
• Work with cross functional operations teams such as systems, storage and network to design technology stacks.

Preferred Qualifications

• Minimum 6+ years’ experience as Informatica Engineer and Developer role
• Minimum of 5+ years’ experience in an ETL environment as a developer.
• Minimum of 5+ years of experience in SQL coding and understanding of databases
• Proficiency in Python
• Proficiency in command line troubleshooting
• Proficiency in writing code in Perl/Shell scripting languages
• Understanding of Java and concepts of Object-oriented programming
• Good understanding of systems, networking, and storage
• Strong knowledge of scalability and high availability

If you believe in “ First, solve the problem. Then, write the code. ”, we are looking for you. 

• Atleast 4 - 6 years of experience working Ruby on Rails.
• Ability to manage a team.
• Very good at Analysis and Design.
• Passion to write good quality code.
• Able to work in a fast paced environment.
• Able to manage multiple tasks with changing priorities in a cross-functional environment
• Team player
• Ability to balance competing priorities.
• Excellent communication skills.

BoTree Technologies was incorporated in 2012 and since then we have constantly worked towards building a place to work which provides each member an opportunity to challenge herself and grow on a day to day basis.

PHP, HTML, CSS, JAVASCRIPT, AJAX, REST API, JQUERY, POSTGRESQL, MYSQL, MVC FRAMEWORK.

Responsibilities:

• Design and build advanced applications
• Work with outside data sources and APIs
• Unit-test code for robustness, including edge cases, usability, and general reliability
• Work on bug fixing and improving application performance
• Continuously discover, evaluate, and implement new technologies to maximize development efficiency
• Building reusable code and libraries for future use
• Optimization of the application for maximum speed and scalability
• Implementation of security and data protection
• Able to understand and create Documentation according to Client requirement.

Requirements:

• Ability to write clean, commented and maintainable code.
• Proven track record in designing, architecting, developing enterprise class products and solutions.
• Good understanding of MVC frameworks.
• Good understanding of front-end technologies and platforms, such as JavaScript, HTML5, and CSS3.
• Desired experience in PHP.
• Understanding accessibility and security compliance.
• User authentication and authorization between multiple systems, servers, and environments.
• Integration of multiple data sources and databases into one system.
• Management of hosting environment, including database administration and scaling an application to support load changes.
• Data migration, transformation, and scripting.
• Understanding differences between multiple delivery platforms such as mobile vs desktop, and optimizing output to match the specific platform.
• Implementing automated testing platforms and unit tests.
• Proficient knowledge of a back-end programming language.
• Proficient understanding of code versioning tools, such as Git.
• Proficient understanding of OWASP security principles.
• Proper understanding of OOPS concepts.
• Creating database schemas that represent and support business processes.
• Understanding of startup culture.
• Good team player, Quick learner.