What are the responsibilities and job description for the Guidewire Data Analyst with Property & Casulaty Insurance (P&C) - Hybrid- Multiple Locations position at TMS LLC?
Role: Guidewire Data Analyst with Property & Casulaty Insurance (P&C)
Duration: Long Term C2C
Location: Hybrid- 3 days Onsite (Sites- Charlotte, NC; Chicago, IL; Colorado Springs, CO; Conshohocken, PA; Dallas, TX; Fargo, ND; Garden City, NY; Houston, TX; Jacksonville, IL; Lenexa, KS; Los Angeles, CA; Lubbock, TX; Morristown, NJ; Mt Juliet, TN; New York, NY; Purchase, NY; Topeka, KS)
**Note: Must have experience in Guidewire and Property & Casulaty Insurance (P&C)
# Do not apply if you are a business analyst. Only Data Analysts needed.
- Looking for a Guidewire data analyst on the data warehouse side.
- Experience in Source to target mapping.
- Pushing data from Guidewire to DWH.
- Strong experience in SQL.
- SQL query, Stored procedure.
Responsibilities:
• Collaborate with business stakeholders and IT teams to define and document data architecture and modeling needs.
• Architect and design comprehensive solutions for the enterprise data warehouse. Sourcing data from multiple Insurance and Reinsurance Policy, Treaty, Claim and financial systems.
• Design and implement Source to Target mappings optimized for high-volume data integration.
• Create logical and physical data models and implement them on SQL Server platforms.
• Work closely with the development team to ensure accurate translation of mappings into code.
• Develop strategies for data collection and ingestion and write SQL based solutions to validate data accuracy and integrity in the data warehouse.
• Analyze and design enterprise data models for optimal reporting. Support reporting teams in understanding and utilizing the data warehouse model effectively.
• Participate in release planning and validate changes post-deployment.
• Develop SQL Server views for reporting and dashboard development.
• Troubleshoot and optimize SQL and Informatica mappings and stored procedures.
Technical Qualifications:
• 10 years of data architecture and design experience working with development team to extract data directly from source applications and loading to an enterprise data warehouse.
• 3 years of experience within the Insurance and reinsurance domain
• Advanced experience with extracting data from Insurance applications.
• Extensive knowledge of Data Warehousing, ETL and BI Architectures, concepts, and frameworks.
• Capable of creating and tuning Semantic layer Reporting Views.
• Capable of facilitating data discovery sessions involving business subject matter experts.
• Knowledge of RDBMS platforms (SQL Server, DB2, etc.) with experience in generating DDL.
General Qualifications:
• Possess knowledge of Guidewire Policy Center, Guidewire Claims Center,
Additional InformationAll your information will be kept confidential according to EEO guidelines.
