Data Warehouse Engineer Job at Porch Group – Remote India | ₹22.05 LPA
Porch Group is hiring a Data Warehouse Engineer in India for a full-time remote position. The role is suitable for experienced data engineers with strong expertise in SQL, Google Cloud Platform, BigQuery, Dataflow and Cloud Composer.
The position offers an annual salary range of ₹15,75,000 to ₹22,05,000, depending on experience, skills, job-related knowledge, location and other factors.
Porch Group maintains an India-focused careers presence and describes its India opportunities as fully remote across the country.
Data Warehouse Engineer Job Details
| Job Details | Information |
|---|---|
| Company | Porch Group |
| Job Title | Data Warehouse Engineer |
| Job Type | Full-time |
| Location | India |
| Workplace | Remote |
| Experience Required | 3+ years |
| Salary | ₹15.75 LPA – ₹22.05 LPA |
| Core Skills | SQL, BigQuery, Dataflow, Cloud Composer, GCP |
| Job Function | Data Engineering / Data Warehousing |
| Working Hours | 8 hours excluding breaks |
| US Overlap | 7:30 PM – 11:30 PM IST |
| Application | Online application / Easy Apply |
About Porch Group
Porch Group is a vertical software and insurance platform focused on helping homebuyers move, maintain and protect their homes.
The company also operates in the home-services SaaS sector and has relationships with thousands of businesses involved in the home-buying process.
Porch Group is currently recruiting for remote opportunities in India. Its India careers page highlights fully remote work, medical and accident insurance, provident fund, paid time off and other employee benefits.
Job Description
As a Data Warehouse Engineer at Porch Group, you will work as an individual contributor within the Data team. The position focuses on building, optimizing and maintaining data pipelines that support business intelligence and reporting.
You will work with complex data associated with SaaS and insurance operations and collaborate with architects, analysts, data scientists and other stakeholders.
The role places significant emphasis on SQL expertise, data warehouse architecture, pipeline performance and Google Cloud technologies.
Responsibilities
Build ETL and ELT Pipelines
Develop and monitor reliable data pipelines using:
Google BigQuery
Google Dataflow
Cloud Composer
Google Cloud Storage
Other Google Cloud services
Develop Advanced SQL
Create high-performance SQL scripts for complex data transformations and ensure data accuracy across multiple datasets.
The position requires strong SQL knowledge, including:
Window functions
Recursive CTEs
DDL
Complex transformations
Query optimization
Query plan analysis
Data Warehouse Modeling
Help design and refine data models supporting changing business requirements.
Experience with Star Schema and Snowflake Schema concepts is important for this role.
Performance Optimization
Identify and resolve data pipeline and database performance bottlenecks.
You will also be expected to optimize cloud workloads for both:
Query performance
Cloud cost efficiency
Cross-Functional Collaboration
Work with Data Analysts, Data Scientists and Actuaries to translate business requirements into technical specifications.
Examples of business metrics mentioned for the role include churn rates and claims ratios.
Code Quality and Documentation
Participate in peer code reviews and maintain technical documentation to ensure the long-term reliability and maintainability of the data warehouse.
Required Qualifications
Candidates should have:
3+ years of professional data engineering experience
Experience working with cloud-based data warehouses
Strong Google Cloud Platform experience
Hands-on experience with BigQuery
Knowledge of Google Cloud Storage
Understanding of GCP IAM best practices
Expert-level SQL skills
Knowledge of data warehousing principles
Experience with partitioning and clustering
Understanding of data warehouse lifecycle management
Strong attention to data quality and integrity
Excellent written and spoken English communication
Experience working with US-based business teams
Ability to collaborate effectively with cross-functional teams
The combination of BigQuery, Dataflow, Cloud Composer and advanced SQL is particularly important for this position. A closely matching Porch Group senior data-engineering listing also identifies these technologies as core requirements.
Working Hours
This is an India-based remote position with a significant overlap with US business hours.
The listed schedule is:
8 hours per day, excluding breaks
Core US overlap:
7:30 PM – 11:30 PM IST
The remaining four hours are flexible within IST.
Candidates should also have a quiet dedicated workspace and reliable internet connectivity. The listing specifies a minimum internet speed of 50 Mbps.
Salary
The advertised annual salary range is:
₹15,75,000 – ₹22,05,000 per year
That is approximately:
₹1.31 lakh – ₹1.84 lakh per month before applicable deductions and taxes
₹15.75 lakh – ₹22.05 lakh per year
Actual compensation may vary based on experience, skills, job-related knowledge, location and other factors.
Benefits
Benefits mentioned in the job posting include:
Medical insurance
Accident insurance
Retiral benefits
12 company-paid holidays
2 flexible holidays
Privilege/earned leave
Casual/sick leave
Paid maternity leave
Paid paternity leave
Wellness programs
Weekly wellness events
Porch Group's India careers page also highlights its remote-first setup and employee benefits.
Who Should Apply?
This opportunity is particularly suitable for candidates who already have professional experience in:
Data Engineering + GCP + BigQuery + Advanced SQL + Data Warehousing
Candidates with experience building production ETL/ELT pipelines and optimizing BigQuery workloads should pay particular attention to this opening.
This is not an entry-level data engineering position. The company is looking for candidates with at least three years of professional data-engineering experience.
Before applying, make sure your resume clearly highlights relevant experience with:
BigQuery
GCP
Dataflow
Cloud Composer / Airflow
SQL
ETL / ELT
Data Warehousing
Star Schema / Snowflake Schema
Partitioning
Clustering
Query optimization
Cloud Storage
IAM
Porch Group's official careers site provides access to its current India opportunities.
Important: Tailor your resume to the actual requirements of the position rather than simply adding keywords you do not have experience with.
Final Takeaway
The Porch Group Data Warehouse Engineer opening is a strong opportunity for experienced GCP Data Engineers and Data Warehouse Engineers in India who want a remote position with US-team exposure.
The biggest resume-matching areas are advanced SQL, BigQuery, GCP, ETL/ELT pipelines, Cloud Composer, Dataflow, data modeling and performance optimization.
Candidates should make these skills highly visible in their resumes if they genuinely possess them.
APPLY HERE:Data Engineer