Role: Guidewire Claim Center Data Analyst
Work Location: Remote
Job Description:
- We are seeking a Senior Data Warehouse Analyst to serve as a liaison between business units and the current IT Data Team to gain indepth understanding of data linked to each business process
- The role is key in understanding the business needs and aligning them with data teams strategy and architecture
- The focus of this position is to work closely with both the onshore and offshore data teams to ensure accurate and timely closing of the financial period and successful processing of Guidewire claims data
- This role will also be responsible for developing a strong relationship with the finance team who we partner with the on the load of financial information
- Facilitate process design by conducting business and systems process analysis; focusing on quality improvement and data management ensuring reliability and validity of data
- Collaborate closely with business teams to develop and implement technical requirements
Guide team thru process of creating SQL Queries that will make our data evaluation process more flexible or scalable across data sets - Research data issues in financial data warehouse and communicate the result of that research to stakeholders and key business leaders
- Lead the process of loading externally sourced data to our financial data warehouse for posting to the general ledger monthly
- Diving into large data sets uncovering insights and providing impactful recommendations
Identify develop and execute data control requirements Reconciliations and validations - Organize complex problems into simple solutions and precise business and technical requirements
Ensure Balance and controls are in place for each data movement point additionally responsible for reviewing those controls with the finance team to obtain sign off for posting to ledger
Required Skills:
- Guidewire Claim Center data modelling experience a must.
- Structured data analysis data mapping and data requirements development experience is required
- Proven Experience with documenting data architecture data flows and business process flows in insurance domain.
- Strong knowledge of Property & Casualty (P&C) concepts policies and processes
- Strong SQL and Excel skills with the ability to learn other analytics tools
- Snowflake experience is a plus