Senior Guidewire Data Analyst
Experience : 10+ Years
Notice Period : Immediate / 30 Days
Role Overview :
We are looking for an experienced Senior Guidewire Data Analyst with deep expertise in Guidewire data models and hands-on experience in data mapping, extraction, transformation, and loading within enterprise Data Warehousing environments.
The role acts as a key liaison between customers, Guidewire Business Analysts, and the Data Warehouse team, ensuring accurate, efficient, and timely translation of business requirements into data solutions.
The ideal candidate will have in-depth knowledge of PolicyCenter (PC), BillingCenter (BC), and ClaimCenter (CC) data structures, strong SQL skills, and the ability to work in cloud-based data engineering environments.
Key Responsibilities :
Guidewire Data Expertise :
- Utilize comprehensive knowledge of Guidewire data models (PC, BC, CC) to support data mapping, integration, and reporting.
- Translate business requirements into technical data specifications, including entity relationships, schema mapping, and semantic layer design.
- Assist in the design and validation of Guidewire-to-Data Warehouse ETL processes.
Data Warehousing & Integration :
Collaborate closely with Data Warehouse and BI teams to ensure seamless data flow, integration, and consistency.Validate data pipelines and transformations, ensuring accuracy, completeness, and adherence to performance standards.Provide technical input for ETL design, data lineage documentation, and semantic layer mapping.SQL Development & Data Analysis :
Write, optimize, and maintain complex SQL queries, views, and stored procedures to support extraction, transformation, and reporting needs.Analyze large datasets to identify patterns, anomalies, or gaps in data quality.Support data reconciliation and validation during migration from legacy systems to Xcenters.Customer & Stakeholder Engagement :
Interact with customers to gather and clarify data requirements, providing solutions aligned with business needs.Serve as a bridge between Guidewire BAs, Data Warehouse, and Xcenter teams, ensuring effective communication and understanding of requirements.Prepare and present technical reports, dashboards, and documentation for stakeholders.Technical & Problem-Solving Responsibilities :
Troubleshoot and resolve data-related issues, including discrepancies, missing data, or integration failures.Develop and maintain mapping documents, transformation rules, and semantic layer documentation.Participate in performance tuning, query optimization, and workflow improvement initiatives.Team Collaboration :
Work closely with cross-functional teams, including developers, BAs, QA, and infrastructure teams.Mentor junior analysts on Guidewire data models, SQL best practices, and data warehousing principles.Contribute to knowledge-sharing sessions and technical discussions across the organization.Technical Skills & Expertise :
Must-Have :
Deep expertise with Guidewire data models : PolicyCenter (PC), BillingCenter (BC), ClaimCenter (CC).Strong proficiency in SQL, including complex joins, subqueries, window functions, and query optimization.Hands-on experience with Data Warehousing concepts (ETL, OLAP, star / snowflake schemas, data lakes).Experience in data mapping, semantic layer design, and integration between operational and analytical systems.Ability to understand and troubleshoot data flows across Guidewire and Data Warehouse systems.Strong understanding of business processes in insurance domains (policy, claims, billing).Preferred / Advantageous Skills :
Experience with Xcenters, including migration from legacy Guidewire environments.Familiarity with cloud data platforms : Azure, AWS, or GCP.Experience with data engineering tools (Informatica, Talend, Databricks, or Snowflake).Knowledge of BI tools (Tableau, Power BI, or Looker) and semantic layer modeling.Experience in insurance domain analytics, compliance, and reporting standards.Soft Skills :
Excellent communication skills to articulate technical data requirements to non-technical stakeholders.Strong analytical and problem-solving abilities.Ability to prioritize tasks, work under pressure, and meet deadlines.Proven experience in mentoring and collaborating with cross-functional teams.Educational Qualification :
Bachelor's degree in Computer Science, Information Systems, or related field.Certifications in Guidewire, Data Warehousing, or Cloud platforms are a plus.(ref : hirist.tech)