Contract - Hybrid Position.
Preferred Locations: Purchase, NY; Morristown, NJ
Acceptable Offices:
Charlotte, NC; Chicago, IL; Colorado Springs, CO; Dallas, TX; Fargo, ND; Garden City, NY; Houston, TX; Jacksonville, IL; Lenexa, KS; Lubbock, TX; Mt Juliet, TN; New York, NY; Topeka, KS
ROLE RESPONSIBILITIES
- Work with business stakeholders and IT teams to analyze and resolve data issues for the enterprise data warehouse.
- Create source-to-target 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 any identified variances – between the enterprise data warehouse and source system applications.
TECHNICAL QUALIFICATIONS
- Proven 8+ years’ experience of data analysis within an enterprise data warehouse.
- Possess 4 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