This job listing has expired and the position may no longer be open for hire.

ETL Systems Analyst with P&C at Kforce Inc

Posted in Other 30+ days ago.

Location: Morristown, New Jersey





Job Description:


RESPONSIBILITIES:

Kforce's direct client is in need of an ETL Systems Analyst who has expertise working in the Property & Casualty Insurance industry with Guidewire systems. This is a long-term contract opportunity, and the candidate must be willing to work on-site 3 days a week in Morristown, NJ or any other of the client specific locations.

Summary:
The Guidewire 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 the Client create an industry-leading data warehouse architecture. Furthermore, this data warehouse architecture will measure performance in all aspects of the organization's operations.

Responsibilities:


  • ETL Systems Analyst will 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

  • As an ETL Systems Analyst, you will perform data validation, to ensure 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







REQUIREMENTS:



  • B.S. degree in Computer Information Science, Information Management, or Statistics

  • Possess 5+ years of Policy & Claims Insurance subject-matter expertise; Property & Casualty insurance industry experience is required

  • Proven 5+ years of experience of data analysis - extraction of OLTP data within an enterprise data warehouse

  • Advanced level SQL knowledge. SQL Server, Oracle, Teradata, Excel

  • Possess optimal knowledge for concepts and frameworks for Data Warehousing, ETL, and BI Architectures

  • Capable of creating and tuning Semantic layer Reporting Views, SQL Server, Oracle, Teradata, Excel, DMD Data Mapping Documents, and Modeling

  • 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, DB2SQL Server, Oracle, Teradata, Excel), 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






The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future.



We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.



Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless
and until paid and may be modified in its discretion consistent with the law.



This job is not eligible for bonuses, incentives or commissions.



Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.



By clicking "Apply Today" you agree to receive calls, AI-generated calls, text messages or emails from Kforce and its affiliates, and service providers. Note that if you choose to communicate with Kforce via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.





More jobs in Morristown, New Jersey


Zelis NA

Zelis NA

Kroll, LLC
More jobs in Other


Xanitos Inc

Northwest Exterminating Co LLC

Markel