Remote job
Data Warehouse Engineer
Job details
About this role
Role overview
Develop and operate the data pipelines and warehouse structures that power reporting and business intelligence for software and insurance operations. As an individual contributor on the data team, you will work with technical architects and partner with analysts, data scientists, and actuaries to turn business rules into dependable, usable datasets.
Responsibilities - Build and monitor ETL/ELT workflows using BigQuery, Dataflow, and Cloud Composer. - Create performant SQL transformations and maintain accuracy across datasets. - Contribute to star and snowflake data models that support changing analytics needs. - Diagnose pipeline bottlenecks and improve query performance and cloud cost efficiency. - Translate measures such as churn and claims ratios into technical specifications with analytics and actuarial partners. - Participate in code quality practices and help maintain clear technical documentation.
Requirements - Strong SQL capability for complex data transformations and performance-focused querying. - Experience developing and maintaining warehouse pipelines. - Understanding of dimensional modeling, including star or snowflake schemas. - Ability to troubleshoot data issues and improve pipeline reliability. - Effective collaboration with technical and business stakeholders.
Benefits and work setup - Remote role based in India.