GUIDEWIRE DATAWAREHOUSE ARCHITECT
Apply NowCompany: Universal Insurance
Location: Sarasota, FL 34232
Description:
General Description:
The Guidewire Datawarehouse Architect position is responsible for working within the Information Technology group, participating in a team responsible for report generation and data analysis utilizing database management software/tools against various database platforms. In this role you will interface with the business to receive and evaluate requests for work, provide status, and answer reporting related questions. May also be asked to assist and lead in the development of automated reports, analytical and management reports, and data definitions across multiple computing environments. Will ensure deliverables meet the needs of both internal and external business customers.
Essential Duties and Responsibilities:
Guidewire Data Warehouse Management: Continue to support and enhance the Guidewire Enterprise Data Warehouse, ensuring data availability, accuracy, and efficiency in ETL operations.
Data Platform Implementation: Architect, design, and implement a scalable, on-prem or cloud-based enterprise data platform, integrating diverse data sources beyond Guidewire.
Data Integration & Engineering: Develop and oversee ETL/ELT pipelines to ingest, transform, and store data efficiently, leveraging modern tools.
Data Modeling & Architecture: Design and implement optimized data models for structured and unstructured data, supporting reporting, analytics, and AI/ML initiatives.
Data Governance & Security: Establish best practices for data governance, data quality, metadata management, and security compliance across all data assets.
Advanced Analytics Support: Enable self-service analytics, real-time data processing, and AI/ML-driven insights by integrating modern data technologies such as data lakes, streaming data, and NoSQL databases.
Collaboration & Leadership: Act as a strategic partner to IT, business units, and analytics teams, aligning data initiatives with organizational goals. Mentor junior team members and foster a culture of data-driven decision-making.
Monitor the task queue, take, and update tickets as directed by your supervisor.
Successfully engage in multiple initiatives simultaneously.
Contribute to the development of project plans and may assign and monitor tasks.
Assist in the development and generation of new reports to be provided to senior management across functional departments.
Perform other duties as required.
Supplemental Information:
This job description has been prepared to indicate the general nature and level of the work that the employees perform within their classification. This description is not and cannot be interpreted as an inventory of all the duties, tasks, responsibilities, and qualifications required for the employees assigned to this job.
Education and / or Experience:
Bachelor's or Master's degree in Computer Science, Information Systems, Data Science, or a related field.
5+ years of experience in data architecture, engineering, or related roles, preferably within the insurance industry.
Strong expertise in Guidewire InsuranceSuite (PolicyCenter, BillingCenter, ClaimCenter), Guidewire DataHub, and Guidewire InfoCenter.
Experience implementing cloud-based data platforms (AWS, Azure, or Google Cloud) and familiarity with data lakehouse architectures.
Proficiency in modern ETL/ELT tools (e.g., MS SSIS and Azure Data Factory) and database technologies (SQL, Databricks, etc.).
Hands-on experience with big data processing, streaming technologies (Kafka, Spark, Flink), and API-driven data integration.
Strong understanding of data security, compliance, and governance best practices (GDPR, CCPA, SOC2, etc.).
Familiarity with BI/reporting tools such as Power BI, Tableau, Looker, or SAP BusinessObjects.
Knowledge of machine learning frameworks and MLOps is a plus.
Familiarity with ticketing systems like Atlassian Jira used to assign and track work amongst multiple team members.
Must be resourceful, industrious, and willing to take on new tasks and proactively learn new technologies to keep up with business needs.
Must be able to work under tight deadlines efficiently and with high quality.
Must possess strong organizational skills with demonstrated attention to detail.
Must be flexible and able to adapt in a changing business environment.
Must possess a positive attitude and strong work ethic.
Excellent verbal and written communication skills and the ability to interact professionally with a diverse group (executives, managers, and subject matter experts).
Must be proficient in Microsoft Office (Excel, Word, Power Point).
Licenses and / or Certifications:
N/A
The Guidewire Datawarehouse Architect position is responsible for working within the Information Technology group, participating in a team responsible for report generation and data analysis utilizing database management software/tools against various database platforms. In this role you will interface with the business to receive and evaluate requests for work, provide status, and answer reporting related questions. May also be asked to assist and lead in the development of automated reports, analytical and management reports, and data definitions across multiple computing environments. Will ensure deliverables meet the needs of both internal and external business customers.
Essential Duties and Responsibilities:
Guidewire Data Warehouse Management: Continue to support and enhance the Guidewire Enterprise Data Warehouse, ensuring data availability, accuracy, and efficiency in ETL operations.
Data Platform Implementation: Architect, design, and implement a scalable, on-prem or cloud-based enterprise data platform, integrating diverse data sources beyond Guidewire.
Data Integration & Engineering: Develop and oversee ETL/ELT pipelines to ingest, transform, and store data efficiently, leveraging modern tools.
Data Modeling & Architecture: Design and implement optimized data models for structured and unstructured data, supporting reporting, analytics, and AI/ML initiatives.
Data Governance & Security: Establish best practices for data governance, data quality, metadata management, and security compliance across all data assets.
Advanced Analytics Support: Enable self-service analytics, real-time data processing, and AI/ML-driven insights by integrating modern data technologies such as data lakes, streaming data, and NoSQL databases.
Collaboration & Leadership: Act as a strategic partner to IT, business units, and analytics teams, aligning data initiatives with organizational goals. Mentor junior team members and foster a culture of data-driven decision-making.
Monitor the task queue, take, and update tickets as directed by your supervisor.
Successfully engage in multiple initiatives simultaneously.
Contribute to the development of project plans and may assign and monitor tasks.
Assist in the development and generation of new reports to be provided to senior management across functional departments.
Perform other duties as required.
Supplemental Information:
This job description has been prepared to indicate the general nature and level of the work that the employees perform within their classification. This description is not and cannot be interpreted as an inventory of all the duties, tasks, responsibilities, and qualifications required for the employees assigned to this job.
Education and / or Experience:
Bachelor's or Master's degree in Computer Science, Information Systems, Data Science, or a related field.
5+ years of experience in data architecture, engineering, or related roles, preferably within the insurance industry.
Strong expertise in Guidewire InsuranceSuite (PolicyCenter, BillingCenter, ClaimCenter), Guidewire DataHub, and Guidewire InfoCenter.
Experience implementing cloud-based data platforms (AWS, Azure, or Google Cloud) and familiarity with data lakehouse architectures.
Proficiency in modern ETL/ELT tools (e.g., MS SSIS and Azure Data Factory) and database technologies (SQL, Databricks, etc.).
Hands-on experience with big data processing, streaming technologies (Kafka, Spark, Flink), and API-driven data integration.
Strong understanding of data security, compliance, and governance best practices (GDPR, CCPA, SOC2, etc.).
Familiarity with BI/reporting tools such as Power BI, Tableau, Looker, or SAP BusinessObjects.
Knowledge of machine learning frameworks and MLOps is a plus.
Familiarity with ticketing systems like Atlassian Jira used to assign and track work amongst multiple team members.
Must be resourceful, industrious, and willing to take on new tasks and proactively learn new technologies to keep up with business needs.
Must be able to work under tight deadlines efficiently and with high quality.
Must possess strong organizational skills with demonstrated attention to detail.
Must be flexible and able to adapt in a changing business environment.
Must possess a positive attitude and strong work ethic.
Excellent verbal and written communication skills and the ability to interact professionally with a diverse group (executives, managers, and subject matter experts).
Must be proficient in Microsoft Office (Excel, Word, Power Point).
Licenses and / or Certifications:
N/A