Data Architect/ OLTP Data Modeler

Sonsoft Inc; Hoboken (NJ); On-site; Full time

Job summary

A growing tech company in Hoboken, NJ is seeking a skilled Data Architect with over 8 years of experience in data design and modeling. The role involves determining business needs, creating diagrams, and managing projects within a dynamic team. Solid experience in relational databases and strong communication skills are essential. This is a full-time position; only U.S. citizens and authorized workers may apply. A great opportunity to lead important data initiatives and improve data infrastructure.

Qualifications

• 8+ years of experience in data design, architecture, and modeling.
• Experience with healthcare insurance data modeling is preferred.
• Must have interfacing experience with program development and user personnel.

Responsibilities

• Determine business information needs and identify system requirements.
• Create entity relationship diagrams and dimensional models.
• Manage complex internal and external projects.

Skills

Data design

Data architecture

Data modeling

Good communication skills

Tools

Oracle

SQL Server

DB2

Erwin

Job description

Sonsoft, Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.

Job Description

Requisition Details:

• Determines business information needs and identifies systems requirement
• Responsible for creating the Entity relationship diagrams, star schema and dimensional models
• Ensure Data integrity by analyzing, testing, validating and certifying data system tables that are consistent with business requirement and technical specification document

Key Responsibilities:

• Manage complex internal and external projects, handling tasks and deadlines, plans and prioritizes service request and assignments
• Designs and documents database structures for the data warehouse
• Confer with end user to gain understanding of needed changes or modifications of existing programs. Resolves questions of program intent, data input.
• Experience with Netezza in support of the data warehouse modeling is preferred.
• Experience with datamodeling within healthcare insurance is preferred.

Qualifications

• 8+ years of experience in data design, data architecture and data modelling (both transactional and data analytic)
• 8+ years of experience in relational and dimensional data design and modelling in a large multi-platform data environment
• Experience with Oracle/Sql server/Db2 in support of transactional systems modelling is preferred
• Experience with Erwin/any other data modelling tool is must
• Must have good written and verbal communication skills and have experience of interfacing directly with program development, user and management personnel.

Additional Information

U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.

Note:-

• This is a Fulltime job for you
• Only US Citizen, Green Card Holder, TN Visa, GC-EAD, H4-EAD & L2-EAD can apply.
• No OPT-EAD & H1B Consultants please.
• Please mention your Visa Status in your email or resume.