Guidewire Data Conversion Lead

Job Overview
We are seeking a dynamic and highly skilled Guidewire Data Conversion Lead to spearhead complex data migration initiatives within Guidewire insurance platforms. This role offers an exciting opportunity to lead end-to-end data conversion projects, ensuring seamless integration and transformation of legacy data into Guidewire systems. As a pivotal member of our team, you will drive innovative solutions, coordinate cross-functional efforts, and uphold best practices in data management. Your expertise will empower us to deliver robust, accurate, and efficient data conversions that support our clients’ digital transformation journeys.

Responsibilities

• Lead the planning, design, and execution of Guidewire data conversion strategies, ensuring alignment with project goals and timelines.
• Collaborate with business analysts, system architects, and technical teams to define data requirements and mapping specifications for Guidewire modules such as Claims, Policy, and Billing.
• Develop and implement scalable ETL (Extract, Transform, Load) processes utilizing tools like Informatica, Talend, or custom scripting in Python, Bash (Unix shell), or Shell Scripting to facilitate efficient data migration.
• Manage large-scale data sets using Big Data technologies such as Hadoop, Apache Hive, Spark, and Azure Data Lake to optimize performance and ensure data integrity during conversion.
• Design and maintain robust database schemas in Microsoft SQL Server, Oracle, or other relational databases to support accurate data storage and retrieval.
• Utilize cloud platforms like AWS and Azure to deploy scalable solutions for data processing and storage needs.
• Implement RESTful APIs for seamless integration between Guidewire systems and external applications or data sources.
• Conduct thorough analysis of source data quality, identify discrepancies or inconsistencies, and develop remediation plans.
• Oversee model training and validation processes for linked data applications to enhance data accuracy and predictive capabilities.
• Ensure adherence to Agile methodologies by participating in sprint planning, daily stand-ups, retrospectives, and continuous improvement initiatives.
• Document all conversion processes meticulously; prepare comprehensive testing plans including unit testing, system testing, and user acceptance testing (UAT).
• Provide technical leadership during cutover activities; troubleshoot issues promptly; coordinate with stakeholders for issue resolution.
• Promote best practices in database design, analytics implementation, and overall data governance throughout the project lifecycle.

Requirements

• Proven experience leading Guidewire data conversion projects within insurance or financial services environments.
• Strong proficiency in SQL programming with Microsoft SQL Server, Oracle databases; experience with database design is essential.
• Hands-on expertise with ETL tools such as Informatica or Talend; scripting skills in Python, Bash (Unix shell), or Shell Scripting are highly desirable.
• Deep understanding of Big Data ecosystems including Hadoop, Apache Hive, Spark; experience with cloud-based platforms like AWS (Amazon Web Services) and Azure Data Lake is preferred.
• Familiarity with Guidewire modules—Claims Center, PolicyCenter, BillingCenter—and their data structures.
• Knowledge of RESTful API development for system integration purposes.
• Experience working with Looker or similar analytics tools for reporting insights derived from converted data sets.
• Strong analysis skills to evaluate source systems’ data quality; ability to design effective database schemas for complex datasets.
• Exposure to Model training techniques involving linked data for predictive analytics applications.
• Ability to work effectively within Agile teams; excellent communication skills; proactive problem-solving mindset.
• Knowledge of additional tools such as VBA for automation tasks; familiarity with Shell Scripting enhances versatility. Join us as a Guidewire Data Conversion Lead if you’re passionate about transforming raw data into actionable insights! Bring your expertise in cutting-edge technologies like AWS, Hadoop, Spark, and modern ETL frameworks—help shape the future of insurance technology through innovative data solutions that make a real impact!

Job Type: Contract

Pay: $50.35 - $60.64 per hour

Work Location: In person