Data Engineer - Guidewire DataHub / InfoCenter

Job Description

Description

Marketing Statement:

Tokio Marine North America Services (TMNAS) provides professional support services to Tokio Marine Group companies in the United States, including Tokio Marine America, First Insurance Company of Hawaii, and Philadelphia Insurance Companies. Customer service is our focus and our passion! Tokio Marine North America Services adds value in all that we do, providing the best professional service to our business partners, allowing them to achieve their goals. Our talented team delivers actuarial, audit, corporate communications, financial and investment, human capital services, information technology, legal, and payroll expertise to our customers.

Job Summary:

This role supports data and analytics functions by designing, developing and maintaining data pipelines, integrations and decision support systems using data engineering tools and platforms.

The primary focus will be on technical support and development related to Guidewire DataHub/InfoCenter, with flexiblity to assist company customers located in Hawaii time zone and occasional weekend support.

Essential Job Functions:

• 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

Qualifications:

• 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
• Proficient in Guidewire DataHub/InfoCenter 9.x and10.x , including data mapping, data quality rules, and data transformation logic
• Extensive hands-on experience on SAP BODS ETL tools with design and aministration
• Strong knowledge of Guidewire PolicyCenter/BillingCenter/ClaimCenter data models
• 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

Salary range $79,000 to $130,000. Ultimate salary offered will be based on factors such as applicant experience and geographic location. Our company offers a competitive benefits package and bonus eligibility on top of base.

EEO Statement:

Tokio Marine Group of Companies (including, but not limited to the Philadelphia Insurance Companies, Tokio Marine America, Inc., TMNA Services, LLC, TM Claims Service, Inc. and First Insurance Company of Hawaii, Ltd.) is an Equal Opportunity Employer.  In

order to remain competitive we must attract, develop, motivate, and retain the most qualified employees regardless of age, color, race, religion, gender, disability, national or ethnic origin, family circumstances, life experiences, marital status, military status,  sexual orientation and/or any other status protected by law.