Data Analyst

Data Analyst, Data Modelling, Data Warehouse, SQL, P&C
Contract W2, Contract Corp-To-Corp
Depends on Experience

Job Description

Role: Data Analyst (Data Warehouse)

Location: Purchase, NY; Florham Park, NJ

Team: Data and Business Intelligence

Duration: 6 months Contract



The 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 client create an industry-leading data warehouse infrastructure that measures performance of all aspects of the company’s operations.


Role 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


Technical 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


General Qualifications

  • 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


Education Requirements

  • BS in Computer Science, Information Management or Statistics


About us:

Since 2002, APN Consulting has been inspiring success in IT through meaningful connections between employers and candidates. We are trusted by a vast array of companies, from small enterprises to some of the world’s most trusted brands to present the best talent for their contract, contract to hire and full-time positions. To learn more, please visit us online at

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

Similar Positions

Data Analyst (Data Warehouse)
  • Stellar Consulting Solutions
  • Florham Park, NJ, USA
Data Analyst
  • iTech Solutions
  • Florham Park, NJ, USA
Data Warehouse/Data Analyst
  • IDC Technologies
  • Morristown, NJ, USA
Senior Business Analyst/Data Analyst
  • Kforce Technology Staffing
  • Summit, NJ, USA
Senior Data Analyst
  • Eminent Software Services LLC
  • Morristown, NJ, USA
Senior Data Analyst-Hybrid Onsite
  • Perennial Resources International
  • New York, NY, USA
Data Analyst
  • Ztek Consulting
  • New York, NY, USA
Looking for _ Data Analyst
  • Quantum Integrators Group LLC
  • Somerville, NJ, USA
Technical Data Analyst
  • ITBMS Inc.
  • New York, NY, USA
Insurance Data Analyst
  • The Execu|Search Group
  • Harrison, NY, USA