Data Engineer

PORCH INDIA PRIVATE LIMITED; India; Remote; INR 1,575,000 - 2,205,000; Full time

Benefits offered by this job

Medical insurance

Accident insurance

Retiral benefits

Paid holidays

Parental leave

Job summary

Porch Group in India is seeking a Data Warehouse Engineer to join our data team as a strong individual contributor. You will build, optimize, and maintain data pipelines powering our business intelligence and reporting.

You will work closely with lead architects to implement scalable solutions and serve as a subject matter expert in SQL and database performance. You will bring 3+ years of data engineering experience in cloud-based warehouses and strong Google Cloud skills (BigQuery, Cloud

Qualifications

• 3+ years of professional data engineering experience in cloud data warehouses.
• Strong Google Cloud ecosystem experience (BigQuery, Cloud Storage, IAM).
• Expert SQL skills including window functions and recursive CTEs.
• Experience with data modeling, partitioning, and performance tuning.
• Clear communication and collaboration with analysts and engineers.

Responsibilities

• Build and monitor ETL/ELT pipelines using BigQuery, Dataflow, and Cloud Composer.
• Develop high-performance SQL scripts for complex data transformations.
• Contribute to data models (Star/Snowflake) to support BI and reporting.
• Identify bottlenecks and optimize pipelines for speed and cost.
• Collaborate with analysts, data scientists, and actuaries to translate business logic into technical specs.
• Maintain documentation and participate in code reviews.

Skills

ETL/ELT pipelines

SQL proficiency

Data modeling (Star/Snowflake)

Partitioning & clustering

Cloud data warehouses

Cross-functional collaboration

English communication

US team collaboration

Tools

BigQuery

Cloud Storage

IAM

Dataflow

Cloud Composer

Job description

Job Title: Data Warehouse Engineer - Location: India - Workplace Type: Remote

Porch Group is a leading vertical software and insurance platform and is positioned to be the best partner to help homebuyers move, maintain, and fully protect their homes.
We offer differentiated products and services, with homeowners insurance at the center of this relationship.
We differentiate and look to win in the massive and growing homeowners insurance opportunity by 1) providing the best services for homebuyers 2) led by advantaged underwriting in insurance 3) to protect the whole home.
As a leader in the home services software-as-a-service (SaaS) space, we’ve built deep relationships with approximately 30 thousand companies that are key to the home-buying transaction, such as home inspectors, mortgage companies, and title companies.
In 2020, Porch Group rang the Nasdaq bell and began trading under the ticker symbol PRCH.
We are looking to build a truly great company and are JUST GETTING STARTED.

Job Summary

The future is bright for the Porch Group, and we'd love for you to be a part of it as our Data Warehouse Engineer with the Data team. We are seeking a Data Warehouse Engineer to join our data team as a strong individual contributor. In this role, you will be responsible for building, optimizing, and maintaining the data pipelines that power our business intelligence and reporting. You aren't just writing code; you're ensuring our data reflects the complex realities of our SaaS and insurance operations. You will work closely with lead architects to implement scalable solutions and serve as a subject matter expert in SQL and database performance.

What You Will Do

• Pipeline Development: Build and monitor robust ETL/ELT pipelines using BigQuery, Dataflow, and Cloud Composer.
• Expert SQL Execution: Develop high-performance SQL scripts for complex data transformations, ensuring accuracy across multiple datasets.
• Schema Management: Contribute to the design and refinement of data models (Star/Snowflake) to support evolving business requirements in the insurance and SaaS space.
• Performance Tuning: Proactively identify and resolve bottlenecks in data pipelines, optimizing for both query speed and cloud cost-efficiency.
• Cross-Functional Collaboration: Partner with Data Analysts, Data Scientists, and Actuaries to translate business logic—such as churn rates or claims ratios—into technical specifications.
• Code Quality: Participate in peer code reviews and maintain documentation to ensure the long-term health of our data warehouse.

What You Will Bring

• 3+ years of professional data engineering experience, specifically within cloud-based data warehouses.
• Solid experience with the Google Cloud ecosystem, including BigQuery, Cloud Storage, and IAM best practices.
• Expert-level SQL proficiency, including comfort with window functions, recursive CTEs, query plan analysis, and writing DDL.
• Strong grasp of partitioning, clustering, and data warehousing lifecycle management.
• Detail-oriented, taking pride in data integrity and "clean" code.
• Collaborative, enjoys working as part of a high-functioning team and is comfortable contributing to shared goals.
• Adaptable, able to pivot between building new features and troubleshooting legacy pipelines as business needs change.
• Excellent written and communication skills in English language.
• Proven experience working with US based business teams.

Working Hours

8 Hours (Excluding breaks)
4 Core US Hours Overlap (7:30pm-11:30pm IST)
4 flexible hours (IST)
Workspace: A quiet, dedicated space to work, and a reliable internet connection with a minimum speed of 50 Mbps.

What You Will Get

• Pay Range*: ₹1,575,000 - ₹2,205,000 INR Annually *Please know your actual pay at Porch will reflect a number of factors among which are your work experience and skillsets, job related knowledge, alignment with market and our Porch employees, as well as your geographic location.
• Benefits include medical insurance, accident insurance and retiral benefits.
• Wellness programs include 12 company-paid holidays, 2 flexible holidays, privilege/earned leave, casual/sick leave, paid maternity and paternity leaves, and weekly wellness events.

Company Culture & Equality

Porch is committed to building an inclusive culture of belonging that not only embraces the diversity of our people but also reflects the diversity of the communities in which we work and the customers we serve. We know that the happiest and highest performing teams include people with diverse perspectives that encourage new ways of solving problems, so we strive to attract and develop talent from all backgrounds and create workplaces where everyone feels seen, heard and empowered to bring their full, authentic selves to work.

Porch is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex including sexual orientation and gender identity, national origin, disability, protected veteran status, or any other characteristic protected by applicable laws, regulations, and ordinances.

Our Values

• No Jerks / No Egos
• Be Ambitious
• Solve Each Problem
• Care Deeply
• Together We Win

Company Snapshot

We are a leading vertical software and insurance platform and are positioned to be the best partner to help homebuyers move, maintain, and fully protect their homes. Porch differentiates and looks to win in the massive and growing homeowners insurance opportunity by: 1) Providing the best services for homebuyers 2) Being led by advantaged underwriting in insurance 3) Protecting your whole home.

Our values guide us in everything we do, from individual everyday tasks to high-level strategic planning: No Jerks / No Egos Be Ambitious Solve Each Problem Care Deeply Together We Win.

In 2020, Porch Group rang the Nasdaq bell and began trading under the ticker symbol PRCH. We are looking to build a truly great company and are JUST GETTING STARTED.

Today, we are a truly global team hiring for positions (many fully remote) across the United States, Mexico, and India.