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