Data Engineer
Porch Group
IndiaremotePosted 1 month ago
Skill Required
Data-Warehouse-EngineeringData-EngineeringETL-DevelopmentCloud-Data-EngineeringBigQuery-DevelopmentData-EngineerData-Engineer-JobsData-Engineering-AnalystData-Engineering-SpecialistData-Engineering-JobsDataset-EngineerData-Engineering-PositionsAnalytics-EngineerData EngineerQuery OptimizationData Warehousingdata engineeringtroubleshootingGCPEngineeringSnowflakeBigQuerybuildingwrittendesignCloudDesign PatternsjQueryETLSQLIAMandFulltime
Key highlights
- Annual pay range: ₹1,575,000 – ₹2,205,000 INR.
- Required experience: 3+ years of professional cloud-based data warehouse engineering experience.
- Key benefit: Comprehensive health, life, and financial wellbeing coverage, plus 12 company-paid holidays and paid parental leave.
- Notable requirement: Expert-level SQL proficiency and solid experience with Google Cloud ecosystem tools (BigQuery, Cloud Storage, IAM).
- Work arrangement: Fully remote role based in India, with 4 daily core hours overlapping US time (7:30pm–11:30pm IST).
- Company milestone: Porch Group went public on Nasdaq in 2020, trading under ticker PRCH.
Role overview
Porch Group is a leading vertical software and insurance platform focused on helping homebuyers move, maintain, and fully protect their homes, with homeowners insurance at the center of its product and service offerings. The company operates a leading home services SaaS platform with deep relationships with approximately 30,000 key stakeholders in the home-buying transaction, including home inspectors, mortgage companies, and title companies, and went public on the Nasdaq in 2020 under the ticker PRCH. The company is hiring a remote Data Warehouse Engineer based in India to join its Data team as an individual contributor. In this role, the engineer will build, optimize, and maintain data pipelines that power business intelligence and reporting, ensure data reflects the complex realities of the company’s SaaS and insurance operations, work cross-functionally with data and insurance teams to translate business logic into technical specifications, and serve as a subject matter expert for SQL and database performance to support the business’s evolving needs.
Responsibilities
- Build, optimize, and maintain the data pipelines that power the company’s business intelligence and reporting.
- Ensure data reflects the complex realities of Porch’s SaaS and insurance operations, work closely with lead architects to implement scalable solutions, and serve as a subject matter expert in SQL and database performance.
- 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, Data Scientists, and Actuaries 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 our data warehouse.
Requirements
- 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.
- Access to a quiet, dedicated workspace and reliable internet connection with a minimum speed of 50 Mbps.
- Ability to work 8 hours per day (excluding breaks), with 4 core hours overlapping US time (7:30pm–11:30pm IST) and 4 flexible hours in IST.
Benefits
- Comprehensive health, life, and financial wellbeing coverage.
- Medical insurance, accident insurance, and retiral benefits.
- 12 company-paid holidays, 2 flexible holidays, privilege/earned leave, casual/sick leave, paid maternity and paternity leaves.
- Weekly wellness events.
Additional details
- Porch Group is a leading vertical software and insurance platform positioned to help homebuyers move, maintain, and fully protect their homes, with homeowners insurance at the center of this relationship.
- The company differentiates itself and aims to win in the massive and growing homeowners insurance opportunity via 1) providing the best services for homebuyers, 2) advantaged underwriting in insurance, and 3) protecting the whole home.
- As a leader in the home services software-as-a-service (SaaS) space, Porch has built deep relationships with approximately 30,000 companies that are key to the home-buying transaction, such as home inspectors, mortgage companies, and title companies.
- Porch Group rang the Nasdaq bell in 2020 and began trading under the ticker symbol PRCH; the company is focused on building a truly great organization and is in early stages of growth.
- The Data Warehouse Engineer role is a remote position based in India, joining the Data team as a strong individual contributor.
- Application process: Submit your application for review by the Talent Acquisition team; if your resume is selected, you will be invited to an initial chat to discuss your background, followed by potential virtual interviews. The company encourages applicants to come prepared with questions to ensure mutual fit.
- Porch is committed to building an inclusive culture of belonging that embraces the diversity of its people, the communities it operates in, and the customers it serves, with a focus on attracting diverse talent and creating workplaces where everyone feels seen, heard, and empowered to bring their full, authentic selves to work.
- Porch is an Equal Opportunity employer, and 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.
- The job was originally posted on Himalayas.
