Key skills
BigQuerySQLData WarehousingGCP ProficiencyETL/ELT PipelinesCollaborativeETLELTData EngineeringBusiness IntelligenceSnowflakeGoogle CloudIAMCloud StoragecomposerSaaSCommunication
About this role
Porch Group is a leading vertical software and insurance platform, seeking a Senior Data Engineer to join their data team. The role involves building, optimizing, and maintaining data pipelines for business intelligence and reporting, while ensuring data accuracy and performance in their SaaS and insurance operations.
Responsibilities:
- 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 our data warehouse
Requirements:
- 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 proficiency in SQL. Comfortable 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: You take pride in data integrity and 'clean' code
- Collaborative: You enjoy working as part of a high-functioning team and are comfortable contributing to shared goals
- Adaptability: You can pivot between building new features and troubleshooting legacy pipelines as business needs change
- Proven experience working with US based business teams
- Excellent written and communication skills in English language
- Must currently reside in or are located within 150 km of Greater Delhi NCR, Greater Bangalore, or Greater Pune
- Working Hours: 8 Hours (Excluding breaks)
- 4 Core US Hours Overlap (7:30pm- 11:30pm IST)
- 4 flexible hours (IST)
- Workspace: A quiet space to work, an internet connection of at least 30 Mbps download | 10 Mbps upload