Senior Data Warehouse Engineer

PORCH INDIA PRIVATE LIMITED; United States; Remote; USD 13,000 - 22,000; Full time

Benefits offered by this job

Remote work

Job summary

PORCH INDIA PRIVATE LIMITED is seeking a data engineer to build and maintain data pipelines and data warehouse models that support BI and reporting for software and insurance operations.

You will focus on reliable data, complex SQL transformations, scalable design, and warehouse performance while collaborating with data specialists and technical architects. Remote in India, core BI objectives and cost efficiency are key metrics.

Qualifications

• Strong SQL skills with complex transformations and performance tuning.
• Experience building and operating data warehouse pipelines.
• Ability to design dimensional models for reporting and analytics.
• Investigating data quality and pipeline performance issues.
• Clear communication across technical and business teams.

Responsibilities

• Build and monitor ETL/ELT pipelines with BigQuery, Dataflow, and Cloud Composer.
• Write SQL transformations that reconcile data across datasets.
• Design star and snowflake schemas for reporting needs.
• Identify and fix bottlenecks to improve query speed and cloud cost efficiency.
• Collaborate with analysts and stakeholders to translate metrics into technical requirements.
• Review code and maintain warehouse documentation.

Skills

SQL skills

Data pipelines

Data modeling

Data quality

Cross-functional collaboration

Tools

BigQuery

Dataflow

Cloud Composer

Job description

Role overview

Build and maintain the data pipelines and warehouse models that support business intelligence and reporting across software and insurance operations. This is an individual contributor role focused on reliable data, complex SQL transformations, scalable design, and warehouse performance, working with data specialists and technical architects.

Responsibilities

• Build and monitor ETL/ELT pipelines with BigQuery, Dataflow, and Cloud Composer.
• Write SQL transformations that reconcile data accurately across multiple datasets.
• Design and refine star and snowflake models as business reporting needs evolve.
• Find and resolve pipeline bottlenecks, improving query speed and cloud cost efficiency.
• Work with analysts and business stakeholders to translate measures such as churn and claims ratios into technical requirements.
• Review code and maintain documentation to support the warehouse over time.

Requirements

• Strong SQL skills, including complex transformations and performance tuning.
• Experience building and operating data warehouse pipelines.
• Ability to design dimensional data models for reporting and analytics.
• Skill in investigating data quality and pipeline performance issues.
• Clear communication and collaboration across technical and business teams.

Benefits and work setup

• Remote role based in India.