[Remote] Sr Data Engineer
Note: The job is a remote job and is open to candidates in USA. Quantiphi is an award-winning Applied AI and Big Data software and services company, driven by a deep desire to solve transformational problems at the heart of businesses. As a Senior Data Engineer, you will play a key role in designing, building, and maintaining scalable data pipelines that power analytics and business decision-making, working with both batch and streaming architectures.ResponsibilitiesDefine and own the overall data architecture for ingestion, storage, transformation, and analytics on GCP (focused on BigQuery and Cloud Composer)Design data modeling frameworks and best practices for structured and semi-structured insurance data (Policy, Claims, Billing)Collaborate with Business Analysts to translate functional Guidewire requirements into conceptual and logical data modelsWork with Data Modelers and Data Engineers to define physical schemas, transformation strategies, and data lineage standardsDesign and oversee data ingestion architecture from Guidewire (staging, raw, curated layers) using SQL-based ELT pipelinesEstablish data governance, metadata management, and data quality frameworks for transparency and complianceReview and optimize BigQuery data structures (partitioning, clustering, query tuning, storage tiering)Define naming conventions, security models (IAM/RLS), and access control standards for the data warehouseEnsure architecture alignment with cloud best practices for scalability, cost optimization, and maintainabilityProvide architectural direction and mentorship to the Data Engineering Lead, Data Modeler, and Data EngineersPartner with enterprise security and infrastructure teams to maintain compliance with data privacy regulationsSkills10+ years of experience in data architecture/design with at least 6+ years on GCPDeep expertise in Google BigQuery data warehouse design and performance tuningStrong working knowledge of Cloud Composer (Airflow) and orchestration pipelinesSolid understanding of insurance data structures, preferably from Guidewire systems (PolicyCenter, BillingCenter, ClaimsCenter)Experience architecting enterprise-grade ELT frameworks and multi-layered data architectures (staging β raw β curated β analytics)Hands-on proficiency in SQL and schema design for analytical environments (star/snowflake models)Familiarity with data governance, cataloging, and metadata managementAbility to lead technical teams and guide design decisions with both functional and technical stakeholdersCompany OverviewQuantiphi is a digital engineering company that provides data science and machine learning software and services. It was founded in 2013, and is headquartered in Marlborough, Massachusetts, USA, with a workforce of 1001-5000 employees. Its website is http://www.quantiphi.com.Company H1B SponsorshipQuantiphi has a track record of offering H1B sponsorships, with 2 in 2026, 45 in 2025, 65 in 2024, 45 in 2023, 94 in 2022, 71 in 2021, 46 in 2020. Please note that this does not guarantee sponsorship for this specific role.