Rapid Consulting Services

Data Analyst with Guidewire and P&C Insurance

Job description

The Data Analyst is a hands-on position with a focus on defining the data needs for the enterprise data warehouse. The position will work within IT to help create an industry-leading data warehouse architecture. Furthermore, this data warehouse architecture will measure performance in all aspects of the organization's operations.


  • Work with business stakeholders and IT teams to analyze and resolve data issues for the enterprise data warehouse.
  • Create source (OLTP applications) to target (DWH) mapping documents to capture additional application data elements.
  • Load the source-to-target mapping documents from source systems into the enterprise data warehouse.
  • Collaborate with the ETL team to ensure the source-to-target mapping documents are in correct ETL code.
  • Ensure the ETL code align with STM requirements.
  • Perform data validation, to insure correct data movement into the enterprise data warehouse architecture.
  • Consult with reporting teams to develop a general understanding for the data warehouse model / optimal ways to use it.

Technical Qualifications

  • Proven 5+ years' experience of data analysis - extraction of OLTP data within an enterprise data warehouse.
  • Possess 5+ years of Policy & Claims Insurance subject-matter expertise.
  • Candidate has advanced level SQL knowledge.
  • Possess optimal knowledge for concepts and frameworks for Data Warehousing, ETL, and BI Architectures.
  • Candidate is capable of creating and tuning Semantic layer Reporting Views.
  • Able to facilitate data discovery sessions, which will include an audience of business subject-matter experts.
  • Proven knowledge of RDBMS platforms (e.g., SQL Server, DB2), with experience in generating DDL.
  • Possess knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-RI & SAP FS-CD applications with their data is considered a plus. General Qualifications
  • Candidate has strong interpersonal skills, including both written and verbal communication skills.
  • Possess the ability to work as part of a team.
  • Candidate has strong organizational skills and analysis skills.

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.

Similar jobs

Browse All Jobs
February 27, 2024
February 27, 2024

Tax Data Analyst