Sr Data Engineer

Job Summary

Job Title: Senior Data Warehouse Engineer

Location: India

Workplace Type: Remote

You will join our data team as a key individual contributor, responsible for building, optimizing, and maintaining the data pipelines that power our business intelligence and reporting.

You aren't just writing code; you're ensuring our data reflects the complex realities of our SaaS and insurance operations. You will work closely with lead architects to implement scalable solutions and serve as a subject matter expert in SQL and database performance.

What You Will Do As A Senior Data Warehouse Engineer

• Build and monitor robust ETL/ELT pipelines using BigQuery, Dataflow, and Cloud Composer.
• Develop high-performance SQL scripts for complex data transformations, ensuring accuracy across multiple datasets.
• Contribute to the design and refinement of data models (Star/Snowflake) to support evolving business requirements in the insurance and SaaS space.
• Proactively identify and resolve bottlenecks in data pipelines, optimizing for both query speed and cloud cost-efficiency.
• Partner with Data Analysts and stakeholders to translate business logic, such as churn rates or claims ratios, into technical specifications.
• Participate in peer code reviews and maintain documentation to ensure the long-term health of the data warehouse.
• Perform other data engineering related duties or projects, as assigned.

What You Will Bring As A Senior Data Warehouse Engineer

• 5+ years of professional data engineering experience, specifically within cloud-based data warehouses.
• Solid experience with the Google Cloud ecosystem, including BigQuery, Cloud Storage, and IAM best practices.
• Expert-level SQL proficiency, including comfort with window functions, recursive CTEs, and query plan analysis.
• Strong grasp of indexing, partitioning, clustering, and data warehousing lifecycle management.
• Familiarity with metrics common to SaaS (MRR, Churn) or Insurance (Premiums, Claims, Actuarial data) is highly valued.
• Detail-oriented, with pride in data integrity and clean code.
• Collaborative, enjoys working as part of a high-functioning team, and comfortable contributing to shared goals.
• Adaptable, able to pivot between building new features and troubleshooting legacy pipelines as business needs change.
• Candidates that have worked in IT/Data for a United States based publicly owned company preferred.
• Excellent written and communication skills in the English language.
• Proven experience working with US based business teams.
• Ability to work within core US business hours / time zone expectations - Eastern Standard Time (EST) overlap.
• Working Hours: 8 Hours (Excluding breaks); 4 Core US Hours Overlap (7:30pm-11:30pm IST); 4 flexible hours (IST).
• Workspace: A quiet, dedicated space to work, and a reliable internet connection with a minimum speed of 50 Mbps.

Disclaimer: This job posting and Location has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.