Vimerse InfoTech Inc is hiring: Data Analyst with Guidewire in Dallas

Data Analyst with Guidewire Expereince LOCATION- Boston, MA; Charlotte, NC; Colorado Springs, CO; Conshohocken, PA; Dallas, TX; Fargo, ND; Florham Park, NJ; Garden City, NY; Houston, TX; Jacksonville, IL; Lenexa, KS; Los Angeles, CA; Lubbock, TX; Mt Juliet, TN; New York, NY; Purchase, NY; Topeka, KS Hybrid- 3 Days on-site ROLE SUMMARY 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. ROLE RESPONSIBILITIES • 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. EDUCATION REQUIREMENTS • B.S. Degree in Computer Information Science, Information Management, or Statistics.