Remote Data Engineer: ETL, Warehousing & BI

PORCH INDIA PRIVATE LIMITED; United States; Remote; USD 16,000 - 27,000; Full time

Job summary

PORCH INDIA PRIVATE LIMITED is seeking a data-focused BI engineer to create and maintain the data foundations behind business intelligence and reporting for software and insurance operations. You will build reliable ETL/ELT pipelines, ensure accurate transformations, and optimize warehouse performance in close collaboration with data, analytics, science and actuarial teams.

The role is remote and based in India.

Qualifications

• Strong SQL skills for complex transformations and efficient queries.
• Experience building, optimizing, and maintaining data pipelines.
• Knowledge of warehouse modeling approaches such as star and snowflake schemas.
• Ability to analyze data quality and performance problems methodically.
• Collaboration skills for translating business logic into technical work.

Responsibilities

• Build and monitor data pipelines with BigQuery, Dataflow, and Cloud Composer.
• Develop complex SQL transformations and ensure consistency across source datasets.
• Help shape star and snowflake models for evolving reporting requirements.
• Identify and address pipeline bottlenecks to improve speed and cloud cost efficiency.
• Work with analysts, data scientists, and actuaries to encode business concepts such as churn and claims ratios.
• Support code quality and documentation for maintainable data systems.

Skills

SQL

Data pipelines

Data modeling

Data quality

Collaboration

Tools

BigQuery

Dataflow

Cloud Composer

Job description

PORCH INDIA PRIVATE LIMITED is seeking a data-focused BI engineer to create and maintain the data foundations behind business intelligence and reporting for software and insurance operations. You will build reliable ETL/ELT pipelines, ensure accurate transformations, and optimize warehouse performance in close collaboration with data, analytics, science and actuarial teams.

The role is remote and based in India.