Data Engineer 2 – Guidewire

Jobtailor; Edison (NJ); On-site; USD 120,000 - 150,000; Full time

Job summary

Jobtailor is seeking a senior data engineer in New Jersey to design and optimize data solutions for Guidewire domains, including Policy Center and Billing Center. You will build robust ELT pipelines to ingest, transform, and load data into a Delta Lakehouse platform and mentor colleagues in data engineering best practices.

You will also design data models, dashboards, and governance standards while supporting Generative AI data tasks with structured and unstructured data processing and embedding

Qualifications

• Bachelor’s degree in a computer science, data science, analytics, or related field.
• 5+ years in IT or related field.
• 3+ years in data engineering and analytics with enterprise data models.
• 2+ years with Guidewire data structures and Guidewire ecosystem.
• 2+ years with Azure Databricks and Azure Data Factory.
• 2+ years in Power BI or equivalent tools.
• Expertise in Spark, Delta Lakehouse, and data warehousing.
• Proficiency in Azure services (SQL DB, Data Lake Gen2, Event Grid, Key Vault).
• Strong CI/CD and Agile experience.
• Knowledge of data governance, security, and metadata management.

Responsibilities

• Analyze requirements and design data solutions for Guidewire domains.
• Develop and optimize ELT pipelines for Delta Lakehouse.
• Build and maintain data models and schemas for quality data.
• Create dashboards and reports delivering actionable insights.
• Monitor pipelines and troubleshoot data issues promptly.
• Collaborate with analysts and business users to deliver end-to-end data solutions.
• Implement governance, security, and compliance standards.
• Conduct root-cause analysis and continuous improvements in pipelines.
• Prepare testing procedures to ensure pipeline reliability.
• Stay current with new technologies and suggest improvements.
• Mentor team members on data engineering best practices.
• Develop data pipelines for structured and unstructured data for Generative AI tasks.
• Prepare large datasets for training Generative AI models.
• Collab with AI teams to support model training and inference.
• Enrich data with metadata to improve model accuracy.
• Optimize storage and retrieval for fast AI-ready access.
• Monitor GenAI data workflows and troubleshoot issues.

Skills

ETL pipelines

Data modeling

SQL databases

Azure Databricks

Azure Data Factory

Apache Spark

Delta Lakehouse

Power BI

Data governance

CI/CD & Agile

Generative AI knowledge

Data security & privacy

Mentoring

Education

Bachelor’s degree in relevant field

Tools

Guidewire Policy Center

Oracle

Job description

Responsibilities

• Analyze integration and system requirements by understanding business needs and designing effective data solutions, particularly for Guidewire Policy, Billing Center and Commercial P&C data domains.
• Design, develop, and optimize ELT pipelines to ingest, transform, and load data into a Delta Lakehouse platform.
• Design, develop and maintain data models and schemas ensuring data quality and integrity.
• Build and maintain dashboards and reports delivering actionable business insights.
• Monitor pipeline and storage performance; troubleshoot and resolve data issues promptly.
• Collaborate with cross-functional teams, including analysts and business users, to deliver end-to-end insurance data solutions.
• Implement data governance, security, and compliance standards across platforms.
• Conduct root cause analysis for system failures and performance events; drive continuous improvements in enterprise data integration pipelines.
• Create and manage testing procedures (unit, scenario, end-to-end) to ensure pipeline reliability.
• Stay current with emerging technologies and recommend improvements to workflows.
• Mentor team members on data engineering tools, Guidewire data model concepts and best practices.
• Build and maintain data pipelines to process structured and unstructured data (like documents and text) for Generative AI tasks, including creating embeddings and working with vector databases to support AI search features.
• Prepare and clean large datasets to ensure high-quality inputs for training and fine-tuning Generative AI models.
• Collaborate with AI and data science teams to understand data requirements and deliver scalable solutions that support model training and inference.
• Implement processes to enrich data with metadata and context to improve AI model accuracy and relevance.
• Optimize data storage and retrieval methods to support fast, low-latency responses for AI-powered applications.
• Monitor data workflows for Generative AI projects, troubleshooting issues, and ensure continuous pipeline performance.

Requirements

• Bachelor’s degree in relevant field of study required (e.g. computer science, data science, data analytics, applied mathematics, etc.)
• 5+ years of progressive work experience in IT or a related field required.
• 3+ years of experience in data engineering and analytics, with a solid foundation in data architecture and integration, including hands‑on work with complex enterprise P&C Insurance data models required.
• 2+ years of experience with data‑centric projects within the Guidewire ecosystem, including working with Guidewire Policy Center and related data structures required.
• In-depth understanding of relational database systems (e.g., Oracle, SQL Server, MySQL), including their features and performance optimization strategies.
• Solid grasp of ETL processes, data pipeline architectures, and data integration techniques, particularly for operational source systems such as Guidewire.
• 2+ years of hands‑on experience with Azure Databricks, Azure data factory including developing and optimizing data pipelines using Apache Spark required.
• 2+ years of experience working with Power BI or other leading data visualization and reporting tools required.
• Proven expertise with Apache Spark, Delta Lakehouse, and data warehousing technologies required.
• Proficient in Microsoft Azure services, including: Azure SQL Database, Azure Data Lake Storage Gen2, Azure Event Grid, Azure Key Vault.
• Strong understanding of CI/CD pipelines and experience in Agile development environments.
• Demonstrated ability to troubleshoot system issues, identify root causes, and implement effective solutions quickly.
• Capable of managing multiple priorities with strong attention to detail and follow-through.
• Working knowledge of Generative AI frameworks and use cases in data engineering is a plus.
• Knowledge of data governance, metadata management, and data quality frameworks.
• Understanding of data security and privacy principles, including encryption, anonymization, and access control mechanisms.
• Proficient in Microsoft Office Suites.