[Hiring] Senior Data Warehouse Engineer @Porch Group

Role Description

The future is bright for the Porch Group, and we'd love for you to be a part of it as our Senior Data Warehouse Engineer with the Data team.

Porch Group is looking for a Senior Data Warehouse Engineer to join our data team as a key 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 As A Senior Data Warehouse Engineer

• Build and monitor robust ETL/ELT pipelines using BigQuery, Dataflow, and Cloud Composer.
• Develop high-performance SQL scripts for complex data transformations, ensuring accuracy across multiple datasets.
• Contribute to the design and refinement of data models (Star/Snowflake) to support evolving business requirements in the insurance and SaaS space.
• Proactively identify and resolve bottlenecks in data pipelines, optimizing for both query speed and cloud cost-efficiency.
• Partner with Data Analysts and stakeholders to translate business logic, such as churn rates or claims ratios, into technical specifications.
• Participate in peer code reviews and maintain documentation to ensure the long-term health of the data warehouse.
• Perform other data engineering related duties or projects, as assigned.

Qualifications

• 5+ 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, and query plan analysis.
• Strong grasp of indexing, partitioning, clustering, and data warehousing lifecycle management.
• Familiarity with metrics common to SaaS (MRR, Churn) or Insurance (Premiums, Claims, Actuarial data) is highly valued.
• Detail-oriented, with pride in data integrity and clean code.
• Collaborative, enjoys working as part of a high-functioning team, and comfortable contributing to shared goals.
• Adaptable, able to pivot between building new features and troubleshooting legacy pipelines as business needs change.
• Candidates that have worked in IT/Data for a United States based publicly owned company preferred.
• Excellent written and communication skills in the English language.
• Proven experience working with US based business teams.
• Ability to work within core US business hours / time zone expectations - Eastern Standard Time (EST) overlap.

Requirements

• 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.

Benefits

• Pay Range*: ₹24,75,000 – ₹34,65,000 INR Annually
• Comprehensive coverage for your health, life, and financial wellbeing.
• Medical insurance, accident insurance, and retiral benefits.
• Wellness programs including 12 company-paid holidays, 2 flexible holidays, privilege/earned leave, casual/sick leave, paid maternity and paternity leaves, and weekly wellness events.