Job Details

ID #42730100
State New York
City New york city
Job type Permanent
Salary USD $135,000 - $155,000 135000 - 155000
Source Perennial Resources International
Showed 2022-06-10
Date 2022-06-09
Deadline 2022-08-08
Category Architect/engineer/CAD
Create resume

Data Architect Lead-Hybrid Onsite

New York, New york city, 10017 New york city USA

Vacancy expired!

We are seeking a

Sr Data Architect to join our

Data and Business Intelligence team in our

Purchase, NY or Florham Park, NJ office.

Main areas of responsibility:The Sr. Data Architect position will work within IT to help the firm create an industry-leading data warehouse infrastructure that measures performance of all aspects of the company’s operations.

Responsibilities:
  • Translates strategic requirements into a usable enterprise information architecture
  • Designs databases, data warehouses and multidimensional databases
  • Develops and maintains a formal description of the data and data structures including the data models, data flow diagrams, data dictionaries and technical metadata
  • Develops and implements strategies for data acquisitions, archive recovery, and implementation of a database
  • Defines detailed source to target mapping from source systems into the data warehouse
  • Oversees a small group of data analysts and architects, allocates workload and ensures quality and accuracy of their deliverables
  • Defines data/information architecture standards, structure, attributes and nomenclature of data elements, and applies accepted data content standards to technology projects
  • 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

Minimum Qualifications:
  • 10+ years of BI/DW and data architecture experience.
  • 5 years P&C Insurance experience
  • 5+ years’ experience in data warehousing
  • Knowledge of Data Warehousing, ETL and BI architectures, concepts and frameworks
  • Deep knowledge of Kimball and Inmon approaches and the core differences
  • Extensive experience in data modeling principles/methods including conceptual, logical & physical Data Models.
  • Capable of facilitating data discovery sessions involving business subject matter experts.
  • Strong interpersonal skills and ability to work as part of a team
  • Experience in translating/mapping relational data models into Data Base Schemas.
  • Experience with modeling tools (such as ERWin and ER/Studio)
  • Knowledge of RDBMS platforms (e.g. SQL Server, DB2) with experience in generating DDL
  • Ability to create and maintain conceptual/business, logical and physical data models.
  • Ability to translate a logical model into a physical model, adding appropriate physical objects needed to create the database e.g. indexes.
  • Experience maintaining a model repository
  • Ability to synchronize models to ensure that database structures match models
  • Familiar with metadata ingestion and translation

Preferred 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 strongly preferred

Education:
  • BS in Computer Science, Information Management or Statistics

Vacancy expired!

Subscribe Report job