Senior Cloud Data Warehouse Engineer - Remote (India)

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

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.