Job Details

Job Description

• Designs, develops and maintains data pipelines within the Guidewire insurance platform, specifically utilizing the Guidewire DataHub/InfoCenter data visualization tools, to Extract, Transform, and Load (ETL) data for analysis and reporting purposes
• Monitors and troubleshoots issues related to Guidewire DataHub/InfoCenter, and optimizes performance for data loading and extraction processes
• Designs and develops complex data pipelines, ETL (Extract, Transform, Load) processes and decision support systems' data procedures
• Implements data solutions to make high-quality data available for analytics and reporting
• Collaborates with data analysts, architects, engineers and business stakeholders to understand data requirements
• Ensures data quality and consistency by implementing data cleansing and validation processes, identifying and resolving data issues, and creating data reconciliations
• Optimizes data workflows and processing for performance, scalability, and reliability
• Monitors data pipelines and proactively addresses issues to minimize downtime and disruptions
• Works with stakeholders to provide assistance for data-related technical issues
• Documents data engineering processes, data lineage, and data dictionaries
• Stays current with data engineering technologies, best practices, and industry trends
• Creates, maintains and updates various knowledge articles such as Standard Operating Procedures, Knowledge Base Articles, FAQ, Design and Configuration documents

• Must be proficient in Guidewire DataHub/InfoCenter 9.x and10.x , including data mapping, data quality rules, and data transformation logic
• Strong knowledge of Guidewire PolicyCenter/BillingCenter/ClaimCenter data models required
• Bachelor's degree in Computer Science, Information Technology, or a related field
• 3+ years of experience in data engineering and management
• Strong knowledge of SQL and SQL programming. SQL Server-specific knowledge preferred
• Extensive hands-on experience on SAP BODS ETL tools with design and aministration required
• Strong knowledge of Guidewire PolicyCenter/BillingCenter/ClaimCenter data models required
• Strong SQL skills to query and manipulate data within the Guidewire environment
• Knowledge of Informatica and Snowflake and P&C Insurance preferred
• Proficiency in data processes and knowledge of data models
• Strong knowledge of data engineering technologies and tools, including data lakes, data warehouses, and cloud-based solutions
• Knowledge of Microsoft Office products (Excel, Word, Visio, PowerPoint)
• Knowledge of techniques for recognizing, anticipating, and resolving organizational, operational, or process problems, ability to apply this knowledge appropriately to diverse situations