Data Architect/ OLTP Data Modeler

Posted 6 Days Ago
Be an Early Applicant
Hoboken, NJ, USA
In-Office
Senior level
Information Technology • Professional Services • Software • Consulting
The Role
Design and document transactional and dimensional data models and ER diagrams for OLTP and data warehouse systems. Ensure data integrity through testing and validation, manage projects and timelines, and liaise with end users and development teams. Preferred experience with Netezza and healthcare insurance data modeling; ERwin expertise required.
Summary Generated by Built In
Company 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:
Essential Job functions:
Determines business information needs and identifies systems requirement
Responsible for creating the Entity releationship 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 Responsibility:
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
Confers 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

Qualification:
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:-

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

Skills Required

  • 8+ years of experience in data design, data architecture and data modelling (transactional and analytic)
  • 8+ years of experience in relational and dimensional data design and modelling in a large multi-platform data environment
  • Experience with Erwin or another data modelling tool
  • Must have good written and verbal communication skills and experience interfacing with development, users and management
  • Experience with Netezza for data warehouse modeling
  • Experience with Oracle, SQL Server, or Db2 for transactional systems modelling
  • Experience with data modeling within healthcare insurance
  • Authorization to work in the U.S.; employer unable to sponsor visas
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
87 Employees
Year Founded: 2007

What We Do

SonSoft Inc. is a global consulting and IT services firm specializing in software development, software consultancy, and Information Technology Enabled Services (ITES). The company provides a range of expertise including business consulting, systems integration, application development, and product engineering, helping clients re-engineer and re-invent their businesses to compete in a changing marketplace.

Similar Jobs

Optimum Logo Optimum

Supervisor Branded Partner Direct Sales

AdTech • Digital Media • Internet of Things • Marketing Tech • Mobile • Retail • Software
Hybrid
Oakland, NJ, USA
9000 Employees
59K-96K Annually

HiBob Logo HiBob

Technical Support

HR Tech • Information Technology • Professional Services • Sales • Software
Remote or Hybrid
United States
1350 Employees
103K-129K Annually

PureSpectrum Logo PureSpectrum

AI Enablement Manager

Big Data • Marketing Tech • Sales • Software • Analytics • Big Data Analytics
Remote or Hybrid
USA
283 Employees

MetLife Logo MetLife

Manager - Short Term Disability Claims - 18583

Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Remote or Hybrid
United States
43000 Employees
85K-143K Annually

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account