Data Architect (junior)- Holmdel, NJ (HOT) - A052318

Location: Holmdel, NJ
Date Posted: 05-23-2018
Position:  Data Architect – Insurance
Location: Holmdel, NJ with occasional travel to MD
Duration: 6 Months +

Data Architect
Generic Insurance is a must. Group or Govt would be a plus.
Big data is highly preferred but not a must.
Job Duties:
Data Modeling        
Develop, document and maintain logical and physical data models that accurately reflect the existing environment and update for new projects/enhancements.  Work with DBA and other staff as necessary, to instantiate physical databases based on the models.                                                                                              
Data Analysis & Design
Review data sources and assess data quality; determine the appropriate data inputs, outputs and integration rules and strategy. Create function design specifications to be used by the developers.         
Model Management
Version and configuration manage data models so that they are consistent with development testing and production deployment environments.                                                                                                      
Information Dissemination
Publish models and metadata in the form of web pages, graphics and reports to projects, management and other interested parties in order to raise the organizational knowledge of what data exists where.
Cross-Organizational Coordination
Interface with business units, internal IT, customers and management in the performance of duties.         
We are looking to a hire a Data Architect consultant to work on our subsidiary.. The initial length of the engagement is 6 months, but will most likely get extended to 12 months, as there is a lot of work to be done. Other office is based out of Owings Mills, Maryland (outside Baltimore) but the position will be based in our office at Holmdel.

The team is looking for a highly organized person, who has architected and supported critical applications in an insurance / financial environment and is experienced in Microsoft SQL Server, SSRS, SSIS. This seasoned professional will need to interface with multiple client groups and IT senior management, providing them with data architecture solutions. timely and accurate status updates, short-term / long-term plans, release plans, etc. in a clear consistent manner that emphasizes performance metrics, strategic planning, continuous improvement and adherence to industry best practices.

Position Description
This position will be a part of Client’s Enterprise Data Office (EDO) and report into the Director – Group Data Architecture. This position entails the following activities:
  • Review and understand data requirements for all Client projects including reporting, analytics and data warehousing.
  • Collaborate with business and IT partners to refine and document system data requirements
  • Perform data analysis activities including data profiling, creation of data dictionaries, data transformation rules and integration requirements.
  • Develop, document and maintain logical and physical data models for all Client applications;
  • Coordinate across organizations as required to support data integration efforts;
  • Support and apply data standardization policies;
  • Other related activities, as assigned.
Logical and Physical Data Modeling
Expert-level data sourcing and data mapping skills.
·         Excellent written and verbal communication skills.
·         Creative problem-solving skills.
·         Ability to work independently or as part of a project team.
·         Ability to self-manage tasks to meet delivery targets.
Insurance domain knowledge; preferably with a carrier dealing with Government.
HIPAA and other regulations that govern the access of data
Relational database concepts; Strong experience in SQL Server and related technologies.
ETL concepts, preferably Informatica.
Proficient in data modeling tools -- preferably Erwin.
Strong RDBMS knowledge.
Familiarity with Big Data technologies, especially Hadoop would be highly desirable.
Familiarity with Mainframe data structures in VSAM and DB2 would be a big plus.
10+ Years of IT industry experience, with 7+ years experience as Data Architect.
Developed and implemented relational data models.
Significant experience interfacing with both customers and management.
Familiarity with Big Data technologies like Hadoop will be a plus.
Other Requirements:
The position is primarily based in Client’s Holmdel Office, New Jersey but will require day trips to office in Owings Mills, MD once in a while.

this job portal is powered by CATS