• Job Description

  Req#: JPC - 10177495

  I hope you are doing well,

  I am Sriram Chaganti Sr. Talent Acquisition from USG Inc. I have an immediate opening for the position of Data Analyst – Production Support. This is a Hybrid Opportunity with multiple locations. Please check the below JD and let me know if you are comfortable.

  Data Analyst (Production Support)

  P&C ( Property and casualty insurance ) Domain experience Mandatory (Resumes with no P&C domain will not be considered for this role)

  HYBRID WORK POLICY OF SOMPO- Monday and Friday are remote, Tue/Wed/Thurs are on-site.

  LOCATION(S) - 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

  ROLE SUMMARY

  P&C ( Property and casualty insurance ) Domain experience Mandatory

  The Production Support Data Analyst is a hands-on position with a focus on supporting the data accuracy and completeness within the enterprise data warehouse. The position will work within IT to help maintain the enterprise data warehouse architecture. Furthermore, the data warehouse architecture will measure performance in all aspects of the organization’s operations.

  ROLE RESPONSIBILITIES

  P&C ( Property and casualty insurance ) Domain experience Mandatory

  • 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

  P&C ( Property and casualty insurance ) Domain experience Mandatory

  • Proven 3+ years’ experience of data analysis within an enterprise data warehouse.
  • Possess 2 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

  P&C ( Property and casualty insurance ) Domain experience Mandatory

  • 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.

  EDUCATION REQUIREMENTS

  P&C ( Property and casualty insurance ) Domain experience Mandatory

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

  Sriram Chaganti

  Sr. Talent Acquisition Specialist

  Direct: 614–553–8303/ 614-495-9222 Ext: 289 | Fax: 866-764-1148

  E-mail: sriram.c@usgrpinc.com

• About the company

  United Software Group, Inc. (USG) is a Global Information Technology Consulting Company established in the year 2002 with its Headquarters in Columbus-Ohio, USA. USG is operating a business in 6 countries USA, Mexico, Canada, UK, Ireland and India. USG is a Minority Owned Enterprise (MBE) offering IT consulting, Talent Management and Staff Augmentation Solutions to its Clients. USG is recognized by INC5000 as Americas Fastest-Growing Private Companies and is honored with A+ rating by BBB as a mark of a trustworthy customer-oriented organization. USG’s services are based on requirements specified by operational business users from different industries such as Banking & Financial, Consumer Good and Distribution, Telecommunication, Insurance, Engineering, Healthcare, Life Sciences, Retail, Manufacturing and Automotive.

Notice