Senior Data Engineer - Snowflake(Founding Member)

Overview

We are looking for a Senior Data Engineer who will play a foundational role in:

• Client onboarding from a data perspective
• Understanding complex insurance data flows
• Designing secure, scalable ingestion pipelines
• Establishing strong data modeling and governance standards
  
  

This role sits at the intersection of technology, data architecture, security, and business onboarding.

Key Responsibilities

• Lead end-to-end data onboarding for new clients and partners, working closely with business and product teams to understand client systems, data formats, and migration constraints
• Define and implement data ingestion strategies supporting multiple sources and formats, including CSV, XML, JSON files, and API-based integrations
• Design, build, and operate robust, scalable ETL/ELT pipelines, supporting both batch and near-real-time data processing
• Handle complex insurance-domain data including Contracts, Claims, Reserves, Cancellations, and Refunds
• Architect ingestion pipelines with security-by-design principles, including secure credential management (keys, secrets, tokens), encryption at rest and in transit, and network-level controls where required
• Enforce role-based and attribute-based access controls, ensuring strict data isolation, tenancy boundaries, and stakeholder-specific access rules
• Design, maintain, and evolve canonical data models that support operational workflows, reporting & analytics, and regulatory/audit requirements
• Define and enforce data governance standards, ensuring compliance with insurance and financial data regulations and consistent definitions of business metrics across stakeholders
• Build and operate data pipelines on a cloud-native platform, leveraging distributed processing frameworks (Spark / PySpark), data lakes, lakehouses, and warehouses
• Implement and manage orchestration, monitoring, alerting, and cost-optimization mechanisms across the data platform
• Contribute to long-term data strategy, platform architecture decisions, and cost-optimization initiatives while maintaining strict security and compliance standards
  
  

• Core Stack: Python, Advanced SQL(Complex joins, window functions, performance tuning), Pyspark
• Platforms: Azure, AWS, Data Bricks, Snowflake
• ETL / Orchestration: Airflow or similar frameworks
• Data Modeling: Star/Snowflake schema, dimensional modeling, OLAP/OLTP
• Visualization Exposure: Power BI
• Version Control & CI/CD: GitHub, Azure Devops, or equivalent
• Integrations: APIs, real-time data streaming, ML model integration exposure
  
  

• Bachelor’s or Master’s degree in Computer Science, Engineering, or related field
• 5+ years of experience in data engineering or similar roles
• Strong ability to align technical solutions with business objectives
• Excellent communication and stakeholder management skills
  
  

• Direct collaboration with the core US data leadership team
• High ownership and trust to manage the function end-to-end
• Exposure to a global environment with advanced tools and best practices