Senior Data Warehouse Engineer

New
P
Porch GroupData warehousing
Location: India; Workplace Type: Remote, 4 Core US Hours Overlap (7:30pm- 11:30pm IST); 4 flexible hours (IST); Eastern Standard Time (EST) overlapFull-TimeSenior
Salary2,475,000 - 3,465,000 INR per year
Apply NowOpens the employer's application page

Job Details

Languages
Excellent written and communication skills in the English language.
Experience
5+ years of professional data engineering experience, specifically within cloud-based data warehouses.
Required Skills
SQLGCPData modelingBigQuery

Requirements

  • Bring 5+ years of professional data engineering experience, specifically with cloud-based data warehouses.
  • Have experience with the Google Cloud ecosystem, including BigQuery, Cloud Storage, and IAM best practices.
  • Demonstrate expert-level SQL proficiency, including window functions, recursive CTEs, and query plan analysis.
  • Understand indexing, partitioning, clustering, and data warehousing lifecycle management.
  • Have excellent written and communication skills in English.
  • Have proven experience working with US-based business teams.
  • Be able to work with four core US hours overlapping 7:30pm–11:30pm IST, plus four flexible hours in IST.
  • Have a quiet, dedicated workspace and reliable internet connection with a minimum speed of 50 Mbps.

Responsibilities

  • Build and monitor ETL/ELT pipelines using BigQuery, Dataflow, and Cloud Composer.
  • Develop SQL scripts for complex data transformations across multiple datasets.
  • Contribute to Star and Snowflake data models for insurance and SaaS business requirements.
  • Identify and resolve data pipeline bottlenecks, optimizing query speed and cloud costs.
  • Partner with Data Analysts and stakeholders to translate business logic into technical specifications.
  • Participate in peer code reviews and maintain data warehouse documentation.
  • Perform other assigned data engineering duties and projects.
View Full Description & ApplyYou'll be redirected to the employer's site
2,475,000 - 3,465,000 INR per year
Apply Now