Data Analyst

data analyst, analyst, data architect, data, guidewire, sql, datawarehouse, data warehouse
Contract W2, Contract Independent, 6+ mos
$60 - $68 hr

Job Description

Data Analyst

Partial Remote: Three days a week onsite required: Tuesday, Wednesday, Thursday in one of the following office locations:

Locations: Purchase, NY; Florham Park, NJ; Conshohocken, PA
All candidates will be required to be in the office 3 days a week (Tues - Thurs) to start.

Summary
The Data Architect/Data Analyst is a hands-on position focused on defining a business-driven data warehouse architecture supported by policies, principles and guidelines that are aligned with data management and data governance. The position will work within IT to help Sompo International create an industry-leading data warehouse infrastructure that measures performance of all aspects of the company s operations.

Responsibilities

  • Translates business requirements into usable enterprise information which may include an enterprise data model, common business vocabulary, taxonomies to be used to guide enterprise solution development, and achieve consistency of information assets across the application portfolio.
  • Develops and implements strategies for data acquisitions, archive recovery, and implementation of a database.
  • Develops and maintains a formal description of the data and data structures including the data models, data flow diagrams, data dictionaries and technical metadata.
  • Creates source to target mapping documents to capture application data elements for loading into data warehouse
  • Collaborates with ETL team on data model, its maintenance and optimization as well as end-to-end data driven integration strategy.
  • Monitor and guide design of a semantically rich business model of the enterprise domain, independent of any technology solution
  • Work directly with all application development teams to ensure that data is aligned between systems
Qualifications
  • 10+ years of data warehouse experience
  • 10+ years of hands-on data modeling and data architecture experience
  • 5 years P&C Insurance experience (Policy and Claims)
  • Extensive knowledge of Data Warehousing, ETL and BI architectures, concepts and frameworks
  • Capable of creating and tuning Semantic layer Reporting Views
  • Capable of facilitating data discovery sessions involving business subject matter experts.
  • Knowledge of RDBMS platforms (e.g. SQL Server, DB2) with experience in generating DDL
  • Familiar with metadata ingestion and translation
  • Knowledge of the P&C insurance business and systems such as Guidewire Policy Center, Guidewire Claims Center, SAP FS-RI & SAP FS-CD is a huge plus
  • Strong interpersonal skills and ability to work as part of a team

For more information please contact Brian Otten at or

Since 1995, iTech Solutions Inc., has been providing IT Consulting and Direct Hire Services to the Insurance, Financial, Communications, Manufacturing and Government sectors with local offices in Connecticut, Minnesota, Colorado, Massachusetts, Tennessee, North Carolina, and New Jersey / Pennsylvania area.

Our recruiting strategy is simple, if you want to find qualified IT professionals then use IT professionals to find them. So at iTech Solutions, our personnel are all career IT professionals with a wide range of IT experience. We can honestly say our staff understands the technologies, the complexities of finding and selecting the appropriate personnel and the pressures of running successful IT projects.

Employer will not sponsor applicants for any employment visas, at hiring or in the future, including but not limited to H-1B visas. Corp-to-Corp or subcontract personnel will not be considered for this position.

Dice Id : 10111560
Position Id : 21-18871
Originally Posted : 5 months ago
Have a Job? Post it

Similar Positions

DATA ANALYST
  • AR Solutions, Inc.
  • Florham Park, NJ, USA
Data Analyst
  • APN Consulting Inc
  • Florham Park, NJ, USA
Need Data Modeler @ New York
  • Technostrides
  • New York, NY, USA
Data Analyst - Insurance Industry Experience
  • MJP Associates
  • Morristown, NJ, USA
Data Modeler
  • iTech Solutions
  • Florham Park, NJ, USA
Data Analyst
  • iTech Solutions
  • Harrison, NY, USA
Data Modeler
  • Stellar Consulting Solutions
  • New York, NY, USA
Data Modeler
  • iTech Solutions
  • New York, NY, USA
Data Analyst - Insurance Industry Experience
  • MJP Associates
  • White Plains, NY, USA